eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 29: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,

25: container_index NUMBER,
26: gross_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
27: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
28: volume WSH_DELIVERY_DETAILS.volume%TYPE,
29: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
30: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
31: -- J: W/V Changes
32: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
33: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,

Line 737: SELECT wsh_delivery_assignments_s.nextval

733: SELECT wsh_delivery_details_s.nextval
734: FROM sys.dual;
735:
736: CURSOR Get_Wda_Nextval IS
737: SELECT wsh_delivery_assignments_s.nextval
738: FROM sys.dual;
739:
740: l_cont_instance_id NUMBER;
741: l_cont_name VARCHAR2(50);

Line 1357: FROM wsh_delivery_assignments

1353: CURSOR Check_Hierarchy (v_detail_id NUMBER) IS
1354: SELECT 'NOT EMPTY' FROM DUAL
1355: WHERE EXISTS (
1356: SELECT delivery_detail_id
1357: FROM wsh_delivery_assignments
1358: WHERE parent_delivery_detail_id = v_detail_id
1359: AND NVL(type, 'S') in ('C', 'S')
1360: AND rownum < 2
1361: UNION

Line 1363: FROM wsh_delivery_assignments

1359: AND NVL(type, 'S') in ('C', 'S')
1360: AND rownum < 2
1361: UNION
1362: SELECT delivery_detail_id
1363: FROM wsh_delivery_assignments
1364: WHERE delivery_detail_id = v_detail_id
1365: AND parent_delivery_detail_id IS NOT NULL
1366: AND NVL(type, 'S') in ('C', 'S')
1367: AND rownum < 2);

Line 1638: FROM wsh_delivery_assignments_v

1634: p_check_credit_holds IN BOOLEAN) IS
1635:
1636: CURSOR Get_First_Line (v_cont_instance_id NUMBER) IS
1637: SELECT delivery_detail_id
1638: FROM wsh_delivery_assignments_v
1639: WHERE parent_delivery_detail_id = v_cont_instance_id
1640: AND rownum < 2;
1641:
1642: CURSOR Get_Cont_Item IS

Line 2206: FROM wsh_delivery_assignments wda,

2202: CURSOR Get_Cont (v_detail_id NUMBER) IS
2203: SELECT wda.parent_delivery_detail_id container_instance_id, wda.delivery_id,
2204: wddp.organization_id, nvl(wddp.line_direction,'O'), -- K LPN CONV. rv
2205: wddp.container_flag -- K: MDC
2206: FROM wsh_delivery_assignments wda,
2207: wsh_delivery_details wddp -- K LPN CONV. rv
2208: WHERE wda.delivery_detail_id = v_detail_id
2209: AND wda.parent_delivery_detail_id = wddp.delivery_detail_id(+)
2210: AND NVL(wda.type, 'S') in ('S', 'C');

Line 3191: FROM wsh_delivery_assignments_v

3187:
3188: -- remove this cursor for Bug
3189: CURSOR Get_First_Line (v_cont_instance_id NUMBER) IS
3190: SELECT delivery_detail_id
3191: FROM wsh_delivery_assignments_v
3192: WHERE parent_delivery_detail_id = v_cont_instance_id
3193: AND rownum < 2;
3194: -- remove this cursor for Bug
3195:

Line 3643: FROM wsh_delivery_assignments_v

3639:
3640: -- remove this cursor
3641: CURSOR Get_First_Line (v_cont_instance_id NUMBER) IS
3642: SELECT delivery_detail_id
3643: FROM wsh_delivery_assignments_v
3644: WHERE parent_delivery_detail_id = v_cont_instance_id
3645: AND rownum < 2;
3646: -- remove this cursor
3647:

Line 5598: wsh_delivery_assignments_v wda,

5594: wda.parent_delivery_detail_id parent_delivery_detail_id,
5595: wda.delivery_id delivery_id, -- added delivery id
5596: msi.indivisible_flag indivisible_flag
5597: FROM WSH_DELIVERY_DETAILS wdd,
5598: wsh_delivery_assignments_v wda,
5599: MTL_SYSTEM_ITEMS msi,
5600: WSH_TMP wt
5601: WHERE wdd.delivery_detail_id = wt.id
5602: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 7272: UPDATE wsh_delivery_assignments_v

7268: END IF;
7269: -- K LPN CONV. rv
7270:
7271: FORALL cnt IN 1..g_assign_detail_tab.COUNT
7272: UPDATE wsh_delivery_assignments_v
7273: SET PARENT_DELIVERY_DETAIL_ID = l_contlist(cnt),
7274: last_update_date = SYSDATE,
7275: last_updated_by = FND_GLOBAL.USER_ID,
7276: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7611: UPDATE wsh_delivery_assignments_v

7607: END IF;
7608: -- End of OTM R12 : assign delivery detail
7609:
7610: FORALL cnt IN 1..g_new_contid_tab.COUNT
7611: UPDATE wsh_delivery_assignments_v
7612: SET delivery_id = l_dellist1(cnt),
7613: last_update_date = SYSDATE,
7614: last_updated_by = FND_GLOBAL.USER_ID,
7615: last_update_login = FND_GLOBAL.LOGIN_ID

