APPS.M4R_7B5_OSFM_PKG dependencies on PO_LINES_ARCHIVE_ALL

Line 114: FROM po_lines_archive_all

110: -- Check if there are any OSP items in the PO.
111: BEGIN
112: SELECT 'YES'
113: INTO l_osp_item_exists
114: FROM po_lines_archive_all
115: WHERE po_header_id = l_po_header_id
116: AND line_type_id IN
117: ( SELECT line_type_id
118: FROM po_line_types

Line 544: FROM po_lines_archive_all

540: INTO l_lines_chk
541: FROM dual
542: WHERE EXISTS ( (
543: SELECT po_header_id
544: FROM po_lines_archive_all
545: WHERE po_header_id = l_po_header_id
546: AND po_line_id = lines_rec.po_line_id
547: AND revision_num = l_po_rev_num_x
548: )

Line 612: g_exception_tracking_msg := 'Query po_lines_archive_all for revision_num';

608: END IF;
609:
610: IF l_raise_flag = 'Y' THEN --- Set the event parameters for Generic Outbound WF
611:
612: g_exception_tracking_msg := 'Query po_lines_archive_all for revision_num';
613:
614: -- gets the Line Revision Number
615: SELECT revision_num,vendor_product_num,item_revision,unit_meas_lookup_code
616: INTO l_line_rev_num,l_item,l_item_rv,l_uom

Line 617: FROM po_lines_archive_all

613:
614: -- gets the Line Revision Number
615: SELECT revision_num,vendor_product_num,item_revision,unit_meas_lookup_code
616: INTO l_line_rev_num,l_item,l_item_rv,l_uom
617: FROM po_lines_archive_all
618: WHERE po_header_id = l_po_header_id
619: AND po_line_id = lines_rec.po_line_id
620: AND latest_external_flag = 'Y';
621: