APPS.INL_INTEGRATION_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 495: FROM po_line_locations_all pll

491: AND (transaction_type = 'RECEIVE' OR
492: (transaction_type ='SHIP' AND auto_transact_code IN ('RECEIVE','DELIVER')))
493: AND source_document_code = 'PO'
494: AND EXISTS ( SELECT 'lcm shipment'
495: FROM po_line_locations_all pll
496: WHERE pll.line_location_id = rti.po_line_location_id
497: AND pll.lcm_flag = 'Y' )
498: AND Nvl(shipment_header_id,Header_interface_id) = currentHeaderId;
499:

Line 773: p_debug_info => 'Get values from zx_lines_det_factors and po_line_locations_all'

769:
770: INL_LOGGING_PVT.Log_Statement (
771: p_module_name => g_module_name,
772: p_procedure_name => l_proc_name,
773: p_debug_info => 'Get values from zx_lines_det_factors and po_line_locations_all'
774: );
775: SELECT zdf.trx_business_category,
776: zdf.line_intended_use,
777: zdf.product_fisc_classification,

Line 790: po_line_locations_all pll

786: l_product_type,
787: l_user_defined_fisc_class,
788: l_output_tax_classf_code
789: FROM zx_lines_det_factors zdf,
790: po_line_locations_all pll
791: WHERE pll.line_location_id = p_int_rec(i).po_line_location_id
792: AND zdf.application_id = 201
793: AND zdf.trx_id = NVL(pll.po_release_id,pll.po_header_id) --Bug 7680733
794: AND zdf.trx_line_id = pll.line_location_id

Line 958: FROM po_line_locations_all pll

954: AND (transaction_type = 'RECEIVE' OR
955: (transaction_type ='SHIP' AND auto_transact_code IN ('RECEIVE','DELIVER')))
956: AND source_document_code = 'PO'
957: AND EXISTS ( SELECT 'lcm shipment'
958: FROM po_line_locations_all pll
959: WHERE pll.line_location_id = rti.po_line_location_id
960: AND pll.lcm_flag = 'Y' )
961: AND Nvl(shipment_header_id,Header_interface_id) = Nvl(p_int_rec(i).shipment_header_id,p_int_rec(i).header_interface_id);
962: