DBA Data[Home] [Help]

APPS.OE_ELECMSGS_PVT dependencies on OE_RESERVTNS_IFACE_ALL

Line 2794: FROM OE_Reservtns_Iface_All

2790:
2791: -- Start MOAC
2792: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2793: DELETE
2794: FROM OE_Reservtns_Iface_All
2795: WHERE order_source_id = p_order_source_id
2796: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2797: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2798: AND orig_sys_line_ref IS NOT NULL

Line 2824: FROM OE_Reservtns_Iface_All

2820:
2821: -- Start MOAC
2822: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2823: DELETE
2824: FROM OE_Reservtns_Iface_All
2825: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2826: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2827: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2828: AND orig_sys_line_ref IS NOT NULL