APPS.M4R_7B5_OSFM_PKG dependencies on PO_LINES_ALL

Line 108: g_exception_tracking_msg := 'Query po_lines_all into l_osp_item_exists';

104: -- Check for OSP items depending upon the PO type.
105:
106: IF (l_po_doc_type = 'RELEASE' OR l_po_doc_type = 'STANDARD' OR l_po_doc_type = 'PO') THEN
107:
108: g_exception_tracking_msg := 'Query po_lines_all into l_osp_item_exists';
109:
110: -- Check if there are any OSP items in the PO.
111: BEGIN
112: SELECT 'YES'

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