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 916: UPDATE wms_license_plate_numbers

912: END IF;
913: END IF;
914:
915: IF (l_insert_update_flag = 'u') THEN
916: UPDATE wms_license_plate_numbers
917: SET inventory_item_id = p_container_item_id,
918: last_update_date = SYSDATE,
919: last_updated_by = fnd_global.user_id,
920: revision = p_revision,

Line 969: SELECT wms_license_plate_numbers_s2.NEXTVAL

965:
966: ELSE /* l_insert_update_flag = 'i' */
967: /* Need to generate a license plate number to go along with the given lpn id */
968: LOOP
969: SELECT wms_license_plate_numbers_s2.NEXTVAL
970: INTO l_curr_seq
971: FROM DUAL;
972:
973: l_new_lpn := l_org.lpn_prefix || TO_CHAR(l_curr_seq) || l_org.lpn_suffix;

Line 983: INSERT INTO wms_license_plate_numbers

979: EXIT;
980: END IF;
981: END LOOP;
982:
983: INSERT INTO wms_license_plate_numbers
984: (
985: lpn_id,
986: license_plate_number,
987: inventory_item_id,

Line 1473: FROM wms_license_plate_numbers

1469: SELECT lpn_id,
1470: organization_id,
1471: subinventory_code,
1472: locator_id
1473: FROM wms_license_plate_numbers
1474: START WITH lpn_id = p_lpn.lpn_id
1475: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1476:
1477: CURSOR nested_parent_lpn_cursor IS

Line 1479: FROM wms_license_plate_numbers

1475: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1476:
1477: CURSOR nested_parent_lpn_cursor IS
1478: SELECT *
1479: FROM wms_license_plate_numbers
1480: START WITH lpn_id = p_lpn.lpn_id
1481: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1482:
1483: CURSOR lpn_contents_cursor IS

Line 1505: FROM wms_license_plate_numbers

1501: CURSOR lpn_cursor IS
1502: -- Bug# 1546081
1503: -- SELECT *
1504: SELECT 1
1505: FROM wms_license_plate_numbers
1506: WHERE parent_lpn_id = l_current_lpn;
1507:
1508: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1509: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;

Line 1508: l_lpn_rec wms_license_plate_numbers%ROWTYPE;

1504: SELECT 1
1505: FROM wms_license_plate_numbers
1506: WHERE parent_lpn_id = l_current_lpn;
1507:
1508: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1509: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;
1510: l_lpn_contents_rec lpn_contents_cursor%ROWTYPE;
1511: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1512: l_net_weight NUMBER;

Line 1930: FROM wms_license_plate_numbers

1926: CURSOR nested_children_cursor IS
1927: -- Bug# 1546081
1928: -- SELECT *
1929: SELECT lpn_id
1930: FROM wms_license_plate_numbers
1931: START WITH lpn_id = p_content_lpn_id
1932: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1933:
1934: l_current_lpn NUMBER;

Line 1968: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

1964: -- Bug# 1546081
1965: -- SELECT wlc.*
1966: SELECT wlc.quantity,
1967: wlc.uom_code
1968: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
1969: WHERE wlc.parent_lpn_id = p_lpn_id
1970: AND wlc.organization_id = p_organization_id
1971: AND wlc.inventory_item_id = p_content_item_id
1972: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 1998: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

1994: wlc.source_line_id,
1995: wlc.source_line_detail_id,
1996: wlc.source_name,
1997: wlc.cost_group_id
1998: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
1999: WHERE wlc.parent_lpn_id = p_lpn_id
2000: AND wlc.organization_id = p_organization_id
2001: AND wlc.inventory_item_id = p_content_item_id
2002: AND NVL(wlc.revision, '###') = NVL(p_revision, '###')

Line 2075: FROM wms_license_plate_numbers

2071: -- Bug# 1546081
2072: -- SELECT *
2073: SELECT lpn_id,
2074: inventory_item_id
2075: FROM wms_license_plate_numbers
2076: START WITH lpn_id = p_lpn_id
2077: CONNECT BY parent_lpn_id = PRIOR lpn_id;
2078:
2079: l_dynamic_status NUMBER;

Line 3253: FROM wms_license_plate_numbers

3249: SELECT gross_weight,
3250: content_volume
3251: INTO lpn_weight,
3252: lpn_volume
3253: FROM wms_license_plate_numbers
3254: WHERE lpn_id = g_lpn_wt_vol_changes(i).lpn_id;
3255:
3256: -- Bug5659809: update last_update_date and last_update_by as well
3257: UPDATE wms_license_plate_numbers

Line 3257: UPDATE wms_license_plate_numbers

3253: FROM wms_license_plate_numbers
3254: WHERE lpn_id = g_lpn_wt_vol_changes(i).lpn_id;
3255:
3256: -- Bug5659809: update last_update_date and last_update_by as well
3257: UPDATE wms_license_plate_numbers
3258: SET gross_weight = lpn_weight - g_lpn_wt_vol_changes(i).gross_weight_change
3259: , content_volume = lpn_volume - g_lpn_wt_vol_changes(i).content_volume_change
3260: , last_update_date = SYSDATE
3261: , last_updated_by = fnd_global.user_id

Line 3663: FROM wms_license_plate_numbers

3659: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3660:
3661: CURSOR all_child_wlpns
3662: IS SELECT lpn_id
3663: FROM wms_license_plate_numbers
3664: START WITH lpn_id = p_lpn_id
3665: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3666:
3667: BEGIN

Line 3683: FROM wms_license_plate_numbers

3679: SELECT lpn_context
3680: , organization_id
3681: INTO l_lpn_context
3682: , l_organization_id
3683: FROM wms_license_plate_numbers
3684: WHERE lpn_id = p_lpn_id;
3685:
3686: IF l_lpn_context <> 4 THEN
3687: IF l_debug = 1 THEN

Line 3886: l_outermost_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;

3882: l_parent_lpn_id NUMBER;
3883: l_lpn_context NUMBER;
3884: l_api_name VARCHAR2(100) := 'REUSE_LPNS';
3885: l_outermost_lpn_id NUMBER;
3886: l_outermost_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3887: l_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3888: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3889: l_api_version CONSTANT NUMBER := 1.0;
3890:

Line 3887: l_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;

3883: l_lpn_context NUMBER;
3884: l_api_name VARCHAR2(100) := 'REUSE_LPNS';
3885: l_outermost_lpn_id NUMBER;
3886: l_outermost_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3887: l_lpn_name WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE;
3888: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3889: l_api_version CONSTANT NUMBER := 1.0;
3890:
3891: CURSOR immediate_child_wlpns

Line 3893: FROM wms_license_plate_numbers

3889: l_api_version CONSTANT NUMBER := 1.0;
3890:
3891: CURSOR immediate_child_wlpns
3892: IS SELECT lpn_id
3893: FROM wms_license_plate_numbers
3894: WHERE parent_lpn_id = p_lpn_id;
3895:
3896: CURSOR all_child_wlpns (p_lpn_id IN NUMBER)
3897: IS SELECT lpn_id

Line 3898: FROM wms_license_plate_numbers

3894: WHERE parent_lpn_id = p_lpn_id;
3895:
3896: CURSOR all_child_wlpns (p_lpn_id IN NUMBER)
3897: IS SELECT lpn_id
3898: FROM wms_license_plate_numbers
3899: WHERE lpn_id <> p_lpn_id
3900: START WITH lpn_id = p_lpn_id
3901: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3902:

Line 3905: FROM wms_license_plate_numbers

3901: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3902:
3903: CURSOR all_child_wlpns1
3904: IS SELECT lpn_id
3905: FROM wms_license_plate_numbers
3906: START WITH lpn_id = p_lpn_id
3907: CONNECT BY parent_lpn_id = PRIOR lpn_id;
3908:
3909: BEGIN

Line 3984: FROM wms_license_plate_numbers

3980: , l_lpn_name
3981: , l_parent_lpn_id
3982: , l_outermost_lpn_id
3983: , l_container_item_id
3984: FROM wms_license_plate_numbers
3985: WHERE lpn_id = p_lpn_id;
3986:
3987: SAVEPOINT REUSE_LPN_SP;
3988:

Line 3996: FROM wms_license_plate_numbers

3992: l_outermost_lpn_name := l_lpn_name;
3993: ELSE
3994: SELECT license_plate_number
3995: INTO l_outermost_lpn_name
3996: FROM wms_license_plate_numbers
3997: WHERE lpn_id = l_outermost_lpn_id;
3998: END IF;
3999:
4000: IF l_debug = 1 THEN

Line 4128: FROM wms_license_plate_numbers wlpn1

4124: , wlpn1.lpn_reusability -- LPN_REUSABILITY
4125: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4126: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4127: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4128: FROM wms_license_plate_numbers wlpn1
4129: , wms_license_plate_numbers wlpn2
4130: , wms_lpn_contents wlc
4131: , mtl_serial_numbers msn
4132: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)

Line 4129: , wms_license_plate_numbers wlpn2

4125: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4126: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4127: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4128: FROM wms_license_plate_numbers wlpn1
4129: , wms_license_plate_numbers wlpn2
4130: , wms_lpn_contents wlc
4131: , mtl_serial_numbers msn
4132: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4133: AND wlpn1.lpn_id = msn.lpn_id(+)

Line 4145: UPDATE wms_license_plate_numbers

4141: DELETE FROM wms_lpn_contents
4142: WHERE parent_lpn_id = p_lpn_id;
4143:
4144: IF p_clear_attributes = 'Y' THEN
4145: UPDATE wms_license_plate_numbers
4146: SET ATTRIBUTE1 = NULL
4147: , ATTRIBUTE2 = NULL
4148: , ATTRIBUTE3 = NULL
4149: , ATTRIBUTE4 = NULL

Line 4177: UPDATE wms_license_plate_numbers

4173: IF l_debug = 1 THEN
4174: mdebug('Updating its immediate chile LPNs : '|| immediate_child_wlpn_rec.lpn_id);
4175: END IF;
4176:
4177: UPDATE wms_license_plate_numbers
4178: SET parent_lpn_id = NULL
4179: , outermost_lpn_id = immediate_child_wlpn_rec.lpn_id
4180: WHERE lpn_id = immediate_child_wlpn_rec.lpn_id;
4181:

Line 4188: UPDATE wms_license_plate_numbers

4184: IF l_debug = 1 THEN
4185: mdebug('Updating all inner lpns of LPN : '|| immediate_child_wlpn_rec.lpn_id);
4186: END IF;
4187:
4188: UPDATE wms_license_plate_numbers
4189: SET outermost_lpn_id = immediate_child_wlpn_rec.lpn_id
4190: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4191:
4192: END LOOP;

Line 4196: UPDATE wms_license_plate_numbers

4192: END LOOP;
4193: END LOOP;
4194: ELSE
4195: FOR immediate_child_wlpn_rec IN immediate_child_wlpns LOOP
4196: UPDATE wms_license_plate_numbers
4197: SET parent_lpn_id = l_parent_lpn_id
4198: WHERE lpn_id = immediate_child_wlpn_rec.lpn_id;
4199: END LOOP;
4200: END IF;

Line 4203: UPDATE wms_license_plate_numbers

4199: END LOOP;
4200: END IF;
4201:
4202: IF p_new_org_id IS NOT NULL THEN
4203: UPDATE wms_license_plate_numbers
4204: SET lpn_context = 5
4205: , subinventory_code = NULL
4206: , locator_id = NULL
4207: , parent_lpn_id = NULL

Line 4212: UPDATE wms_license_plate_numbers

4208: , outermost_lpn_id = p_lpn_id
4209: , organization_id = p_new_org_id
4210: WHERE ROWID = l_wlpn_row_id;
4211: ELSE
4212: UPDATE wms_license_plate_numbers
4213: SET lpn_context = 5
4214: , subinventory_code = NULL
4215: , locator_id = NULL
4216: , parent_lpn_id = NULL

Line 4226: UPDATE wms_license_plate_numbers

4222: SET lpn_id = NULL
4223: WHERE lpn_id = p_lpn_id
4224: AND current_organization_id = l_organization_id;
4225:
4226: UPDATE wms_license_plate_numbers
4227: SET content_volume = NULL
4228: , content_volume_uom_code = NULL
4229: WHERE ROWID = l_wlpn_row_id;
4230:

Line 4233: UPDATE wms_license_plate_numbers

4229: WHERE ROWID = l_wlpn_row_id;
4230:
4231: IF l_container_item_id IS NULL
4232: OR p_clear_containter_item_id = 'Y' THEN
4233: UPDATE wms_license_plate_numbers
4234: SET inventory_item_id = NULL
4235: , gross_weight = NULL
4236: , gross_weight_uom_code = NULL
4237: , tare_weight = NULL

Line 4253: UPDATE wms_license_plate_numbers

4249: END IF;
4250: RAISE fnd_api.g_exc_unexpected_error;
4251: END IF;
4252:
4253: UPDATE wms_license_plate_numbers
4254: SET gross_weight = inv_cache.item_rec.unit_weight
4255: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4256: , tare_weight = inv_cache.item_rec.unit_weight
4257: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code

Line 4269: FROM wms_license_plate_numbers

4265: FOR all_child_wlpn_rec IN all_child_wlpns1 LOOP
4266:
4267: SELECT license_plate_number
4268: INTO l_outermost_lpn_name
4269: FROM wms_license_plate_numbers
4270: WHERE lpn_id = (SELECT outermost_lpn_id
4271: FROM wms_license_plate_numbers
4272: WHERE lpn_id = all_child_wlpn_rec.lpn_id);
4273:

Line 4271: FROM wms_license_plate_numbers

4267: SELECT license_plate_number
4268: INTO l_outermost_lpn_name
4269: FROM wms_license_plate_numbers
4270: WHERE lpn_id = (SELECT outermost_lpn_id
4271: FROM wms_license_plate_numbers
4272: WHERE lpn_id = all_child_wlpn_rec.lpn_id);
4273:
4274:
4275: INSERT INTO wms_lpn_histories (

Line 4397: FROM wms_license_plate_numbers wlpn1

4393: , wlpn1.lpn_reusability -- LPN_REUSABILITY
4394: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4395: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4396: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4397: FROM wms_license_plate_numbers wlpn1
4398: , wms_license_plate_numbers wlpn2
4399: , wms_lpn_contents wlc
4400: , mtl_serial_numbers msn
4401: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)

Line 4398: , wms_license_plate_numbers wlpn2

4394: , wlpn1.lpn_id -- OUTERMOST_LPN_ID
4395: , l_outermost_lpn_name -- OUTERMOST_LICENSE_PLATE_NUMBER
4396: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4397: FROM wms_license_plate_numbers wlpn1
4398: , wms_license_plate_numbers wlpn2
4399: , wms_lpn_contents wlc
4400: , mtl_serial_numbers msn
4401: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4402: AND wlpn1.lpn_id = msn.lpn_id(+)

Line 4411: UPDATE wms_license_plate_numbers

4407: WHERE parent_lpn_id = all_child_wlpn_rec.lpn_id;
4408:
4409:
4410: IF p_clear_attributes = 'Y' THEN
4411: UPDATE wms_license_plate_numbers
4412: SET ATTRIBUTE1 = NULL
4413: , ATTRIBUTE2 = NULL
4414: , ATTRIBUTE3 = NULL
4415: , ATTRIBUTE4 = NULL

Line 4432: UPDATE wms_license_plate_numbers

4428: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4429: END IF;
4430:
4431: IF p_new_org_id IS NOT NULL THEN
4432: UPDATE wms_license_plate_numbers
4433: SET lpn_context = 5
4434: , subinventory_code = NULL
4435: , locator_id = NULL
4436: , parent_lpn_id = NULL

Line 4441: UPDATE wms_license_plate_numbers

4437: , outermost_lpn_id = all_child_wlpn_rec.lpn_id
4438: , organization_id = p_new_org_id
4439: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4440: ELSE
4441: UPDATE wms_license_plate_numbers
4442: SET lpn_context = 5
4443: , subinventory_code = NULL
4444: , locator_id = NULL
4445: , parent_lpn_id = NULL

Line 4455: UPDATE wms_license_plate_numbers

4451: SET lpn_id = NULL
4452: WHERE lpn_id = all_child_wlpn_rec.lpn_id
4453: AND current_organization_id = l_organization_id;
4454:
4455: UPDATE wms_license_plate_numbers
4456: SET content_volume = NULL
4457: , content_volume_uom_code = NULL
4458: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4459:

Line 4462: UPDATE wms_license_plate_numbers

4458: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4459:
4460: IF l_container_item_id IS NULL
4461: OR p_clear_containter_item_id = 'Y' THEN
4462: UPDATE wms_license_plate_numbers
4463: SET inventory_item_id = NULL
4464: , gross_weight = NULL
4465: , gross_weight_uom_code = NULL
4466: , tare_weight = NULL

Line 4482: UPDATE wms_license_plate_numbers

4478: END IF;
4479: RAISE fnd_api.g_exc_unexpected_error;
4480: END IF;
4481:
4482: UPDATE wms_license_plate_numbers
4483: SET gross_weight = inv_cache.item_rec.unit_weight
4484: , gross_weight_uom_code = inv_cache.item_rec.weight_uom_code
4485: , tare_weight = inv_cache.item_rec.unit_weight
4486: , tare_weight_uom_code = inv_cache.item_rec.weight_uom_code