eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1531: from ap_invoice_distributions_all

1527: from
1528: (select
1529: INVOICE_DISTRIBUTION_ID inv_dist_id,
1530: row_number() over(ORDER BY INVOICE_DISTRIBUTION_ID) line_num
1531: from ap_invoice_distributions_all
1532: where INVOICE_ID=p_invoice_id
1533: )
1534: where inv_dist_id=p_line_id;
1535:

Line 1591: lr_inv_dist_id ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID%type;

1587: lr_service_type jai_rgm_trx_records.service_type_code%type;
1588: lr_called_from varchar2(20) default null;
1589:
1590: lr_line_number number;
1591: lr_inv_dist_id ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID%type;
1592:
1593: /*Addition Ends for bug 7172723*/
1594:
1595: lr_refs_rec c_get_refs_rec%rowtype;

Line 1940: cursor c_get_po_reference (cp_invoice_id ap_invoice_distributions_all.invoice_id%type

1936: and rctl.customer_trx_line_id = cp_customer_trx_line_id;
1937:
1938: lr_inv_attr c_chk_ar_inv_attr%rowtype;
1939:
1940: cursor c_get_po_reference (cp_invoice_id ap_invoice_distributions_all.invoice_id%type
1941: ,cp_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type
1942: )
1943: is
1944: select pod.po_header_id

Line 1941: ,cp_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type

1937:
1938: lr_inv_attr c_chk_ar_inv_attr%rowtype;
1939:
1940: cursor c_get_po_reference (cp_invoice_id ap_invoice_distributions_all.invoice_id%type
1941: ,cp_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type
1942: )
1943: is
1944: select pod.po_header_id
1945: ,pod.po_line_id

Line 1948: ,ap_invoice_distributions_all apd

1944: select pod.po_header_id
1945: ,pod.po_line_id
1946: ,apd.rcv_transaction_id /*Added by vkantamn for Bug#6083978*/
1947: from po_distributions_all pod
1948: ,ap_invoice_distributions_all apd
1949: where pod.po_distribution_id = apd.po_distribution_id
1950: and apd.invoice_id = cp_invoice_id
1951: and apd.invoice_distribution_id = cp_distribution_id;
1952:

Line 1964: , ap_invoice_distributions_all aida

1960: jail.invoice_id
1961: , jail.invoice_line_number
1962: FROM
1963: jai_ap_invoice_lines jail
1964: , ap_invoice_distributions_all aida
1965: WHERE jail.invoice_id = aida.invoice_id
1966: AND jail.invoice_line_number = aida.invoice_line_number
1967: AND jail.invoice_id = lp_invoice_id
1968: AND aida.invoice_line_number = lp_invoice_line_number; -- Modified by Lion for bug#6977917

Line 2234: ,ap_invoice_distributions_all apd

2230: select recs.service_type_code
2231: from jai_rgm_trx_records recs
2232: ,jai_rgm_trx_refs refs
2233: ,po_distributions_all pod
2234: ,ap_invoice_distributions_all apd
2235: where pod.po_line_id = p_document_line_id
2236: and pod.po_distribution_id = apd.po_distribution_id
2237: and apd.invoice_distribution_id = refs.item_line_id
2238: and recs.reference_id = refs.reference_id