DBA Data[Home] [Help]

APPS.PO_THIRD_PARTY_STOCK_GRP dependencies on DUAL

Line 739: FROM dual

735: BEGIN
736: -- Returns 1 if there exist a VMI or consign ASL within the current OU
737: SELECT count('x')
738: INTO l_count_exist_TPS_ASL
739: FROM dual
740: WHERE exists
741: ( SELECT 'X'
742: FROM po_approved_supplier_list pasl,
743: po_vendor_sites pvs ,

Line 978: FROM dual

974: -- 3. VMI release lines
975: -- 4. Consigned shipments
976: SELECT COUNT('x')
977: INTO l_open
978: FROM dual
979: WHERE EXISTS
980: (SELECT 'x'
981: FROM po_headers_all
982: WHERE consigned_consumption_flag = 'Y'