DBA Data[Home] [Help]

APPS.OE_BULK_HOLDS_PVT dependencies on OE_WSH_BULK_GRP

Line 116: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();

112: AND NVL( HLD.END_DATE_ACTIVE, SYSDATE )
113: ORDER BY HS.HOLD_ENTITY_CODE,HS.HOLD_ENTITY_CODE2,HS.HOLD_ENTITY_ID,
114: HS.HOLD_ENTITY_ID2;
115:
116: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;

Line 117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;

113: ORDER BY HS.HOLD_ENTITY_CODE,HS.HOLD_ENTITY_CODE2,HS.HOLD_ENTITY_ID,
114: HS.HOLD_ENTITY_ID2;
115:
116: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609

Line 118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609

114: HS.HOLD_ENTITY_ID2;
115:
116: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();

Line 119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();

115:
116: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();

Line 120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;

116: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
124: T_HOLD_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50();--ER# 3667551

Line 121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609

117: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
124: T_HOLD_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50();--ER# 3667551
125:

Line 122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();

118: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
124: T_HOLD_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50();--ER# 3667551
125:
126: l_count BINARY_INTEGER;

Line 123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();

119: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
124: T_HOLD_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50();--ER# 3667551
125:
126: l_count BINARY_INTEGER;
127: BEGIN

Line 124: T_HOLD_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50();--ER# 3667551

120: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
121: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
122: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
123: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
124: T_HOLD_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50();--ER# 3667551
125:
126: l_count BINARY_INTEGER;
127: BEGIN
128: