392: AND sc.orig_sys_document_ref
393: = h.orig_sys_document_ref
394: AND sc.org_id = h.org_id)
395: AND NOT EXISTS (SELECT 'Y'
396: FROM oe_price_atts_iface_all pa
397: WHERE pa.order_source_id = h.order_source_id
398: AND pa.orig_sys_document_ref
399: = h.orig_sys_document_ref
400: AND h.org_id = pa.org_id)
457: AND sc.orig_sys_document_ref
458: = h.orig_sys_document_ref
459: AND h.org_id = sc.org_id)
460: AND NOT EXISTS (SELECT 'Y'
461: FROM oe_price_atts_iface_all pa
462: WHERE pa.order_source_id = h.order_source_id
463: AND pa.orig_sys_document_ref
464: = h.orig_sys_document_ref
465: AND h.org_id = pa.org_id)
512: = h.orig_sys_document_ref
513: AND NVL(h.org_id, l_default_org_id) =
514: NVL(sc.org_id, l_default_org_id))
515: AND NOT EXISTS (SELECT 'Y'
516: FROM oe_price_atts_iface_all pa
517: WHERE pa.order_source_id = h.order_source_id
518: AND pa.orig_sys_document_ref
519: = h.orig_sys_document_ref
520: AND NVL(h.org_id, l_default_org_id) =
737: AND sc.orig_sys_document_ref
738: = h.orig_sys_document_ref
739: AND h.org_id = sc.org_id)
740: AND NOT EXISTS (SELECT 'Y'
741: FROM oe_price_atts_iface_all pa
742: WHERE pa.order_source_id = h.order_source_id
743: AND pa.orig_sys_document_ref
744: = h.orig_sys_document_ref
745: AND h.org_id = pa.org_id)
777: = h.orig_sys_document_ref
778: AND NVL(h.org_id, l_default_org_id) =
779: NVL(sc.org_id, l_default_org_id))
780: AND NOT EXISTS (SELECT 'Y'
781: FROM oe_price_atts_iface_all pa
782: WHERE pa.order_source_id = h.order_source_id
783: AND pa.orig_sys_document_ref
784: = h.orig_sys_document_ref
785: AND NVL(h.org_id, l_default_org_id) =
823: AND sc.orig_sys_document_ref
824: = h.orig_sys_document_ref
825: AND sc.org_id = h.org_id)
826: AND NOT EXISTS (SELECT 'Y'
827: FROM oe_price_atts_iface_all pa
828: WHERE pa.order_source_id = h.order_source_id
829: AND pa.orig_sys_document_ref
830: = h.orig_sys_document_ref
831: AND pa.org_id = h.org_id )