应收应付明细

**

AP应付 1.payments 付款 2.Invoices 发票

**
1.AP_PAYMENTS :
AP_CHECKS_ALL AC,
AP_SUPPLIERS AV,
XLA.xla_ae_headers h,
XLA.xla_ae_lines l,
XLA.xla_transaction_entities te,
gl_import_references ir
where条件的关联
AC.VENDOR_ID = AV.VENDOR_ID(+)
and ac.party_id=hp.party_id
AND TE.SOURCE_ID_INT_1 = AC.CHECK_ID
AND te.application_id = h.application_id
and te.entity_id = h.entity_id
AND H.AE_HEADER_ID = L.AE_HEADER_ID
AND ir.gl_sl_link_id = l.gl_sl_link_id
and ir.gl_sl_link_table = l.gl_sl_link_table
and te.entity_code = ‘AP_PAYMENTS’
2.AP_INVOICES :
ap_invoices_all ACA,
– Ap_Invoice_Distributions_ALL APD,
AP_SUPPLIERS AV,
XLA.xla_ae_headers h,
XLA.xla_ae_lines l,
XLA.xla_transaction_entities te,
gl_import_references ir,
HZ_PARTIES HP
where条件的关联
ACA.VENDOR_ID = AV.VENDOR_ID(+)
and acA.party_id=hp.party_id
AND TE.SOURCE_ID_INT_1 = ACA.invoice_id
AND te.application_id = h.application_id
– AND ACA.Invoice_Id=APD.Invoice_Id
– AND L.Code_Combination_Id=APD.Dist_Code_Combination_Id
and te.entity_id = h.entity_id
AND H.AE_HEADER_ID = L.AE_HEADER_ID
AND ir.gl_sl_link_id = l.gl_sl_link_id
and ir.gl_sl_link_table = l.gl_sl_link_table
and te.entity_code = ‘AP_INVOICES’

AR应收 1.Receipts 收据 2.Transactions 事务处理

1.Receipts 收据
AR_CASH_RECEIPTS_ALL ar,
(SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID CUSTOMER_ID, PARTY.party_name,c.account_number
FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
HZ_PARTY_SITES PARTY_SITE,
HZ_CUST_SITE_USES_ALL SITE_USES,
Hz_Parties PARTY,
HZ_CUST_ACCOUNTS C
WHERE PARTY.party_id = PARTY_SITE.PARTY_ID
AND PARTY.PARTY_ID = C.PARTY_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE_USES.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
and c.cust_account_id=ACCT_SITE.CUST_ACCOUNT_ID) AR_VENDOR,
XLA.xla_ae_headers h,
XLA.xla_ae_lines l,
XLA.xla_transaction_entities te,
gl_import_references ir
WHERE AR_VENDOR.CUSTOMER_ID = ar.pay_from_customer
AND TE.SOURCE_ID_INT_1 = ar.cash_receipt_id
AND te.application_id = h.application_id
and te.entity_id = h.entity_id
AND H.AE_HEADER_ID = L.AE_HEADER_ID
AND ir.gl_sl_link_id = l.gl_sl_link_id
and ir.gl_sl_link_table = l.gl_sl_link_table
and te.entity_code = ‘RECEIPTS’
and te.application_id = ？？？
2.Transactions 事务处理
ra_customer_trx_all ra,
(SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID CUSTOMER_ID, PARTY.party_name,C.Account_Number
FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
HZ_PARTY_SITES PARTY_SITE,
HZ_CUST_SITE_USES_ALL SITE_USES,
Hz_Parties PARTY,
HZ_CUST_ACCOUNTS C
WHERE PARTY.party_id = PARTY_SITE.PARTY_ID
AND PARTY.PARTY_ID = C.PARTY_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE_USES.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
and c.cust_account_id=ACCT_SITE.CUST_ACCOUNT_ID) AR_VENDOR,
XLA.xla_ae_headers h,
XLA.xla_ae_lines l,
XLA.xla_transaction_entities te,
gl_import_references ir
WHERE AR_VENDOR.CUSTOMER_ID = RA.BILL_TO_CUSTOMER_ID
AND TE.SOURCE_ID_INT_1 = ra.customer_trx_id
AND te.application_id = h.application_id
and te.entity_id = h.entity_id
AND H.AE_HEADER_ID = L.AE_HEADER_ID
AND ir.gl_sl_link_id = l.gl_sl_link_id
and ir.gl_sl_link_table = l.gl_sl_link_table
and te.entity_code = ‘TRANSACTIONS’
and te.application_id = ？？？？