APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_PRICE_ATTS_IFACE_ALL

Line 490: FROM oe_price_atts_iface_all pa

486: AND sc.orig_sys_document_ref
487: = h.orig_sys_document_ref
488: AND sc.org_id = h.org_id)
489: AND NOT EXISTS (SELECT 'Y'
490: FROM oe_price_atts_iface_all pa
491: WHERE pa.order_source_id = h.order_source_id
492: AND pa.orig_sys_document_ref
493: = h.orig_sys_document_ref
494: AND h.org_id = pa.org_id)

Line 555: FROM oe_price_atts_iface_all pa

551: AND sc.orig_sys_document_ref
552: = h.orig_sys_document_ref
553: AND h.org_id = sc.org_id)
554: AND NOT EXISTS (SELECT 'Y'
555: FROM oe_price_atts_iface_all pa
556: WHERE pa.order_source_id = h.order_source_id
557: AND pa.orig_sys_document_ref
558: = h.orig_sys_document_ref
559: AND h.org_id = pa.org_id)

Line 610: FROM oe_price_atts_iface_all pa

606: = h.orig_sys_document_ref
607: AND NVL(h.org_id, l_default_org_id) =
608: NVL(sc.org_id, l_default_org_id))
609: AND NOT EXISTS (SELECT 'Y'
610: FROM oe_price_atts_iface_all pa
611: WHERE pa.order_source_id = h.order_source_id
612: AND pa.orig_sys_document_ref
613: = h.orig_sys_document_ref
614: AND NVL(h.org_id, l_default_org_id) =

Line 836: FROM oe_price_atts_iface_all pa

832: AND sc.orig_sys_document_ref
833: = h.orig_sys_document_ref
834: AND h.org_id = sc.org_id)
835: AND NOT EXISTS (SELECT 'Y'
836: FROM oe_price_atts_iface_all pa
837: WHERE pa.order_source_id = h.order_source_id
838: AND pa.orig_sys_document_ref
839: = h.orig_sys_document_ref
840: AND h.org_id = pa.org_id)

Line 876: FROM oe_price_atts_iface_all pa

872: = h.orig_sys_document_ref
873: AND NVL(h.org_id, l_default_org_id) =
874: NVL(sc.org_id, l_default_org_id))
875: AND NOT EXISTS (SELECT 'Y'
876: FROM oe_price_atts_iface_all pa
877: WHERE pa.order_source_id = h.order_source_id
878: AND pa.orig_sys_document_ref
879: = h.orig_sys_document_ref
880: AND NVL(h.org_id, l_default_org_id) =

Line 922: FROM oe_price_atts_iface_all pa

918: AND sc.orig_sys_document_ref
919: = h.orig_sys_document_ref
920: AND sc.org_id = h.org_id)
921: AND NOT EXISTS (SELECT 'Y'
922: FROM oe_price_atts_iface_all pa
923: WHERE pa.order_source_id = h.order_source_id
924: AND pa.orig_sys_document_ref
925: = h.orig_sys_document_ref
926: AND pa.org_id = h.org_id )