ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4733869E053B46B63588994 select ibc.masked_card_number CARD_NUMBER, apc.check_id PAYMENT_NUMBER, apc.check_date PAYMENT_DATE, apc.vendor_name SUPPLIER_NAME, apc.amount PAYMENT_AMOUNT, decode(apline.FEE_AMOUNT,null,0, apline.fee_amount) FEE, apc.currency_code CURRENCY, iby_creditcard_pkg.Mask_Card_Number(apc.PAYCARD_AUTHORIZATION_NUMBER) AUTHORIZATION_CODE from ( (ap_paycard_trx_fee_header aphead inner join ap_paycard_trx_fee_lines apline on aphead.trx_fee_header_id = apline.trx_fee_header_id) right outer join ( ( ( (ap_card_programs_all approg inner join ap_card_profiles_all approf on approg.CARD_TYPE_LOOKUP_CODE ='PAYMENTCARD' and approg.card_program_id = approf.card_program_id ) inner join ap_cards_all apcard on apcard.card_program_id = approg.card_program_id and apcard.profile_id = approf.profile_id ) inner join ap_checks_all apc on apcard.paycard_reference_id = apc.paycard_reference_id ) inner join IBY_PAYMENTCARD ibc on apcard.paycard_reference_id = ibc.instrid ) on apc.check_date between apline.from_date and apline.to_date and aphead.org_id = approg.org_id and aphead.card_issuer_id = approg.vendor_id and aphead.card_issuer_site_id = approg.vendor_site_id and apc.currency_code = aphead.currency_code ) where apc.check_date between :P_PERIOD_FROM and nvl(:P_PERIOD_TO,to_date(to_char('31-DEC-2949'),'dd-mon-rrrr')) and apc.paycard_reference_id = nvl(:P_ACCOUNT_NUMBER, apc.paycard_reference_id ) and apc.void_date is null and apc.org_id = nvl(:P_SECURITY_ID_INT_1,apc.org_id) order by ibc.masked_card_number, apc.currency_code, apc.check_date asc Y SQLAP APTRXFEE_XML AR AP تقرير حركات بطاقات السداد Application: المدفوعات Source: تقرير حركات بطاقات السداد Short Name: APTRXFEE_XML DB package: D AP Zahlungskartentransaktionen Application: Kreditoren Source: Zahlungskartentransaktionen Short Name: APTRXFEE_XML DB package: F AP Etat des opérations par carte de paiement Application: Payables Source: Etat des opérations par carte de paiement Short Name: APTRXFEE_XML DB package: US AP Payment Card Transactions Application: Payables Source: Payment Card Transactions Report Short Name: APTRXFEE_XML DB package: ZHS AP 付款卡事务处理报表 Application: 应付帐款 Source: 付款卡事务处理报表 Short Name: APTRXFEE_XML DB package: BI Publisher :p_account_number :p_period_from :p_period_to :p_security_id_int_1 1 10 :p_security_id_int_1 LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description US P_SECURITY_ID_INT_1 2 20 :p_ledger_set LOV Oracle AP_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by l.name Y US P_LEDGER_SET 3 30 :p_period_from Date Y US P_PERIOD_FROM 4 40 :p_period_to Date US P_PERIOD_TO 5 50 :p_account_number LOV Oracle AP_PAYCARD_NUM Y select ibp.instrid id, ibp.masked_card_number value, apcard.cardmember_name description from ap_cards_all apcard,iby_paymentcard ibp,ap_card_programs_all approg where apcard.card_reference_id=ibp.instrid and apcard.card_program_id=approg.card_program_id and approg.card_type_lookup_code='PAYMENTCARD' order by value,description AR رقم بطاقة السداد D Nummer Zahlungskarte F Numéro de carte de paiement US Payment Card Number ZHS 付款卡号