APPS.POR_RCV_ORD_SV dependencies on PO_LINES_ALL

Line 874: X_MATCHING_BASIS PO_LINES_ALL.MATCHING_BASIS%TYPE;

870: l_wip_operation_seq_num NUMBER:= 0;
871: l_wip_resource_seq_num NUMBER:= 0;
872: l_bom_resource_id NUMBER:= 0;
873: l_req_distribution_id NUMBER:= NULL;
874: X_MATCHING_BASIS PO_LINES_ALL.MATCHING_BASIS%TYPE;
875: X_JOB_ID PO_LINES_ALL.JOB_ID%TYPE;
876: --Bug 8893932 PO RECEIVED FROM IPROCUREMENT DOESNT POPULATE COUNTRY OF ORIGIN
877: l_country_of_origin PO_LINE_LOCATIONS_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE;
878: -- l_receipt_num varchar2(100);

Line 875: X_JOB_ID PO_LINES_ALL.JOB_ID%TYPE;

871: l_wip_resource_seq_num NUMBER:= 0;
872: l_bom_resource_id NUMBER:= 0;
873: l_req_distribution_id NUMBER:= NULL;
874: X_MATCHING_BASIS PO_LINES_ALL.MATCHING_BASIS%TYPE;
875: X_JOB_ID PO_LINES_ALL.JOB_ID%TYPE;
876: --Bug 8893932 PO RECEIVED FROM IPROCUREMENT DOESNT POPULATE COUNTRY OF ORIGIN
877: l_country_of_origin PO_LINE_LOCATIONS_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE;
878: -- l_receipt_num varchar2(100);
879: -- l_asn_exist varchar2(8); -- probably to be renamed as sourceTypeFlag

Line 914: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD

910: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_employee_id :' || x_employee_id );
911:
912: SELECT POL.MATCHING_BASIS, POL.JOB_ID
913: INTO X_MATCHING_BASIS, X_JOB_ID
914: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD
915: WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
916: AND POD.PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID;
917:
918: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_MATCHING_BASIS' || X_MATCHING_BASIS);

Line 1031: PO_LINES_ALL POL,

1027: l_bom_resource_id,
1028: --Bug 8893932 PO RECEIVED FROM IPROCUREMENT DOESNT POPULATE COUNTRY OF ORIGIN
1029: l_country_of_origin
1030: FROM MTL_SYSTEM_ITEMS MSI,
1031: PO_LINES_ALL POL,
1032: PO_DISTRIBUTIONS_ALL POD,
1033: PO_HEADERS_ALL POH,
1034: PO_LINE_LOCATIONS_ALL POLL
1035: WHERE