APPS.JAI_PA_COSTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 90: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */

86:
87: pv_transaction_source in varchar2,
88: pv_line_type in varchar2,
89: pn_transaction_header_id in number,
90: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */
91: pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
92: pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
93: pn_transaction_qty in number default null,
94: pn_currency_conv_rate in number default null

Line 560: ( select invoice_id, invoice_distribution_id from ap_invoice_distributions_all

556: from JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b
557: where a.tax_id = b.tax_id
558: and nvl(b.mod_cr_percentage, 0) = 0
559: and (a.invoice_id, a.parent_invoice_distribution_id) =
560: ( select invoice_id, invoice_distribution_id from ap_invoice_distributions_all
561: where invoice_id = pn_transaction_header_id and distribution_line_number = pn_transaction_dist_id);
562:
563: -- Added by Jia Li for Tax inclusive Computations on 2007/11/27, Begin
564: -- TD16-Changed Project Costing

Line 584: ap_invoice_distributions_all

580: ( SELECT
581: invoice_id
582: , invoice_distribution_id
583: FROM
584: ap_invoice_distributions_all
585: WHERE invoice_id = pn_transaction_header_id
586: AND distribution_line_number = pn_transaction_dist_id);
587: ---------------------------------------------------------------------------------------
588: -- Added by Jia Li for Tax inclusive Computations on 2007/11/27, End

Line 1796: ap_invoice_distributions_all aida

1792: pda.accrue_on_receipt_flag,
1793: aida.project_id
1794: FROM ap_invoices_all aia,
1795: po_distributions_all pda,
1796: ap_invoice_distributions_all aida
1797: WHERE aia.invoice_id = cp_invoice_id
1798: AND aida.invoice_id = aia.invoice_id
1799: AND pda.po_distribution_id = aida.po_distribution_id
1800: AND aida.distribution_line_number = cp_dist_line_num

Line 1844: from ap_invoice_distributions_all

1840:
1841:
1842: select count(*)
1843: into v_inv_num
1844: from ap_invoice_distributions_all
1845: where po_distribution_id = rec_get_po_dtls.po_distribution_id
1846: and pa_addition_flag not in ('Z','T','E','Y');
1847:
1848: IF v_inv_num = 0 THEN