DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 67: 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 */

63:
64: pv_transaction_source in varchar2,
65: pv_line_type in varchar2,
66: pn_transaction_header_id in number,
67: 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 */
68: pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
69: pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
70: pn_transaction_qty in number default null,
71: pn_currency_conv_rate in number default null

Line 537: ( select invoice_id, invoice_distribution_id from ap_invoice_distributions_all

533: from JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b
534: where a.tax_id = b.tax_id
535: and nvl(b.mod_cr_percentage, 0) = 0
536: and (a.invoice_id, a.parent_invoice_distribution_id) =
537: ( select invoice_id, invoice_distribution_id from ap_invoice_distributions_all
538: where invoice_id = pn_transaction_header_id and distribution_line_number = pn_transaction_dist_id);
539:
540: -- Added by Jia Li for Tax inclusive Computations on 2007/11/27, Begin
541: -- TD16-Changed Project Costing

Line 561: ap_invoice_distributions_all

557: ( SELECT
558: invoice_id
559: , invoice_distribution_id
560: FROM
561: ap_invoice_distributions_all
562: WHERE invoice_id = pn_transaction_header_id
563: AND distribution_line_number = pn_transaction_dist_id);
564: ---------------------------------------------------------------------------------------
565: -- Added by Jia Li for Tax inclusive Computations on 2007/11/27, End