{"id":842,"date":"2012-07-25T21:08:07","date_gmt":"2012-07-25T19:08:07","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=842"},"modified":"2012-07-26T10:28:29","modified_gmt":"2012-07-26T08:28:29","slug":"sql-e-dla-modulu-platnosci-oraz-zobowiazan","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=842","title":{"rendered":"R12 – SQL-e dla modu\u0142u P\u0142atno\u015bci oraz Zobowi\u0105za\u0144"},"content":{"rendered":"

Kopia z bloga Link<\/a><\/p>\n

<\/p>\n

In this post, we will find the tables involved in storing the Payment Data related to the\u00a0 \u00a0Payable INVOICE ( Invoice_id = <\/strong>166014 <\/strong>). All the queries given in this post and their related posts were tested in R12.1.1 Instance.\u00a0<\/strong><\/div>\n
<\/div>\n
AP_TERMS<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 AP_TERMS<\/div>\n
WHERE\u00a0 term_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ( SELECT DISTINCT terms_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 AP_INVOICES_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0WHERE\u00a0 invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
AP_TERMS_LINES\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 AP_TERMS_LINES<\/div>\n
WHERE\u00a0 term_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ( SELECT DISTINCT terms_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 AP_INVOICES_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0WHERE\u00a0 invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
AP_PAYMENT_SCHEDULES_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 amount_remaining,<\/div>\n
\u00a0 batch_id,<\/div>\n
\u00a0 due_date,<\/div>\n
\u00a0 gross_amount,<\/div>\n
\u00a0 hold_flag,<\/div>\n
\u00a0 invoice_id,<\/div>\n
\u00a0 payment_num,<\/div>\n
\u00a0 SUBSTR(payment_status_flag,1,1) payment_status_flag,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_PAYMENT_SCHEDULES_ALL<\/div>\n
WHERE<\/div>\n
\u00a0 invoice_id = '166014′;<\/div>\n
<\/div>\n
AP_INVOICE_PAYMENTS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 check_id,<\/div>\n
\u00a0 SUBSTR(invoice_payment_id,1,15) invoice_payment_id,<\/div>\n
\u00a0 amount,<\/div>\n
\u00a0 payment_base_amount,<\/div>\n
\u00a0 invoice_base_amount,<\/div>\n
\u00a0 accounting_date,<\/div>\n
\u00a0 period_name,<\/div>\n
\u00a0 posted_flag,<\/div>\n
\u00a0 accounting_event_id,<\/div>\n
\u00a0 invoice_id,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_INVOICE_PAYMENTS_ALL<\/div>\n
WHERE<\/div>\n
\u00a0 invoice_id = '166014′<\/div>\n
ORDER BY check_id ASC;<\/div>\n
<\/div>\n
AP_PAYMENT_DISTRIBUTIONS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT tab.*<\/div>\n
FROM\u00a0\u00a0 AP_INVOICE_PAYMENTS_ALL aip,<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP_PAYMENT_DISTRIBUTIONS_ALL tab<\/div>\n
WHERE\u00a0 aip.invoice_payment_id = tab.invoice_payment_id<\/div>\n
AND\u00a0\u00a0\u00a0 aip.invoice_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '166014′;<\/div>\n
<\/div>\n
AP_CHECKS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 check_id,<\/div>\n
\u00a0 check_number,<\/div>\n
\u00a0 vendor_site_code,<\/div>\n
\u00a0 amount,<\/div>\n
\u00a0 base_amount,<\/div>\n
\u00a0 checkrun_id,<\/div>\n
\u00a0 checkrun_name,<\/div>\n
\u00a0 check_date,<\/div>\n
\u00a0 SUBSTR(status_lookup_code,1,15) status_lookup_code,<\/div>\n
\u00a0 void_date,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_CHECKS_ALL<\/div>\n
WHERE check_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ( SELECT DISTINCT check_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 AP_INVOICE_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE\u00a0 invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
AP_PAYMENT_HISTORY_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 payment_history_id,<\/div>\n
\u00a0 check_id,<\/div>\n
\u00a0 accounting_date,<\/div>\n
\u00a0 SUBSTR(transaction_type,1,20)\u00a0\u00a0\u00a0 transaction_type,<\/div>\n
\u00a0 posted_flag,<\/div>\n
\u00a0 SUBSTR(accounting_event_id,1,10) accounting_event_id,<\/div>\n
\u00a0 rev_pmt_hist_id,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_PAYMENT_HISTORY_ALL<\/div>\n
WHERE check_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT DISTINCT check_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM AP_INVOICE_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 )<\/div>\n
ORDER BY payment_history_id ASC;<\/div>\n
<\/div>\n
AP_PAYMENT_HIST_DISTS\u00a0<\/span><\/strong><\/div>\n
SELECT aphd.*<\/div>\n
FROM\u00a0\u00a0 AP_INVOICE_DISTRIBUTIONS_ALL aid,<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP_PAYMENT_HIST_DISTS aphd,<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP_PAYMENT_HISTORY_ALL aph<\/div>\n
WHERE\u00a0 aid.invoice_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '166014′<\/div>\n
AND\u00a0\u00a0\u00a0 aid.invoice_distribution_id = aphd.invoice_distribution_id<\/div>\n
AND\u00a0\u00a0\u00a0 aph.payment_history_id\u00a0\u00a0\u00a0\u00a0\u00a0 = aphd.payment_history_id;<\/div>\n
<\/div>\n
<\/div>\n
AP_RECON_DISTRIBUTIONS_ALL\u00a0\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM AP_RECON_DISTRIBUTIONS_ALL<\/div>\n
WHERE check_id IN<\/div>\n
\u00a0 ( SELECT check_id<\/div>\n
\u00a0\u00a0\u00a0 FROM AP_INVOICE_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0 WHERE invoice_id = '166014′<\/div>\n
\u00a0 ); <\/strong><\/div>\n
<\/div>\n
AP_DOCUMENTS_PAYABLE\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 pay_proc_trxn_type_code,<\/div>\n
\u00a0 calling_app_doc_unique_ref1 check_id,<\/div>\n
\u00a0 calling_app_doc_unique_ref2 invoice_id,<\/div>\n
\u00a0 calling_app_doc_unique_ref4 invoice_payment_id,<\/div>\n
\u00a0 calling_app_doc_ref_number invoice_number,<\/div>\n
\u00a0 payment_function,<\/div>\n
\u00a0 payment_date,<\/div>\n
\u00a0 document_date,<\/div>\n
\u00a0 document_type,<\/div>\n
\u00a0 payment_currency_code,<\/div>\n
\u00a0 payment_amount,<\/div>\n
\u00a0 payment_method_code<\/div>\n
FROM<\/div>\n
\u00a0 AP_DOCUMENTS_PAYABLE<\/div>\n
WHERE calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200\u00a0 — Application id for Payables<\/em><\/div>\n
AND\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′;<\/div>\n
<\/div>\n
IBY_DOCS_PAYABLE_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 IBY_DOCS_PAYABLE_ALL<\/div>\n
WHERE\u00a0 calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200<\/div>\n
AND\u00a0\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′;<\/div>\n
<\/div>\n
IBY_PAYMENTS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 IBY_PAYMENTS_ALL<\/div>\n
WHERE\u00a0 payment_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT payment_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 IBY_DOCS_PAYABLE_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE\u00a0\u00a0 calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND\u00a0\u00a0\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
IBY_PAY_INSTRUCTIONS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 IBY_PAY_INSTRUCTIONS_ALL<\/div>\n
WHERE\u00a0 payment_instruction_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT payment_instruction_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM IBY_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE payment_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT payment_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 IBY_DOCS_PAYABLE_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE\u00a0\u00a0 calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND\u00a0\u00a0\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
\n
In this post, we will find the tables involved in storing the Payment Data related to the\u00a0 \u00a0Payable INVOICE ( Invoice_id = <\/strong>166014 <\/strong>). All the queries given in this post and their related posts were tested in R12.1.1 Instance.\u00a0<\/strong><\/div>\n
<\/div>\n
AP_TERMS<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 AP_TERMS<\/div>\n
WHERE\u00a0 term_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ( SELECT DISTINCT terms_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 AP_INVOICES_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0WHERE\u00a0 invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
AP_TERMS_LINES\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 AP_TERMS_LINES<\/div>\n
WHERE\u00a0 term_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ( SELECT DISTINCT terms_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 AP_INVOICES_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0WHERE\u00a0 invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
AP_PAYMENT_SCHEDULES_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 amount_remaining,<\/div>\n
\u00a0 batch_id,<\/div>\n
\u00a0 due_date,<\/div>\n
\u00a0 gross_amount,<\/div>\n
\u00a0 hold_flag,<\/div>\n
\u00a0 invoice_id,<\/div>\n
\u00a0 payment_num,<\/div>\n
\u00a0 SUBSTR(payment_status_flag,1,1) payment_status_flag,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_PAYMENT_SCHEDULES_ALL<\/div>\n
WHERE<\/div>\n
\u00a0 invoice_id = '166014′;<\/div>\n
<\/div>\n
AP_INVOICE_PAYMENTS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 check_id,<\/div>\n
\u00a0 SUBSTR(invoice_payment_id,1,15) invoice_payment_id,<\/div>\n
\u00a0 amount,<\/div>\n
\u00a0 payment_base_amount,<\/div>\n
\u00a0 invoice_base_amount,<\/div>\n
\u00a0 accounting_date,<\/div>\n
\u00a0 period_name,<\/div>\n
\u00a0 posted_flag,<\/div>\n
\u00a0 accounting_event_id,<\/div>\n
\u00a0 invoice_id,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_INVOICE_PAYMENTS_ALL<\/div>\n
WHERE<\/div>\n
\u00a0 invoice_id = '166014′<\/div>\n
ORDER BY check_id ASC;<\/div>\n
<\/div>\n
AP_PAYMENT_DISTRIBUTIONS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT tab.*<\/div>\n
FROM\u00a0\u00a0 AP_INVOICE_PAYMENTS_ALL aip,<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP_PAYMENT_DISTRIBUTIONS_ALL tab<\/div>\n
WHERE\u00a0 aip.invoice_payment_id = tab.invoice_payment_id<\/div>\n
AND\u00a0\u00a0\u00a0 aip.invoice_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '166014′;<\/div>\n
<\/div>\n
AP_CHECKS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 check_id,<\/div>\n
\u00a0 check_number,<\/div>\n
\u00a0 vendor_site_code,<\/div>\n
\u00a0 amount,<\/div>\n
\u00a0 base_amount,<\/div>\n
\u00a0 checkrun_id,<\/div>\n
\u00a0 checkrun_name,<\/div>\n
\u00a0 check_date,<\/div>\n
\u00a0 SUBSTR(status_lookup_code,1,15) status_lookup_code,<\/div>\n
\u00a0 void_date,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_CHECKS_ALL<\/div>\n
WHERE check_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 ( SELECT DISTINCT check_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 AP_INVOICE_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE\u00a0 invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
AP_PAYMENT_HISTORY_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 payment_history_id,<\/div>\n
\u00a0 check_id,<\/div>\n
\u00a0 accounting_date,<\/div>\n
\u00a0 SUBSTR(transaction_type,1,20)\u00a0\u00a0\u00a0 transaction_type,<\/div>\n
\u00a0 posted_flag,<\/div>\n
\u00a0 SUBSTR(accounting_event_id,1,10) accounting_event_id,<\/div>\n
\u00a0 rev_pmt_hist_id,<\/div>\n
\u00a0 org_id<\/div>\n
FROM<\/div>\n
\u00a0 AP_PAYMENT_HISTORY_ALL<\/div>\n
WHERE check_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT DISTINCT check_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM AP_INVOICE_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE invoice_id = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 )<\/div>\n
ORDER BY payment_history_id ASC;<\/div>\n
<\/div>\n
AP_PAYMENT_HIST_DISTS\u00a0<\/span><\/strong><\/div>\n
SELECT aphd.*<\/div>\n
FROM\u00a0\u00a0 AP_INVOICE_DISTRIBUTIONS_ALL aid,<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP_PAYMENT_HIST_DISTS aphd,<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP_PAYMENT_HISTORY_ALL aph<\/div>\n
WHERE\u00a0 aid.invoice_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '166014′<\/div>\n
AND\u00a0\u00a0\u00a0 aid.invoice_distribution_id = aphd.invoice_distribution_id<\/div>\n
AND\u00a0\u00a0\u00a0 aph.payment_history_id\u00a0\u00a0\u00a0\u00a0\u00a0 = aphd.payment_history_id;<\/div>\n
<\/div>\n
<\/div>\n
AP_RECON_DISTRIBUTIONS_ALL\u00a0\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM AP_RECON_DISTRIBUTIONS_ALL<\/div>\n
WHERE check_id IN<\/div>\n
\u00a0 ( SELECT check_id<\/div>\n
\u00a0\u00a0\u00a0 FROM AP_INVOICE_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0 WHERE invoice_id = '166014′<\/div>\n
\u00a0 ); <\/strong><\/div>\n
<\/div>\n
AP_DOCUMENTS_PAYABLE\u00a0<\/span><\/strong><\/div>\n
SELECT<\/div>\n
\u00a0 pay_proc_trxn_type_code,<\/div>\n
\u00a0 calling_app_doc_unique_ref1 check_id,<\/div>\n
\u00a0 calling_app_doc_unique_ref2 invoice_id,<\/div>\n
\u00a0 calling_app_doc_unique_ref4 invoice_payment_id,<\/div>\n
\u00a0 calling_app_doc_ref_number invoice_number,<\/div>\n
\u00a0 payment_function,<\/div>\n
\u00a0 payment_date,<\/div>\n
\u00a0 document_date,<\/div>\n
\u00a0 document_type,<\/div>\n
\u00a0 payment_currency_code,<\/div>\n
\u00a0 payment_amount,<\/div>\n
\u00a0 payment_method_code<\/div>\n
FROM<\/div>\n
\u00a0 AP_DOCUMENTS_PAYABLE<\/div>\n
WHERE calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200\u00a0 — Application id for Payables<\/em><\/div>\n
AND\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′;<\/div>\n
<\/div>\n
IBY_DOCS_PAYABLE_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 IBY_DOCS_PAYABLE_ALL<\/div>\n
WHERE\u00a0 calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200<\/div>\n
AND\u00a0\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′;<\/div>\n
<\/div>\n
IBY_PAYMENTS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 IBY_PAYMENTS_ALL<\/div>\n
WHERE\u00a0 payment_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT payment_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 IBY_DOCS_PAYABLE_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE\u00a0\u00a0 calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND\u00a0\u00a0\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n
IBY_PAY_INSTRUCTIONS_ALL\u00a0<\/span><\/strong><\/div>\n
SELECT *<\/div>\n
FROM\u00a0\u00a0 IBY_PAY_INSTRUCTIONS_ALL<\/div>\n
WHERE\u00a0 payment_instruction_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT payment_instruction_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM IBY_PAYMENTS_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE payment_id IN<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SELECT payment_id<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM\u00a0\u00a0 IBY_DOCS_PAYABLE_ALL<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE\u00a0\u00a0 calling_app_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 200<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND\u00a0\u00a0\u00a0\u00a0 calling_app_doc_unique_ref2 = '166014′<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 );<\/div>\n
<\/div>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Kopia z bloga Link<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[21,149,97],"tags":[244,247,148],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/842"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=842"}],"version-history":[{"count":4,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/842\/revisions"}],"predecessor-version":[{"id":850,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/842\/revisions\/850"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}