Line 8007: FROM wsh_delivery_assignments_v wda,

8003:
8004:
8005: CURSOR Get_Delivery_Lines (v_delivery_id NUMBER) IS
8006: SELECT wda.delivery_detail_id
8007: FROM wsh_delivery_assignments_v wda,
8008: WSH_DELIVERY_DETAILS wdd
8009: WHERE wda.delivery_id = v_delivery_id
8010: AND wda.delivery_id IS NOT NULL
8011: AND wda.parent_delivery_detail_id IS NULL

Line 10568: wsh_delivery_assignments_v wda

10564: wdd.delivery_detail_id,
10565: wda.parent_delivery_detail_id parent_delivery_detail_id,
10566: nvl(wdd.detail_container_item_id,wdd.master_container_item_id) detail_container_item_id
10567: FROM wsh_delivery_details wdd,
10568: wsh_delivery_assignments_v wda
10569: WHERE wdd.delivery_detail_id = c_dd_id
10570: AND wdd.delivery_detail_id = wda.delivery_detail_id
10571: AND source_code = 'WSH';
10572:

Line 12151: FROM wsh_delivery_assignments_v

12147:
12148:
12149: CURSOR Get_Child_Containers(v_cont_instance_id NUMBER) IS
12150: SELECT delivery_detail_id
12151: FROM wsh_delivery_assignments_v
12152: START WITH delivery_detail_id = v_cont_instance_id
12153: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
12154:
12155: CURSOR Get_Cont_Flag (v_detail_id NUMBER) IS

Line 12321: FROM wsh_delivery_assignments_v

12317: x_return_status OUT NOCOPY VARCHAR2) IS
12318:
12319: CURSOR Get_Contents (v_detail_id NUMBER) IS
12320: SELECT count(*)
12321: FROM wsh_delivery_assignments_v
12322: START WITH delivery_detail_id = v_detail_id
12323: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
12324:
12325: CURSOR Get_Cont_Count (v_cont_id NUMBER) IS

Line 12327: FROM wsh_delivery_assignments_v

12323: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
12324:
12325: CURSOR Get_Cont_Count (v_cont_id NUMBER) IS
12326: SELECT count(*)
12327: FROM wsh_delivery_assignments_v
12328: WHERE delivery_detail_id IN
12329: (SELECT delivery_detail_id
12330: FROM WSH_DELIVERY_DETAILS
12331: WHERE container_flag = 'Y')

Line 12540: wsh_delivery_assignments_v wda,

12536: wnd.name,
12537: wnd.status_code,
12538: wda.delivery_detail_id
12539: from wsh_delivery_details wdd,
12540: wsh_delivery_assignments_v wda,
12541: wsh_new_deliveries wnd
12542: where wdd.container_name = p_lpn_name
12543: and wdd.container_flag = 'Y'
12544: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 12784: UPDATE wsh_delivery_assignments_v

12780: -- End of Code for DBI Project
12781: --
12782: -- Assign container to delivery
12783: --
12784: UPDATE wsh_delivery_assignments_v
12785: SET delivery_id = p_delivery_id,
12786: last_update_date = SYSDATE,
12787: last_updated_by = FND_GLOBAL.USER_ID,
12788: last_update_login = FND_GLOBAL.LOGIN_ID

Line 12795: UPDATE wsh_delivery_assignments_v

12791: --
12792: -- Assign lines to container
12793: --
12794: FORALL i IN p_lines_tbl.FIRST..p_lines_tbl.LAST
12795: UPDATE wsh_delivery_assignments_v
12796: SET parent_delivery_detail_id = l_container_instance_id,
12797: last_update_date = SYSDATE,
12798: last_updated_by = FND_GLOBAL.USER_ID,
12799: last_update_login = FND_GLOBAL.LOGIN_ID

Line 13039: wsh_delivery_assignments_v wda

13035: DELETE WSH_DELIVERY_DETAILS
13036: WHERE DELIVERY_DETAIL_ID IN (
13037: SELECT wdd.delivery_detail_id
13038: FROM wsh_delivery_details wdd,
13039: wsh_delivery_assignments_v wda
13040: WHERE wda.delivery_id = p_delivery_id
13041: AND wda.delivery_detail_id = wdd.delivery_detail_id
13042: AND NVL(wdd.container_flag,'N') = 'Y'
13043: )

Line 13051: DELETE wsh_delivery_assignments_v

13047: IF l_lines_tbl.COUNT > 0
13048: THEN
13049: --{
13050: FORALL i IN l_lines_tbl.FIRST..l_lines_tbl.LAST
13051: DELETE wsh_delivery_assignments_v
13052: WHERE delivery_detail_id = l_lines_tbl(i);
13053: --}
13054: END IF;
13055: --

Line 13060: UPDATE wsh_delivery_assignments_v

13056: --
13057: --
13058: -- Unassign all lines from containers.
13059: --
13060: UPDATE wsh_delivery_assignments_v
13061: SET parent_delivery_detail_id = NULL,
13062: last_update_date = SYSDATE,
13063: last_updated_by = FND_GLOBAL.USER_ID,
13064: last_update_login = FND_GLOBAL.LOGIN_ID

