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_V

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 1611: FROM wsh_delivery_assignments_v

1607: p_check_credit_holds IN BOOLEAN) IS
1608:
1609: CURSOR Get_First_Line (v_cont_instance_id NUMBER) IS
1610: SELECT delivery_detail_id
1611: FROM wsh_delivery_assignments_v
1612: WHERE parent_delivery_detail_id = v_cont_instance_id
1613: AND rownum < 2;
1614:
1615: CURSOR Get_Cont_Item IS

Line 3137: FROM wsh_delivery_assignments_v

3133:
3134: -- remove this cursor for Bug
3135: CURSOR Get_First_Line (v_cont_instance_id NUMBER) IS
3136: SELECT delivery_detail_id
3137: FROM wsh_delivery_assignments_v
3138: WHERE parent_delivery_detail_id = v_cont_instance_id
3139: AND rownum < 2;
3140: -- remove this cursor for Bug
3141:

Line 3589: FROM wsh_delivery_assignments_v

3585:
3586: -- remove this cursor
3587: CURSOR Get_First_Line (v_cont_instance_id NUMBER) IS
3588: SELECT delivery_detail_id
3589: FROM wsh_delivery_assignments_v
3590: WHERE parent_delivery_detail_id = v_cont_instance_id
3591: AND rownum < 2;
3592: -- remove this cursor
3593:

Line 5526: wsh_delivery_assignments_v wda,

5522: wda.parent_delivery_detail_id parent_delivery_detail_id,
5523: wda.delivery_id delivery_id, -- added delivery id
5524: msi.indivisible_flag indivisible_flag
5525: FROM WSH_DELIVERY_DETAILS wdd,
5526: wsh_delivery_assignments_v wda,
5527: MTL_SYSTEM_ITEMS msi,
5528: WSH_TMP wt
5529: WHERE wdd.delivery_detail_id = wt.id
5530: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 7186: UPDATE wsh_delivery_assignments_v

7182: END IF;
7183: -- K LPN CONV. rv
7184:
7185: FORALL cnt IN 1..g_assign_detail_tab.COUNT
7186: UPDATE wsh_delivery_assignments_v
7187: SET PARENT_DELIVERY_DETAIL_ID = l_contlist(cnt),
7188: last_update_date = SYSDATE,
7189: last_updated_by = FND_GLOBAL.USER_ID,
7190: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7481: UPDATE wsh_delivery_assignments_v

7477: END IF;
7478: -- End of OTM R12 : assign delivery detail
7479:
7480: FORALL cnt IN 1..g_new_contid_tab.COUNT
7481: UPDATE wsh_delivery_assignments_v
7482: SET delivery_id = l_dellist1(cnt),
7483: last_update_date = SYSDATE,
7484: last_updated_by = FND_GLOBAL.USER_ID,
7485: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7878: FROM wsh_delivery_assignments_v wda,

7874:
7875:
7876: CURSOR Get_Delivery_Lines (v_delivery_id NUMBER) IS
7877: SELECT wda.delivery_detail_id
7878: FROM wsh_delivery_assignments_v wda,
7879: WSH_DELIVERY_DETAILS wdd
7880: WHERE wda.delivery_id = v_delivery_id
7881: AND wda.delivery_id IS NOT NULL
7882: AND wda.parent_delivery_detail_id IS NULL

Line 10439: wsh_delivery_assignments_v wda

10435: wdd.delivery_detail_id,
10436: wda.parent_delivery_detail_id parent_delivery_detail_id,
10437: nvl(wdd.detail_container_item_id,wdd.master_container_item_id) detail_container_item_id
10438: FROM wsh_delivery_details wdd,
10439: wsh_delivery_assignments_v wda
10440: WHERE wdd.delivery_detail_id = c_dd_id
10441: AND wdd.delivery_detail_id = wda.delivery_detail_id
10442: AND source_code = 'WSH';
10443:

Line 12001: FROM wsh_delivery_assignments_v

11997:
11998:
11999: CURSOR Get_Child_Containers(v_cont_instance_id NUMBER) IS
12000: SELECT delivery_detail_id
12001: FROM wsh_delivery_assignments_v
12002: START WITH delivery_detail_id = v_cont_instance_id
12003: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
12004:
12005: CURSOR Get_Cont_Flag (v_detail_id NUMBER) IS

Line 12171: FROM wsh_delivery_assignments_v

12167: x_return_status OUT NOCOPY VARCHAR2) IS
12168:
12169: CURSOR Get_Contents (v_detail_id NUMBER) IS
12170: SELECT count(*)
12171: FROM wsh_delivery_assignments_v
12172: START WITH delivery_detail_id = v_detail_id
12173: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
12174:
12175: CURSOR Get_Cont_Count (v_cont_id NUMBER) IS

Line 12177: FROM wsh_delivery_assignments_v

12173: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
12174:
12175: CURSOR Get_Cont_Count (v_cont_id NUMBER) IS
12176: SELECT count(*)
12177: FROM wsh_delivery_assignments_v
12178: WHERE delivery_detail_id IN
12179: (SELECT delivery_detail_id
12180: FROM WSH_DELIVERY_DETAILS
12181: WHERE container_flag = 'Y')

Line 12390: wsh_delivery_assignments_v wda,

12386: wnd.name,
12387: wnd.status_code,
12388: wda.delivery_detail_id
12389: from wsh_delivery_details wdd,
12390: wsh_delivery_assignments_v wda,
12391: wsh_new_deliveries wnd
12392: where wdd.container_name = p_lpn_name
12393: and wdd.container_flag = 'Y'
12394: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 12634: UPDATE wsh_delivery_assignments_v

12630: -- End of Code for DBI Project
12631: --
12632: -- Assign container to delivery
12633: --
12634: UPDATE wsh_delivery_assignments_v
12635: SET delivery_id = p_delivery_id,
12636: last_update_date = SYSDATE,
12637: last_updated_by = FND_GLOBAL.USER_ID,
12638: last_update_login = FND_GLOBAL.LOGIN_ID

Line 12645: UPDATE wsh_delivery_assignments_v

12641: --
12642: -- Assign lines to container
12643: --
12644: FORALL i IN p_lines_tbl.FIRST..p_lines_tbl.LAST
12645: UPDATE wsh_delivery_assignments_v
12646: SET parent_delivery_detail_id = l_container_instance_id,
12647: last_update_date = SYSDATE,
12648: last_updated_by = FND_GLOBAL.USER_ID,
12649: last_update_login = FND_GLOBAL.LOGIN_ID

Line 12889: wsh_delivery_assignments_v wda

12885: DELETE WSH_DELIVERY_DETAILS
12886: WHERE DELIVERY_DETAIL_ID IN (
12887: SELECT wdd.delivery_detail_id
12888: FROM wsh_delivery_details wdd,
12889: wsh_delivery_assignments_v wda
12890: WHERE wda.delivery_id = p_delivery_id
12891: AND wda.delivery_detail_id = wdd.delivery_detail_id
12892: AND NVL(wdd.container_flag,'N') = 'Y'
12893: )

Line 12901: DELETE wsh_delivery_assignments_v

12897: IF l_lines_tbl.COUNT > 0
12898: THEN
12899: --{
12900: FORALL i IN l_lines_tbl.FIRST..l_lines_tbl.LAST
12901: DELETE wsh_delivery_assignments_v
12902: WHERE delivery_detail_id = l_lines_tbl(i);
12903: --}
12904: END IF;
12905: --

Line 12910: UPDATE wsh_delivery_assignments_v

12906: --
12907: --
12908: -- Unassign all lines from containers.
12909: --
12910: UPDATE wsh_delivery_assignments_v
12911: SET parent_delivery_detail_id = NULL,
12912: last_update_date = SYSDATE,
12913: last_updated_by = FND_GLOBAL.USER_ID,
12914: last_update_login = FND_GLOBAL.LOGIN_ID

Line 13286: FROM wsh_delivery_assignments_v

13282: and d2.delivery_type = 'CONSOLIDATION';
13283:
13284: cursor c_get_child_details(p_parent_detail_id in number) IS
13285: SELECT delivery_detail_id
13286: FROM wsh_delivery_assignments_v
13287: WHERE parent_delivery_detail_id = p_parent_detail_id;
13288:
13289: /*CURSOR Get_Cont_Item_Info (v_cont_item_id NUMBER, v_org_id NUMBER) IS
13290: SELECT Container_Type_Code, weight_uom_code, volume_uom_code,