APPS.PO_CORE_S dependencies on PO_HISTORY_POS_ALL

Line 5915: FROM po_history_pos_all ph

5911: into l_duplicate_exists
5912: from sys.dual
5913: where not exists
5914: (SELECT 'po number is not unique'
5915: FROM po_history_pos_all ph
5916: WHERE ph.segment1 = p_segment1
5917: AND ph.type_lookup_code IN
5918: ('STANDARD','CONTRACT','BLANKET','PLANNED')
5919: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));

Line 5962: FROM po_history_pos_all ph

5958: into l_duplicate_exists
5959: from sys.dual
5960: where not exists
5961: (SELECT 'rfq number is not unique'
5962: FROM po_history_pos_all ph
5963: WHERE ph.segment1 = p_segment1
5964: AND ph.type_lookup_code = 'RFQ'
5965: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5966:

Line 5994: FROM po_history_pos_all ph

5990: into l_duplicate_exists
5991: from sys.dual
5992: where not exists
5993: (SELECT 'quote number is not unique'
5994: FROM po_history_pos_all ph
5995: WHERE ph.segment1 = p_segment1
5996: AND ph.type_lookup_code = 'QUOTATION'
5997: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5998: