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 710: SELECT wsh_delivery_assignments_s.nextval

706: SELECT wsh_delivery_details_s.nextval
707: FROM sys.dual;
708:
709: CURSOR Get_Wda_Nextval IS
710: SELECT wsh_delivery_assignments_s.nextval
711: FROM sys.dual;
712:
713: l_cont_instance_id NUMBER;
714: l_cont_name VARCHAR2(50);

Line 1330: FROM wsh_delivery_assignments

1326: CURSOR Check_Hierarchy (v_detail_id NUMBER) IS
1327: SELECT 'NOT EMPTY' FROM DUAL
1328: WHERE EXISTS (
1329: SELECT delivery_detail_id
1330: FROM wsh_delivery_assignments
1331: WHERE parent_delivery_detail_id = v_detail_id
1332: AND NVL(type, 'S') in ('C', 'S')
1333: AND rownum < 2
1334: UNION

Line 1336: FROM wsh_delivery_assignments

1332: AND NVL(type, 'S') in ('C', 'S')
1333: AND rownum < 2
1334: UNION
1335: SELECT delivery_detail_id
1336: FROM wsh_delivery_assignments
1337: WHERE delivery_detail_id = v_detail_id
1338: AND parent_delivery_detail_id IS NOT NULL
1339: AND NVL(type, 'S') in ('C', 'S')
1340: AND rownum < 2);

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 2179: FROM wsh_delivery_assignments wda,

2175: CURSOR Get_Cont (v_detail_id NUMBER) IS
2176: SELECT wda.parent_delivery_detail_id container_instance_id, wda.delivery_id,
2177: wddp.organization_id, nvl(wddp.line_direction,'O'), -- K LPN CONV. rv
2178: wddp.container_flag -- K: MDC
2179: FROM wsh_delivery_assignments wda,
2180: wsh_delivery_details wddp -- K LPN CONV. rv
2181: WHERE wda.delivery_detail_id = v_detail_id
2182: AND wda.parent_delivery_detail_id = wddp.delivery_detail_id(+)
2183: AND NVL(wda.type, 'S') in ('S', 'C');

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 13155: FROM wsh_delivery_assignments

13151: FROM wsh_delivery_details
13152: --WHERE container_flag = 'Y'
13153: WHERE delivery_detail_id IN
13154: (SELECT delivery_detail_id
13155: FROM wsh_delivery_assignments
13156: START WITH parent_delivery_detail_id = v_container_id
13157: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id
13158: )
13159: FOR UPDATE NOWAIT;

Line 13251: from wsh_delivery_details d, wsh_delivery_assignments a

13247: x_return_status OUT NOCOPY VARCHAR2) IS
13248:
13249: cursor c_get_container_info(p_delivery_detail_id in number) is
13250: select d.container_flag, a.delivery_id, a.parent_delivery_id, d.inventory_item_id, d.organization_id
13251: from wsh_delivery_details d, wsh_delivery_assignments a
13252: where d.delivery_detail_id = p_delivery_detail_id
13253: and d.container_flag in ('Y', 'C')
13254: and a.type in ('C', 'S')
13255: and a.delivery_detail_id = d.delivery_detail_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,

Line 13699: delete from wsh_delivery_assignments

13695: -- is now a consol LPN, the consolidation record should be on the
13696: -- topmost children currently assigned to the parent, so we need
13697: -- to delete the parent's consolidation record.
13698:
13699: delete from wsh_delivery_assignments
13700: where delivery_detail_id = p_parent_container_id
13701: and type = 'C';
13702:
13703:

Line 13745: update wsh_delivery_assignments

13741: -- Update the outer assignment to be 'O', and null out
13742: -- its parent delivery detail id which is now a consolidation LPN.
13743:
13744: FORALL i in 1..l_child_details_tab.count
13745: update wsh_delivery_assignments
13746: set parent_delivery_detail_id = NULL,
13747: type = 'O'
13748: where delivery_detail_id = l_child_details_tab(i)
13749: and NVL(type, 'S') = 'S';

Line 13757: update wsh_delivery_assignments

13753: -- Step 2.
13754: -- Now update the consol LPN's delivery assignment to be the consol delivery,
13755: -- and set its parent delivery id to be NULL.
13756:
13757: update wsh_delivery_assignments
13758: set delivery_id = l_new_parent_delivery_id,
13759: parent_delivery_id = NULL,
13760: type = 'S'
13761: where delivery_detail_id = p_parent_container_id;

Line 13878: update wsh_delivery_assignments

13874: -- consol delivery. The child LPN is also assigned to the same consol delivery.
13875: -- All we need to do now is to update the child's consolidation record to
13876: -- create the assignment.
13877:
13878: update wsh_delivery_assignments
13879: set parent_delivery_detail_id = p_parent_container_id
13880: where delivery_detail_id = p_child_container_id
13881: and type = 'C';
13882:

Line 14106: wsh_delivery_assignments wda,

14102: wdd2.weight_uom_code,
14103: wdd2.volume_uom_code
14104: from wsh_delivery_details wdd1,
14105: wsh_delivery_details wdd2,
14106: wsh_delivery_assignments wda,
14107: wsh_new_deliveries wnd
14108: where wdd1.delivery_detail_id = p_dd_id
14109: and wda.delivery_detail_id = wdd1.delivery_detail_id
14110: and wda.type = 'C'

Line 14120: from wsh_delivery_assignments

14116: order by wdd2.delivery_detail_id;
14117:
14118: cursor c_check_empty_consol(p_consol_lpn_id in number) is
14119: select delivery_detail_id
14120: from wsh_delivery_assignments
14121: where parent_delivery_detail_id = p_consol_lpn_id
14122: and type = 'C'
14123: and rownum = 1;
14124:

Line 14312: update wsh_delivery_assignments

14308:
14309: END LOOP;
14310:
14311: FORALL i in 1..p_delivery_details_tab.count
14312: update wsh_delivery_assignments
14313: set parent_delivery_detail_id = NULL
14314: where delivery_detail_id = p_delivery_details_tab(i)
14315: and type = 'C';
14316: