DBA Data[Home] [Help]

APPS.M4R_7B5_OSFM_PKG dependencies on PO_HEADERS_ARCHIVE_ALL

Line 143: FROM po_headers_archive_all

139:
140: IF l_po_doc_type = 'RELEASE' THEN
141: SELECT vendor_id,vendor_site_id,org_id,revision_num
142: INTO l_party_id,l_party_site_id,l_org_id,l_po_rev_num
143: FROM po_headers_archive_all
144: WHERE po_header_id = l_po_header_id
145: AND latest_external_flag = 'Y';
146: ELSE
147: SELECT vendor_id,vendor_site_id,org_id,revision_num

Line 149: FROM po_headers_archive_all

145: AND latest_external_flag = 'Y';
146: ELSE
147: SELECT vendor_id,vendor_site_id,org_id,revision_num
148: INTO l_party_id,l_party_site_id,l_org_id,l_po_rev_num
149: FROM po_headers_archive_all
150: WHERE po_header_id = l_po_header_id
151: AND revision_num = l_po_rev_num;
152: END IF;
153:

Line 404: FROM po_headers_archive_all

400: g_exception_tracking_msg := 'Query po_headers_all for dates, cancel flag';
401:
402: SELECT creation_date,revised_date,cancel_flag
403: INTO l_creation_date,l_rev_date,l_cancel_flag
404: FROM po_headers_archive_all
405: WHERE po_header_id = l_po_header_id
406: AND ((revision_num = l_po_rev_num) OR (revision_num IS NULL));
407:
408: IF (g_debug_level <= 1) THEN

Line 886: g_exception_tracking_msg := 'Query po_headers_archive_all to find Header change between current and previous revision';

882: END IF;
883:
884: IF p_release_id IS NULL THEN
885:
886: g_exception_tracking_msg := 'Query po_headers_archive_all to find Header change between current and previous revision';
887:
888: BEGIN
889: SELECT f.ship_to_location_id,t.ship_to_location_id,
890: f.bill_to_location_id,t.bill_to_location_id,

Line 907: FROM po_headers_archive_all f, po_headers_archive_all t

903: l_from_vendor_site_id,l_to_vendor_site_id,
904: l_from_amount_limit,l_to_amount_limit,
905: l_from_start_date,l_to_start_date,
906: l_from_end_date,l_to_end_date
907: FROM po_headers_archive_all f, po_headers_archive_all t
908: WHERE f.po_header_id = p_header_id
909: AND f.revision_num = p_revision_num
910: AND t.po_header_id = p_header_id
911: AND t.revision_num = p_revision_num-1;