DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_HOLD_SOURCES

Line 8060: oe_order_holds ooh,oe_hold_sources ohs,oe_hold_releases ohr

8056: adj_debug('Hold Id :'||l_hold_source_rec.hold_id);
8057: Begin
8058: --changed select below to fix bug 3039915
8059: select 'Y' into l_gsa_released from
8060: oe_order_holds ooh,oe_hold_sources ohs,oe_hold_releases ohr
8061: where ooh.line_id = p_line_id
8062: and ooh.hold_source_id = ohs.hold_source_id
8063: and ohr.hold_release_id = ooh.hold_release_id
8064: and ohs.hold_id = l_hold_source_rec.hold_id