Line 13305: FROM wsh_delivery_assignments

13301: FROM wsh_delivery_details
13302: --WHERE container_flag = 'Y'
13303: WHERE delivery_detail_id IN
13304: (SELECT delivery_detail_id
13305: FROM wsh_delivery_assignments
13306: START WITH parent_delivery_detail_id = v_container_id
13307: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id
13308: )
13309: FOR UPDATE NOWAIT;

Line 13401: from wsh_delivery_details d, wsh_delivery_assignments a

13397: x_return_status OUT NOCOPY VARCHAR2) IS
13398:
13399: cursor c_get_container_info(p_delivery_detail_id in number) is
13400: select d.container_flag, a.delivery_id, a.parent_delivery_id, d.inventory_item_id, d.organization_id
13401: from wsh_delivery_details d, wsh_delivery_assignments a
13402: where d.delivery_detail_id = p_delivery_detail_id
13403: and d.container_flag in ('Y', 'C')
13404: and a.type in ('C', 'S')
13405: and a.delivery_detail_id = d.delivery_detail_id

Line 13436: FROM wsh_delivery_assignments_v

13432: and d2.delivery_type = 'CONSOLIDATION';
13433:
13434: cursor c_get_child_details(p_parent_detail_id in number) IS
13435: SELECT delivery_detail_id
13436: FROM wsh_delivery_assignments_v
13437: WHERE parent_delivery_detail_id = p_parent_detail_id;
13438:
13439: /*CURSOR Get_Cont_Item_Info (v_cont_item_id NUMBER, v_org_id NUMBER) IS
13440: SELECT Container_Type_Code, weight_uom_code, volume_uom_code,

Line 13849: delete from wsh_delivery_assignments

13845: -- is now a consol LPN, the consolidation record should be on the
13846: -- topmost children currently assigned to the parent, so we need
13847: -- to delete the parent's consolidation record.
13848:
13849: delete from wsh_delivery_assignments
13850: where delivery_detail_id = p_parent_container_id
13851: and type = 'C';
13852:
13853:

Line 13895: update wsh_delivery_assignments

13891: -- Update the outer assignment to be 'O', and null out
13892: -- its parent delivery detail id which is now a consolidation LPN.
13893:
13894: FORALL i in 1..l_child_details_tab.count
13895: update wsh_delivery_assignments
13896: set parent_delivery_detail_id = NULL,
13897: type = 'O'
13898: where delivery_detail_id = l_child_details_tab(i)
13899: and NVL(type, 'S') = 'S';

Line 13907: update wsh_delivery_assignments

13903: -- Step 2.
13904: -- Now update the consol LPN's delivery assignment to be the consol delivery,
13905: -- and set its parent delivery id to be NULL.
13906:
13907: update wsh_delivery_assignments
13908: set delivery_id = l_new_parent_delivery_id,
13909: parent_delivery_id = NULL,
13910: type = 'S'
13911: where delivery_detail_id = p_parent_container_id;

Line 14028: update wsh_delivery_assignments

14024: -- consol delivery. The child LPN is also assigned to the same consol delivery.
14025: -- All we need to do now is to update the child's consolidation record to
14026: -- create the assignment.
14027:
14028: update wsh_delivery_assignments
14029: set parent_delivery_detail_id = p_parent_container_id
14030: where delivery_detail_id = p_child_container_id
14031: and type = 'C';
14032:

Line 14256: wsh_delivery_assignments wda,

14252: wdd2.weight_uom_code,
14253: wdd2.volume_uom_code
14254: from wsh_delivery_details wdd1,
14255: wsh_delivery_details wdd2,
14256: wsh_delivery_assignments wda,
14257: wsh_new_deliveries wnd
14258: where wdd1.delivery_detail_id = p_dd_id
14259: and wda.delivery_detail_id = wdd1.delivery_detail_id
14260: and wda.type = 'C'

Line 14270: from wsh_delivery_assignments

14266: order by wdd2.delivery_detail_id;
14267:
14268: cursor c_check_empty_consol(p_consol_lpn_id in number) is
14269: select delivery_detail_id
14270: from wsh_delivery_assignments
14271: where parent_delivery_detail_id = p_consol_lpn_id
14272: and type = 'C'
14273: and rownum = 1;
14274:

Line 14462: update wsh_delivery_assignments

14458:
14459: END LOOP;
14460:
14461: FORALL i in 1..p_delivery_details_tab.count
14462: update wsh_delivery_assignments
14463: set parent_delivery_detail_id = NULL
14464: where delivery_detail_id = p_delivery_details_tab(i)
14465: and type = 'C';
14466:

Line 14544: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

14540: x_return_status OUT NOCOPY VARCHAR2) IS
14541:
14542: CURSOR get_deliver_to_location_id (p_cont_id NUMBER) IS
14543: SELECT wdd.deliver_to_location_id
14544: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
14545: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
14546: AND wda.parent_delivery_detail_id = p_cont_id;
14547:
14548: cnt NUMBER := 0;