DBA Data[Home] [Help]

APPS.OE_BULK_HOLDS_PVT dependencies on OE_HOLD_DEFINITIONS

Line 103: OE_HOLD_DEFINITIONS HLD

99: HS.HOLD_ENTITY_CODE2,
100: HLD.ACTIVITY_NAME,
101: HS.HOLD_ID --ER# 3667551
102: FROM OE_HOLD_SOURCES HS,
103: OE_HOLD_DEFINITIONS HLD
104: WHERE --ER#7479609 HS.HOLD_ENTITY_CODE IN ('C','I','B','W','S')
105: HS.HOLD_ENTITY_CODE IN ('C','I','B','D','W','S','PL','OT','CD','SC','P','SM','EC','IC') --ER#7479609 --ER# 12571983 added ,'EC' --ER# 13331078 added 'IC'
106: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
107: ROUND( SYSDATE )