DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_HOLD_SOURCES

Line 7968: oe_order_holds ooh,oe_hold_sources ohs,oe_hold_releases ohr

7964: adj_debug('Hold Id :'||l_hold_source_rec.hold_id);
7965: Begin
7966: --changed select below to fix bug 3039915
7967: select 'Y' into l_gsa_released from
7968: oe_order_holds ooh,oe_hold_sources ohs,oe_hold_releases ohr
7969: where ooh.line_id = p_line_id
7970: and ooh.hold_source_id = ohs.hold_source_id
7971: and ohr.hold_release_id = ooh.hold_release_id
7972: and ohs.hold_id = l_hold_source_rec.hold_id