APPS.OE_SYNC_ORDER_PVT dependencies on OE_ORDER_HOLDS_ALL

Line 458: oe_order_holds_all ohld

454: ,ohdr.org_id
455: ,ohdr.order_source_id
456: ,ohld.released_flag
457: FROM oe_order_headers_all ohdr,
458: oe_order_holds_all ohld
459: WHERE ohdr.header_id = ohld.header_id
460: AND ohdr.order_source_id = 28
461: AND ohld.hold_source_id = p_hold_source_id
462: AND decode(p_change_type,'RELEASE',ohld.hold_release_id,-99)