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 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 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 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,