APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_CREDITS_IFACE_ALL

Line 484: FROM oe_credits_iface_all sc

480: AND h.org_id = nvl(p_operating_unit,h.org_id)
481: -- Do not process orders with manual sales credits, manual
482: -- pricing attributes or with action requests other than booking
483: AND NOT EXISTS (SELECT 'Y'
484: FROM oe_credits_iface_all sc
485: WHERE sc.order_source_id = h.order_source_id
486: AND sc.orig_sys_document_ref
487: = h.orig_sys_document_ref
488: AND sc.org_id = h.org_id)

Line 549: FROM oe_credits_iface_all sc

545: AND h.org_id = nvl(p_operating_unit,h.org_id)
546: -- Do not process orders with manual sales credits, manual
547: -- pricing attributes or with action requests other than booking
548: AND NOT EXISTS (SELECT 'Y'
549: FROM oe_credits_iface_all sc
550: WHERE sc.order_source_id = h.order_source_id
551: AND sc.orig_sys_document_ref
552: = h.orig_sys_document_ref
553: AND h.org_id = sc.org_id)

Line 603: FROM oe_credits_iface_all sc

599: l_default_org_id = nvl(p_operating_unit,l_default_org_id))
600: -- Do not process orders with manual sales credits, manual
601: -- pricing attributes or with action requests other than booking
602: AND NOT EXISTS (SELECT 'Y'
603: FROM oe_credits_iface_all sc
604: WHERE sc.order_source_id = h.order_source_id
605: AND sc.orig_sys_document_ref
606: = h.orig_sys_document_ref
607: AND NVL(h.org_id, l_default_org_id) =

Line 830: FROM oe_credits_iface_all sc

826: l.top_model_line_ref is not null AND
827: p_process_configurations = 'N' )))
828:
829: AND NOT EXISTS (SELECT 'Y'
830: FROM oe_credits_iface_all sc
831: WHERE sc.order_source_id = h.order_source_id
832: AND sc.orig_sys_document_ref
833: = h.orig_sys_document_ref
834: AND h.org_id = sc.org_id)

Line 869: FROM oe_credits_iface_all sc

865: AND nvl(force_apply_flag,'Y') = 'Y'
866: AND (h.org_id is NULL AND
867: l_default_org_id = nvl(p_operating_unit,l_default_org_id))
868: AND NOT EXISTS (SELECT 'Y'
869: FROM oe_credits_iface_all sc
870: WHERE sc.order_source_id = h.order_source_id
871: AND sc.orig_sys_document_ref
872: = h.orig_sys_document_ref
873: AND NVL(h.org_id, l_default_org_id) =

Line 916: FROM oe_credits_iface_all sc

912: AND nvl(rejected_flag,'N') = 'N'
913: AND nvl(force_apply_flag,'Y') = 'Y'
914: AND h.org_id = nvl(p_operating_unit,h.org_id)
915: AND NOT EXISTS (SELECT 'Y'
916: FROM oe_credits_iface_all sc
917: WHERE sc.order_source_id = h.order_source_id
918: AND sc.orig_sys_document_ref
919: = h.orig_sys_document_ref
920: AND sc.org_id = h.org_id)