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.WMS_CONTAINER_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 28: in WMS_LICENSE_PLATE_NUMBERS. */

24: END;
25:
26: /*Bug#2200989. Added local procedure to update the wt and volume
27: of the LPNs in shipping when the corrosponding LPN is modified
28: in WMS_LICENSE_PLATE_NUMBERS. */
29:
30: PROCEDURE update_shipping_details(p_lpn_id IN NUMBER, p_gross_weight IN NUMBER, p_net_weight IN NUMBER, p_weight_uom IN VARCHAR2, p_volume IN NUMBER, p_volume_uom IN VARCHAR2) IS
31: CURSOR wsh_lpn_id IS
32: SELECT 1

Line 40: FROM wms_license_plate_numbers

36: --Bug 5190145
37: --Added following cursor to get inventory_item_id from WLPN
38: CURSOR lpn_item_id IS
39: SELECT nvl(inventory_item_id, -99999)
40: FROM wms_license_plate_numbers
41: WHERE lpn_id = p_lpn_id;
42:
43: x_return_status VARCHAR2(10);
44: x_msg_count NUMBER;

Line 993: UPDATE wms_license_plate_numbers

989: END IF;
990: END IF;
991:
992: IF (l_insert_update_flag = 'u') THEN
993: UPDATE wms_license_plate_numbers
994: SET inventory_item_id = p_container_item_id,
995: last_update_date = SYSDATE,
996: last_updated_by = fnd_global.user_id,
997: revision = p_revision,

Line 1046: SELECT wms_license_plate_numbers_s2.NEXTVAL

1042:
1043: ELSE /* l_insert_update_flag = 'i' */
1044: /* Need to generate a license plate number to go along with the given lpn id */
1045: LOOP
1046: SELECT wms_license_plate_numbers_s2.NEXTVAL
1047: INTO l_curr_seq
1048: FROM DUAL;
1049:
1050: l_new_lpn := l_org.lpn_prefix || TO_CHAR(l_curr_seq) || l_org.lpn_suffix;

Line 1060: INSERT INTO wms_license_plate_numbers

1056: EXIT;
1057: END IF;
1058: END LOOP;
1059:
1060: INSERT INTO wms_license_plate_numbers
1061: (
1062: lpn_id,
1063: license_plate_number,
1064: inventory_item_id,

Line 1550: FROM wms_license_plate_numbers

1546: SELECT lpn_id,
1547: organization_id,
1548: subinventory_code,
1549: locator_id
1550: FROM wms_license_plate_numbers
1551: START WITH lpn_id = p_lpn.lpn_id
1552: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1553:
1554: CURSOR nested_parent_lpn_cursor IS

Line 1556: FROM wms_license_plate_numbers

1552: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1553:
1554: CURSOR nested_parent_lpn_cursor IS
1555: SELECT *
1556: FROM wms_license_plate_numbers
1557: START WITH lpn_id = p_lpn.lpn_id
1558: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1559:
1560: CURSOR lpn_contents_cursor IS

Line 1582: FROM wms_license_plate_numbers

1578: CURSOR lpn_cursor IS
1579: -- Bug# 1546081
1580: -- SELECT *
1581: SELECT 1
1582: FROM wms_license_plate_numbers
1583: WHERE parent_lpn_id = l_current_lpn;
1584:
1585: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1586: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;

Line 1585: l_lpn_rec wms_license_plate_numbers%ROWTYPE;

1581: SELECT 1
1582: FROM wms_license_plate_numbers
1583: WHERE parent_lpn_id = l_current_lpn;
1584:
1585: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1586: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;
1587: l_lpn_contents_rec lpn_contents_cursor%ROWTYPE;
1588: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1589: l_net_weight NUMBER;

Line 2007: FROM wms_license_plate_numbers

2003: CURSOR nested_children_cursor IS
2004: -- Bug# 1546081
2005: -- SELECT *
2006: SELECT lpn_id
2007: FROM wms_license_plate_numbers
2008: START WITH lpn_id = p_content_lpn_id
2009: CONNECT BY parent_lpn_id = PRIOR lpn_id;
2010:
2011: l_current_lpn NUMBER;

Line 2045: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

2041: -- Bug# 1546081
2042: -- SELECT wlc.*
2043: SELECT wlc.quantity,
2044: wlc.uom_code
2045: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
2046: WHERE wlc.parent_lpn_id = p_lpn_id
2047: AND wlc.organization_id = p_organization_id
2048: AND wlc.inventory_item_id = p_content_item_id
2049: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 2075: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

2071: wlc.source_line_id,
2072: wlc.source_line_detail_id,
2073: wlc.source_name,
2074: wlc.cost_group_id
2075: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
2076: WHERE wlc.parent_lpn_id = p_lpn_id
2077: AND wlc.organization_id = p_organization_id
2078: AND wlc.inventory_item_id = p_content_item_id
2079: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 2152: FROM wms_license_plate_numbers

2148: -- Bug# 1546081
2149: -- SELECT *
2150: SELECT lpn_id,
2151: inventory_item_id
2152: FROM wms_license_plate_numbers
2153: START WITH lpn_id = p_lpn_id
2154: CONNECT BY parent_lpn_id = PRIOR lpn_id;
2155:
2156: l_dynamic_status NUMBER;

Line 3331: FROM wms_license_plate_numbers

3327: SELECT gross_weight,
3328: content_volume
3329: INTO lpn_weight,
3330: lpn_volume
3331: FROM wms_license_plate_numbers
3332: WHERE lpn_id = g_lpn_wt_vol_changes(i).lpn_id;
3333:
3334: -- Bug5659809: update last_update_date and last_update_by as well
3335: UPDATE wms_license_plate_numbers

Line 3335: UPDATE wms_license_plate_numbers

3331: FROM wms_license_plate_numbers
3332: WHERE lpn_id = g_lpn_wt_vol_changes(i).lpn_id;
3333:
3334: -- Bug5659809: update last_update_date and last_update_by as well
3335: UPDATE wms_license_plate_numbers
3336: SET gross_weight = lpn_weight - g_lpn_wt_vol_changes(i).gross_weight_change
3337: , content_volume = lpn_volume - g_lpn_wt_vol_changes(i).content_volume_change
3338: , last_update_date = SYSDATE
3339: , last_updated_by = fnd_global.user_id

Line 3741: FROM wms_license_plate_numbers

3737: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3738:
3739: CURSOR all_child_wlpns
3740: IS SELECT lpn_id
3741: FROM wms_license_plate_numbers
3742: START WITH lpn_id = p_lpn_id
3743: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3744:
3745: BEGIN

Line 3761: FROM wms_license_plate_numbers

3757: SELECT lpn_context
3758: , organization_id
3759: INTO l_lpn_context
3760: , l_organization_id
3761: FROM wms_license_plate_numbers
3762: WHERE lpn_id = p_lpn_id;
3763:
3764: IF l_lpn_context <> 4 THEN
3765: IF l_debug = 1 THEN

Line 3964: l_outermost_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;

3960: l_parent_lpn_id NUMBER;
3961: l_lpn_context NUMBER;
3962: l_api_name VARCHAR2(100) := 'REUSE_LPNS';
3963: l_outermost_lpn_id NUMBER;
3964: l_outermost_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3965: l_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3966: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3967: l_api_version CONSTANT NUMBER := 1.0;
3968:

Line 3965: l_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;

3961: l_lpn_context NUMBER;
3962: l_api_name VARCHAR2(100) := 'REUSE_LPNS';
3963: l_outermost_lpn_id NUMBER;
3964: l_outermost_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3965: l_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3966: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3967: l_api_version CONSTANT NUMBER := 1.0;
3968:
3969: CURSOR immediate_child_wlpns

Line 3971: FROM wms_license_plate_numbers

3967: l_api_version CONSTANT NUMBER := 1.0;
3968:
3969: CURSOR immediate_child_wlpns
3970: IS SELECT lpn_id
3971: FROM wms_license_plate_numbers
3972: WHERE parent_lpn_id = p_lpn_id;
3973:
3974: CURSOR all_child_wlpns (p_lpn_id IN NUMBER)
3975: IS SELECT lpn_id

Line 3976: FROM wms_license_plate_numbers

3972: WHERE parent_lpn_id = p_lpn_id;
3973:
3974: CURSOR all_child_wlpns (p_lpn_id IN NUMBER)
3975: IS SELECT lpn_id
3976: FROM wms_license_plate_numbers
3977: WHERE lpn_id <> p_lpn_id
3978: START WITH lpn_id = p_lpn_id
3979: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3980:

Line 3983: FROM wms_license_plate_numbers

3979: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3980:
3981: CURSOR all_child_wlpns1
3982: IS SELECT lpn_id
3983: FROM wms_license_plate_numbers
3984: START WITH lpn_id = p_lpn_id
3985: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3986:
3987: BEGIN

Line 4062: FROM wms_license_plate_numbers

4058: , l_lpn_name
4059: , l_parent_lpn_id
4060: , l_outermost_lpn_id
4061: , l_container_item_id
4062: FROM wms_license_plate_numbers
4063: WHERE lpn_id = p_lpn_id;
4064:
4065: SAVEPOINT REUSE_LPN_SP;
4066:

Line 4074: FROM wms_license_plate_numbers

4070: l_outermost_lpn_name := l_lpn_name;
4071: ELSE
4072: SELECT license_plate_number
4073: INTO l_outermost_lpn_name
4074: FROM wms_license_plate_numbers
4075: WHERE lpn_id = l_outermost_lpn_id;
4076: END IF;
4077:
4078: IF l_debug = 1 THEN

Line 4206: FROM wms_license_plate_numbers wlpn1

4202: , wlpn1.lpn_reusability -- LPN_REUSABILITY
4203: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4204: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4205: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4206: FROM wms_license_plate_numbers wlpn1
4207: , wms_license_plate_numbers wlpn2
4208: , wms_lpn_contents wlc
4209: , mtl_serial_numbers msn
4210: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)

Line 4207: , wms_license_plate_numbers wlpn2

4203: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4204: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4205: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4206: FROM wms_license_plate_numbers wlpn1
4207: , wms_license_plate_numbers wlpn2
4208: , wms_lpn_contents wlc
4209: , mtl_serial_numbers msn
4210: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4211: AND wlpn1.lpn_id = msn.lpn_id(+)

Line 4223: UPDATE wms_license_plate_numbers

4219: DELETE FROM wms_lpn_contents
4220: WHERE parent_lpn_id = p_lpn_id;
4221:
4222: IF p_clear_attributes = 'Y' THEN
4223: UPDATE wms_license_plate_numbers
4224: SET ATTRIBUTE1 = NULL
4225: , ATTRIBUTE2 = NULL
4226: , ATTRIBUTE3 = NULL
4227: , ATTRIBUTE4 = NULL

Line 4255: UPDATE wms_license_plate_numbers

4251: IF l_debug = 1 THEN
4252: mdebug('Updating its immediate chile LPNs : '|| immediate_child_wlpn_rec.lpn_id);
4253: END IF;
4254:
4255: UPDATE wms_license_plate_numbers
4256: SET parent_lpn_id = NULL
4257: , outermost_lpn_id = immediate_child_wlpn_rec.lpn_id
4258: WHERE lpn_id = immediate_child_wlpn_rec.lpn_id;
4259:

Line 4266: UPDATE wms_license_plate_numbers

4262: IF l_debug = 1 THEN
4263: mdebug('Updating all inner lpns of LPN : '|| immediate_child_wlpn_rec.lpn_id);
4264: END IF;
4265:
4266: UPDATE wms_license_plate_numbers
4267: SET outermost_lpn_id = immediate_child_wlpn_rec.lpn_id
4268: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4269:
4270: END LOOP;

Line 4274: UPDATE wms_license_plate_numbers

4270: END LOOP;
4271: END LOOP;
4272: ELSE
4273: FOR immediate_child_wlpn_rec IN immediate_child_wlpns LOOP
4274: UPDATE wms_license_plate_numbers
4275: SET parent_lpn_id = l_parent_lpn_id
4276: WHERE lpn_id = immediate_child_wlpn_rec.lpn_id;
4277: END LOOP;
4278: END IF;

Line 4281: UPDATE wms_license_plate_numbers

4277: END LOOP;
4278: END IF;
4279:
4280: IF p_new_org_id IS NOT NULL THEN
4281: UPDATE wms_license_plate_numbers
4282: SET lpn_context = 5
4283: , subinventory_code = NULL
4284: , locator_id = NULL
4285: , parent_lpn_id = NULL

Line 4290: UPDATE wms_license_plate_numbers

4286: , outermost_lpn_id = p_lpn_id
4287: , organization_id = p_new_org_id
4288: WHERE ROWID = l_wlpn_row_id;
4289: ELSE
4290: UPDATE wms_license_plate_numbers
4291: SET lpn_context = 5
4292: , subinventory_code = NULL
4293: , locator_id = NULL
4294: , parent_lpn_id = NULL

Line 4304: UPDATE wms_license_plate_numbers

4300: SET lpn_id = NULL
4301: WHERE lpn_id = p_lpn_id
4302: AND current_organization_id = l_organization_id;
4303:
4304: UPDATE wms_license_plate_numbers
4305: SET content_volume = NULL
4306: , content_volume_uom_code = NULL
4307: WHERE ROWID = l_wlpn_row_id;
4308:

Line 4311: UPDATE wms_license_plate_numbers

4307: WHERE ROWID = l_wlpn_row_id;
4308:
4309: IF l_container_item_id IS NULL
4310: OR p_clear_containter_item_id = 'Y' THEN
4311: UPDATE wms_license_plate_numbers
4312: SET inventory_item_id = NULL
4313: , gross_weight = NULL
4314: , gross_weight_uom_code = NULL
4315: , tare_weight = NULL

