DBA Data[Home] [Help]

APPS.OE_BULK_VALIDATE dependencies on QP_LIST_HEADERS

Line 941: FROM qp_list_headers_vl

937: FROM OE_HEADERS_IFACE_ALL b
938: WHERE batch_id = p_batch_id and
939: b.price_list_id IS NOT NULL and
940: NOT EXISTS (select list_header_id
941: FROM qp_list_headers_vl
942: WHERE list_header_id = b.price_list_id
943: and list_type_code in ('PRL', 'AGR') and
944: nvl(active_flag,'Y') ='Y')
945: ;

Line 980: FROM qp_list_headers_vl

976: FROM OE_HEADERS_IFACE_ALL
977: WHERE batch_id = p_batch_id)
978: AND b.price_list_id IS NOT NULL and
979: NOT EXISTS (select list_header_id
980: FROM qp_list_headers_vl
981: WHERE list_header_id = b.price_list_id
982: and list_type_code in ('PRL', 'AGR') and
983: nvl(active_flag,'Y') ='Y');
984:

Line 2127: FROM QP_LIST_HEADERS

2123: AND a.order_source_id = h.order_source_id
2124: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2125: AND a.list_header_id IS NOT NULL
2126: AND NOT EXISTS (SELECT 'Y'
2127: FROM QP_LIST_HEADERS
2128: WHERE LIST_HEADER_ID = a.list_header_id
2129: );
2130:
2131: IF g_error_count = 0 THEN