APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_CREDITS_IFACE_ALL

Line 390: FROM oe_credits_iface_all sc

386: AND h.org_id = nvl(p_operating_unit,h.org_id)
387: -- Do not process orders with manual sales credits, manual
388: -- pricing attributes or with action requests other than booking
389: AND NOT EXISTS (SELECT 'Y'
390: FROM oe_credits_iface_all sc
391: WHERE sc.order_source_id = h.order_source_id
392: AND sc.orig_sys_document_ref
393: = h.orig_sys_document_ref
394: AND sc.org_id = h.org_id)

Line 455: FROM oe_credits_iface_all sc

451: AND h.org_id = nvl(p_operating_unit,h.org_id)
452: -- Do not process orders with manual sales credits, manual
453: -- pricing attributes or with action requests other than booking
454: AND NOT EXISTS (SELECT 'Y'
455: FROM oe_credits_iface_all sc
456: WHERE sc.order_source_id = h.order_source_id
457: AND sc.orig_sys_document_ref
458: = h.orig_sys_document_ref
459: AND h.org_id = sc.org_id)

Line 509: FROM oe_credits_iface_all sc

505: l_default_org_id = nvl(p_operating_unit,l_default_org_id))
506: -- Do not process orders with manual sales credits, manual
507: -- pricing attributes or with action requests other than booking
508: AND NOT EXISTS (SELECT 'Y'
509: FROM oe_credits_iface_all sc
510: WHERE sc.order_source_id = h.order_source_id
511: AND sc.orig_sys_document_ref
512: = h.orig_sys_document_ref
513: AND NVL(h.org_id, l_default_org_id) =

Line 735: FROM oe_credits_iface_all sc

731: l.top_model_line_ref is not null AND
732: p_process_configurations = 'N' )))
733:
734: AND NOT EXISTS (SELECT 'Y'
735: FROM oe_credits_iface_all sc
736: WHERE sc.order_source_id = h.order_source_id
737: AND sc.orig_sys_document_ref
738: = h.orig_sys_document_ref
739: AND h.org_id = sc.org_id)

Line 774: FROM oe_credits_iface_all sc

770: AND nvl(force_apply_flag,'Y') = 'Y'
771: AND (h.org_id is NULL AND
772: l_default_org_id = nvl(p_operating_unit,l_default_org_id))
773: AND NOT EXISTS (SELECT 'Y'
774: FROM oe_credits_iface_all sc
775: WHERE sc.order_source_id = h.order_source_id
776: AND sc.orig_sys_document_ref
777: = h.orig_sys_document_ref
778: AND NVL(h.org_id, l_default_org_id) =

Line 821: FROM oe_credits_iface_all sc

817: AND nvl(rejected_flag,'N') = 'N'
818: AND nvl(force_apply_flag,'Y') = 'Y'
819: AND h.org_id = nvl(p_operating_unit,h.org_id)
820: AND NOT EXISTS (SELECT 'Y'
821: FROM oe_credits_iface_all sc
822: WHERE sc.order_source_id = h.order_source_id
823: AND sc.orig_sys_document_ref
824: = h.orig_sys_document_ref
825: AND sc.org_id = h.org_id)