Line 4331: UPDATE wms_license_plate_numbers

4327: END IF;
4328: RAISE fnd_api.g_exc_unexpected_error;
4329: END IF;
4330:
4331: UPDATE wms_license_plate_numbers
4332: SET gross_weight = inv_cache.item_rec.unit_weight
4333: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4334: , tare_weight = inv_cache.item_rec.unit_weight
4335: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code

Line 4347: FROM wms_license_plate_numbers

4343: FOR all_child_wlpn_rec IN all_child_wlpns1 LOOP
4344:
4345: SELECT license_plate_number
4346: INTO l_outermost_lpn_name
4347: FROM wms_license_plate_numbers
4348: WHERE lpn_id = (SELECT outermost_lpn_id
4349: FROM wms_license_plate_numbers
4350: WHERE lpn_id = all_child_wlpn_rec.lpn_id);
4351:

Line 4349: FROM wms_license_plate_numbers

4345: SELECT license_plate_number
4346: INTO l_outermost_lpn_name
4347: FROM wms_license_plate_numbers
4348: WHERE lpn_id = (SELECT outermost_lpn_id
4349: FROM wms_license_plate_numbers
4350: WHERE lpn_id = all_child_wlpn_rec.lpn_id);
4351:
4352:
4353: INSERT INTO wms_lpn_histories (

Line 4475: FROM wms_license_plate_numbers wlpn1

4471: , wlpn1.lpn_reusability -- LPN_REUSABILITY
4472: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4473: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4474: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4475: FROM wms_license_plate_numbers wlpn1
4476: , wms_license_plate_numbers wlpn2
4477: , wms_lpn_contents wlc
4478: , mtl_serial_numbers msn
4479: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)

Line 4476: , wms_license_plate_numbers wlpn2

4472: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4473: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4474: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4475: FROM wms_license_plate_numbers wlpn1
4476: , wms_license_plate_numbers wlpn2
4477: , wms_lpn_contents wlc
4478: , mtl_serial_numbers msn
4479: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4480: AND wlpn1.lpn_id = msn.lpn_id(+)

Line 4489: UPDATE wms_license_plate_numbers

4485: WHERE parent_lpn_id = all_child_wlpn_rec.lpn_id;
4486:
4487:
4488: IF p_clear_attributes = 'Y' THEN
4489: UPDATE wms_license_plate_numbers
4490: SET ATTRIBUTE1 = NULL
4491: , ATTRIBUTE2 = NULL
4492: , ATTRIBUTE3 = NULL
4493: , ATTRIBUTE4 = NULL

Line 4510: UPDATE wms_license_plate_numbers

4506: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4507: END IF;
4508:
4509: IF p_new_org_id IS NOT NULL THEN
4510: UPDATE wms_license_plate_numbers
4511: SET lpn_context = 5
4512: , subinventory_code = NULL
4513: , locator_id = NULL
4514: , parent_lpn_id = NULL

Line 4519: UPDATE wms_license_plate_numbers

4515: , outermost_lpn_id = all_child_wlpn_rec.lpn_id
4516: , organization_id = p_new_org_id
4517: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4518: ELSE
4519: UPDATE wms_license_plate_numbers
4520: SET lpn_context = 5
4521: , subinventory_code = NULL
4522: , locator_id = NULL
4523: , parent_lpn_id = NULL

Line 4533: UPDATE wms_license_plate_numbers

4529: SET lpn_id = NULL
4530: WHERE lpn_id = all_child_wlpn_rec.lpn_id
4531: AND current_organization_id = l_organization_id;
4532:
4533: UPDATE wms_license_plate_numbers
4534: SET content_volume = NULL
4535: , content_volume_uom_code = NULL
4536: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4537:

Line 4540: UPDATE wms_license_plate_numbers

4536: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4537:
4538: IF l_container_item_id IS NULL
4539: OR p_clear_containter_item_id = 'Y' THEN
4540: UPDATE wms_license_plate_numbers
4541: SET inventory_item_id = NULL
4542: , gross_weight = NULL
4543: , gross_weight_uom_code = NULL
4544: , tare_weight = NULL

Line 4560: UPDATE wms_license_plate_numbers

4556: END IF;
4557: RAISE fnd_api.g_exc_unexpected_error;
4558: END IF;
4559:
4560: UPDATE wms_license_plate_numbers
4561: SET gross_weight = inv_cache.item_rec.unit_weight
4562: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4563: , tare_weight = inv_cache.item_rec.unit_weight
4564: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code