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;
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
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();
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();
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
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:
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;
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
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: