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:
877: -- l_receipt_num varchar2(100);
878: -- l_asn_exist varchar2(8); -- probably to be renamed as sourceTypeFlag

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:
877: -- l_receipt_num varchar2(100);
878: -- l_asn_exist varchar2(8); -- probably to be renamed as sourceTypeFlag
879: -- l_receipt_source_code varchar2(100) := 'VENDOR';

Line 913: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD

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

Line 1026: PO_LINES_ALL POL,

1022: l_wip_operation_seq_num,
1023: l_wip_resource_seq_num,
1024: l_bom_resource_id
1025: FROM MTL_SYSTEM_ITEMS MSI,
1026: PO_LINES_ALL POL,
1027: PO_DISTRIBUTIONS_ALL POD,
1028: PO_HEADERS_ALL POH,
1029: PO_LINE_LOCATIONS_ALL POLL
1030: WHERE