APPS.PO_CORE_S dependencies on PO_HISTORY_POS_ALL

Line 5707: FROM po_history_pos_all ph

5703: into l_duplicate_exists
5704: from sys.dual
5705: where not exists
5706: (SELECT 'po number is not unique'
5707: FROM po_history_pos_all ph
5708: WHERE ph.segment1 = p_segment1
5709: AND ph.type_lookup_code IN
5710: ('STANDARD','CONTRACT','BLANKET','PLANNED')
5711: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));

Line 5754: FROM po_history_pos_all ph

5750: into l_duplicate_exists
5751: from sys.dual
5752: where not exists
5753: (SELECT 'rfq number is not unique'
5754: FROM po_history_pos_all ph
5755: WHERE ph.segment1 = p_segment1
5756: AND ph.type_lookup_code = 'RFQ'
5757: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5758:

Line 5786: FROM po_history_pos_all ph

5782: into l_duplicate_exists
5783: from sys.dual
5784: where not exists
5785: (SELECT 'quote number is not unique'
5786: FROM po_history_pos_all ph
5787: WHERE ph.segment1 = p_segment1
5788: AND ph.type_lookup_code = 'QUOTATION'
5789: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5790: