APPS.M4R_7B5_OSFM_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 287: FROM po_lines_all l, po_line_locations_all ll, po_distributions_all d

283:
284: CURSOR M4R_7B5_OSFM_C1(l_po_header_id NUMBER, l_po_rel_id NUMBER)
285: IS
286: SELECT l.po_header_id,ll.po_line_id,ll.line_location_id,d.PO_DISTRIBUTION_ID
287: FROM po_lines_all l, po_line_locations_all ll, po_distributions_all d
288: WHERE l.po_header_id = l_po_header_id
289: AND l.line_type_id IN (
290: SELECT line_type_id
291: FROM po_line_types

Line 651: g_exception_tracking_msg := 'Query PO_DISTRIBUTIONS_ALL for WIP parameters';

647: cln_debug_pub.Add('Line Location ID : ' || l_line_loc_id, 1);
648: cln_debug_pub.Add('Line Location Revision Number : ' || l_line_loc_rev_num, 1);
649: END IF;
650:
651: g_exception_tracking_msg := 'Query PO_DISTRIBUTIONS_ALL for WIP parameters';
652:
653: -- gets the WIP attributs
654: SELECT WIP_ENTITY_ID,WIP_OPERATION_SEQ_NUM,DESTINATION_ORGANIZATION_ID,(QUANTITY_ORDERED-QUANTITY_CANCELLED)
655: INTO l_wip_entity_id,l_rout_seq_num,l_osfm_org_id,l_dist_quant_ord

Line 656: FROM PO_DISTRIBUTIONS_ALL

652:
653: -- gets the WIP attributs
654: SELECT WIP_ENTITY_ID,WIP_OPERATION_SEQ_NUM,DESTINATION_ORGANIZATION_ID,(QUANTITY_ORDERED-QUANTITY_CANCELLED)
655: INTO l_wip_entity_id,l_rout_seq_num,l_osfm_org_id,l_dist_quant_ord
656: FROM PO_DISTRIBUTIONS_ALL
657: WHERE po_header_id = l_po_header_id
658: AND po_line_id = lines_rec.po_line_id
659: AND ((po_release_id = l_po_rel_id) OR (po_release_id IS NULL))
660: AND line_location_id = l_line_loc_id