DBA Data[Home] [Help]

APPS.OE_ELECMSGS_PVT dependencies on OE_LOTSERIALS_IFACE_ALL

Line 2578: FROM OE_LotSerials_Iface_All

2574:
2575: -- Start MOAC
2576: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2577: DELETE
2578: FROM OE_LotSerials_Iface_All
2579: WHERE order_source_id = p_order_source_id
2580: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2581: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2582: AND orig_sys_line_ref IS NOT NULL

Line 2608: FROM OE_LotSerials_Iface_All

2604:
2605: -- Start MOAC
2606: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2607: DELETE
2608: FROM OE_LotSerials_Iface_All
2609: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2610: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2611: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2612: AND orig_sys_line_ref IS NOT NULL