DBA Data[Home] [Help]

APPS.OE_BULK_HOLDS_PVT dependencies on OE_HOLD_DEFINITIONS

Line 66: OE_HOLD_DEFINITIONS HLD

62: HS.HOLD_ENTITY_ID2,
63: HS.HOLD_ENTITY_CODE2,
64: HLD.ACTIVITY_NAME
65: FROM OE_HOLD_SOURCES HS,
66: OE_HOLD_DEFINITIONS HLD
67: WHERE --ER#7479609 HS.HOLD_ENTITY_CODE IN ('C','I','B','W','S')
68: HS.HOLD_ENTITY_CODE IN ('C','I','B','D','W','S','PL','OT','CD','SC','P','SM') --ER#7479609
69: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
70: ROUND( SYSDATE )