APPS.PA_TRX_IMPORT dependencies on PO_DISTRIBUTIONS_ALL

Line 10924: from po_distributions_all

10920: where request_id = g_request_id
10921: and status_code = 'P'
10922: and (document_header_id, document_distribution_id) in
10923: (select po_header_id, po_distribution_id
10924: from po_distributions_all
10925: where po_distribution_id in
10926: (select po_distribution_id
10927: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti
10928: where inv.invoice_id = pti.cdl_system_reference2

Line 13061: FROM po_distributions_all

13057: AND invoice_distribution_id = p_sys_ref5;
13058:
13059: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13060: SELECT po_line_id
13061: FROM po_distributions_all
13062: WHERE po_distribution_id = p_po_dist_id;
13063:
13064: CURSOR c_get_vendor_id IS
13065: SELECT a.vendor_id

Line 13189: l_po_line_id po_distributions_all.po_line_id%TYPE;

13185: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
13186: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
13187: L_RAW_BC_PACKET_ID NUMBER;
13188: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
13189: l_po_line_id po_distributions_all.po_line_id%TYPE;
13190: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/
13191:
13192: CURSOR c_curr_raw_pkt IS
13193: SELECT bc_packet_id

Line 13974: FROM po_distributions_all

13970: AND invoice_distribution_id = p_sys_ref5 ;
13971:
13972: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13973: SELECT po_line_id
13974: FROM po_distributions_all
13975: WHERE po_distribution_id = p_po_dist_id;
13976:
13977: /*bug 13601768*/
13978: CURSOR c_get_vendor_id IS

Line 14068: l_po_line_id po_distributions_all.po_line_id%TYPE;

14064: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14065: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14066: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14067: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
14068: l_po_line_id po_distributions_all.po_line_id%TYPE;
14069: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/
14070:
14071: BEGIN
14072:

Line 14886: FROM po_distributions_all

14882: FROM dual;
14883:
14884: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
14885: SELECT po_line_id
14886: FROM po_distributions_all
14887: WHERE po_distribution_id = p_po_dist_id;
14888:
14889: -- Added for 13966205
14890: CURSOR C_GET_EI_DATE IS

Line 14986: l_po_line_id po_distributions_all.po_line_id%TYPE;

14982:
14983: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14984: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14985: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14986: l_po_line_id po_distributions_all.po_line_id%TYPE;
14987: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE; -- Aded for 16451280
14988:
14989: BEGIN
14990: