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.PA_TRX_IMPORT dependencies on PO_DISTRIBUTIONS

Line 9649: po_distributions d

9645: a.budget_version_id
9646: from pa_bc_packets a,
9647: pa_transaction_interface b, -- moac changes
9648: ap_invoice_distributions c,
9649: po_distributions d
9650: where a.txn_interface_id = b.txn_interface_id
9651: and a.document_header_id = d.po_header_id
9652: and a.document_distribution_id = d.po_distribution_id
9653: and c.invoice_id = b.cdl_system_reference2

Line 10106: from po_distributions_all

10102: where request_id = g_request_id
10103: and status_code = 'P'
10104: and (document_header_id, document_distribution_id) in
10105: (select po_header_id, po_distribution_id
10106: from po_distributions_all
10107: where po_distribution_id in
10108: (select po_distribution_id
10109: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti
10110: where inv.invoice_id = pti.cdl_system_reference2

Line 10388: from Po_distributions

10384: Select nvl(accrue_on_receipt_flag,'N'),
10385: po_header_id
10386: Into l_acc_flag,
10387: l_po_hdr_id
10388: from Po_distributions
10389: where po_distribution_id = l_po_dist_id;
10390:
10391: IF PG_DEBUG = 'Y' THEN
10392: log_message('log_message: ' || 'Receipt Acc Flag = ' || l_acc_flag || ' Po Hdr = ' || l_po_hdr_id);

Line 10791: po_distributions pod --Added for Bug#3693974

10787:
10788: select sum(nvl(accounted_dr,0)-nvl(accounted_cr,0)),SUM(POD.rate)/SUM(1)
10789: into l_pkt_summ,l_pkt_rate
10790: from pa_bc_packets bcc,
10791: po_distributions pod --Added for Bug#3693974
10792: where pod.po_header_id = p_sys_ref2
10793: and pod.po_distribution_id = p_sys_ref3
10794: and ((
10795: bcc.document_type = 'PO'

Line 10818: po_distributions pod --Added for Bug#3693974

10814:
10815: select sum(nvl(accounted_dr,0)-nvl(accounted_cr,0)),SUM(POD.rate)/SUM(1)
10816: into l_com_summ,l_com_rate
10817: from pa_bc_commitments bcc,
10818: po_distributions pod --Added for Bug#3693974
10819: where pod.po_header_id = p_sys_ref2
10820: and pod.po_distribution_id = p_sys_ref3
10821: and ((
10822: bcc.document_type = 'PO'

Line 12155: FROM po_distributions_all

12151: AND invoice_distribution_id = p_sys_ref5;
12152:
12153: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
12154: SELECT po_line_id
12155: FROM po_distributions_all
12156: WHERE po_distribution_id = p_po_dist_id;
12157:
12158: -- R12 Funds Management : This cursor can fetches both Raw and Burden Lines for commitment
12159: -- to be relieved.

Line 12270: l_po_line_id po_distributions_all.po_line_id%TYPE;

12266: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
12267: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
12268: L_RAW_BC_PACKET_ID NUMBER;
12269: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
12270: l_po_line_id po_distributions_all.po_line_id%TYPE;
12271:
12272:
12273: CURSOR c_curr_raw_pkt IS
12274: SELECT bc_packet_id

Line 13039: FROM po_distributions_all

13035: AND invoice_distribution_id = p_sys_ref5;
13036:
13037: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13038: SELECT po_line_id
13039: FROM po_distributions_all
13040: WHERE po_distribution_id = p_po_dist_id;
13041:
13042: Cursor C_Ap_Commitment Is
13043: Select bcc.Set_Of_Books_Id

Line 13119: l_po_line_id po_distributions_all.po_line_id%TYPE;

13115: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
13116: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
13117: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
13118: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
13119: l_po_line_id po_distributions_all.po_line_id%TYPE;
13120:
13121: BEGIN
13122:
13123: IF PG_DEBUG = 'Y' THEN

Line 13926: FROM po_distributions_all

13922: FROM dual;
13923:
13924: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13925: SELECT po_line_id
13926: FROM po_distributions_all
13927: WHERE po_distribution_id = p_po_dist_id;
13928:
13929: Cursor C_po_Commitment Is
13930: Select bcc.Set_Of_Books_Id

Line 13956: po_distributions pod

13952: ,bcc.bc_packet_id
13953: ,bcc.packet_id
13954: ,bcc.bc_commitment_id
13955: From Pa_Bc_Commitments_all bcc,
13956: po_distributions pod
13957: -- R12 Funds management Uptake : For fixing performance issues removing the code for CC which is obsolete for R12
13958: -- Modifying code to use Index on document_header_id and document_distribution_id of bc commitments
13959: where bcc.document_header_id = pod.po_header_id
13960: and bcc.document_distribution_id = pod.po_distribution_id

Line 13999: po_distributions pod

13995: ,bcc.packet_id
13996: -- R12 Funds management Uptake : For fixing performance issues removing the code for CC which is obsolete for R12
13997: -- Modifying code to use Index on document_header_id and document_distribution_id of bc commitments
13998: From Pa_Bc_packets bcc,
13999: po_distributions pod
14000: where bcc.document_header_id = pod.po_header_id
14001: and bcc.document_distribution_id = pod.po_distribution_id
14002: and bcc.project_id = pod.project_id -- Bug# 4479105
14003: and bcc.task_id = pod.task_id --Bug# 4479105

Line 14016: l_po_line_id po_distributions_all.po_line_id%TYPE;

14012:
14013: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14014: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14015: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14016: l_po_line_id po_distributions_all.po_line_id%TYPE;
14017:
14018: BEGIN
14019:
14020: IF PG_DEBUG = 'Y' THEN