75: AND NVL( HLD.END_DATE_ACTIVE, SYSDATE )
76: ORDER BY HS.HOLD_ENTITY_CODE,HS.HOLD_ENTITY_CODE2,HS.HOLD_ENTITY_ID,
77: HS.HOLD_ENTITY_ID2;
78:
79: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
80: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
76: ORDER BY HS.HOLD_ENTITY_CODE,HS.HOLD_ENTITY_CODE2,HS.HOLD_ENTITY_ID,
77: HS.HOLD_ENTITY_ID2;
78:
79: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
80: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
77: HS.HOLD_ENTITY_ID2;
78:
79: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
80: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
85: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
78:
79: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
80: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
85: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
86: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
79: T_HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
80: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
85: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
86: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
87:
80: --ER#7479609 T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
85: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
86: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
87:
88: l_count BINARY_INTEGER;
81: T_HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
85: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
86: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
87:
88: l_count BINARY_INTEGER;
89: BEGIN
82: T_HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
83: --ER#7479609 T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM;
84: T_HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50(); --ER#7479609
85: T_HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
86: T_HOLD_ACTIVITY_NAME OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
87:
88: l_count BINARY_INTEGER;
89: BEGIN
90: