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_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 849: SELECT wms_license_plate_numbers_s1.NEXTVAL

845: fnd_msg_pub.ADD;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: SELECT wms_license_plate_numbers_s1.NEXTVAL
850: INTO p_lpn_table(i).lpn_id
851: FROM DUAL;
852:
853: IF (l_debug = 1) THEN

Line 898: INSERT INTO wms_license_plate_numbers (

894: mdebug('Bulk insert LPNs in WLPN: '||to_char(l_lpn_bulk_rec.lpn_id.first)||'-'||to_char(l_lpn_bulk_rec.lpn_id.last), G_INFO);
895: END IF;
896:
897: FORALL j IN l_lpn_bulk_rec.lpn_id.first..l_lpn_bulk_rec.lpn_id.last
898: INSERT INTO wms_license_plate_numbers (
899: last_update_date
900: , last_updated_by
901: , creation_date
902: , created_by

Line 990: FROM wms_license_plate_numbers

986: FOR k IN l_lpn_bulk_rec.lpn_id.first..l_lpn_bulk_rec.lpn_id.last LOOP
987: --l_progress := 'Validate if LPN already exists in the system';
988: BEGIN
989: SELECT 1 INTO l_dummy_num
990: FROM wms_license_plate_numbers
991: WHERE license_plate_number = l_lpn_bulk_rec.license_plate_number(k);
992:
993: IF ( l_debug = 1 ) THEN
994: mdebug('LPN '||l_lpn_bulk_rec.license_plate_number(k)||' already exists, cannot create it', G_ERROR);

Line 1392: SELECT wms_license_plate_numbers_s2.NEXTVAL

1388:
1389: WHILE ( l_lpn_cnt <= l_quantity ) LOOP
1390:
1391: IF ( l_seq_source = l_from_db_seq ) THEN
1392: SELECT wms_license_plate_numbers_s2.NEXTVAL
1393: INTO l_curr_seq
1394: FROM DUAL;
1395: ELSIF ( l_seq_source = l_from_org ) THEN
1396: -- If taken from org parameters make sure the new seq is within the range

Line 1428: FROM WMS_LICENSE_PLATE_NUMBERS

1424:
1425: BEGIN
1426: SELECT 1
1427: INTO l_dummy_number
1428: FROM WMS_LICENSE_PLATE_NUMBERS
1429: WHERE license_plate_number = l_lpn_tab(l_lpn_cnt).license_plate_number;
1430: EXCEPTION
1431: WHEN NO_DATA_FOUND THEN
1432: l_dummy_number := 2;

Line 1639: FROM wms_license_plate_numbers

1635: , attribute12
1636: , attribute13
1637: , attribute14
1638: , attribute15
1639: FROM wms_license_plate_numbers
1640: START WITH lpn_id = p_parent_lpn_id
1641: CONNECT BY lpn_id = PRIOR parent_lpn_id
1642: FOR UPDATE NOWAIT;
1643:

Line 1692: FROM wms_license_plate_numbers

1688: , attribute12
1689: , attribute13
1690: , attribute14
1691: , attribute15
1692: FROM wms_license_plate_numbers
1693: START WITH parent_lpn_id = p_lpn_id
1694: CONNECT BY parent_lpn_id = PRIOR lpn_id
1695: FOR UPDATE NOWAIT;
1696:

Line 1705: FROM wms_license_plate_numbers wlpn

1701: , msi.primary_uom_code
1702: , msi.serial_number_control_code
1703: , msi.lot_control_code
1704: , msi.revision_qty_control_code
1705: FROM wms_license_plate_numbers wlpn
1706: , wms_lpn_contents wlc
1707: , mtl_system_items msi
1708: WHERE wlpn.organization_id = p_old_org_id
1709: AND wlpn.outermost_lpn_id = p_outermost_lpn_id

Line 1982: FROM wms_license_plate_numbers

1978: , l_old.attribute12
1979: , l_old.attribute13
1980: , l_old.attribute14
1981: , l_old.attribute15
1982: FROM wms_license_plate_numbers
1983: WHERE lpn_id = p_lpn_table(lpn_tbl_cnt).lpn_id;
1984: EXCEPTION
1985: WHEN NO_DATA_FOUND THEN
1986: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

Line 2553: FROM wms_license_plate_numbers

2549: ELSE -- not in table just get from db
2550: l_progress := 'Getting outermost_lpn_id for plpnid='||l_new.parent_lpn_id;
2551: SELECT outermost_lpn_id
2552: INTO l_new.outermost_lpn_id
2553: FROM wms_license_plate_numbers
2554: WHERE lpn_id = l_new.parent_lpn_id;
2555: END IF;
2556: END IF;
2557: END IF;

Line 3155: from wms_license_plate_numbers wlpn

3151: from wsh_delivery_details wdd, wsh_delivery_assignments wda
3152: WHERE wda.delivery_detail_id(+) = wdd.delivery_detail_id AND ROWNUM < 2
3153: AND wdd.lpn_id IN
3154: ( select wlpn.lpn_id
3155: from wms_license_plate_numbers wlpn
3156: where wlpn.outermost_lpn_id = p_lpn_table(1).lpn_id);
3157:
3158: IF (l_delivery_id <> 999) THEN
3159:

Line 3434: UPDATE wms_license_plate_numbers wlpn

3430: END IF;
3431:
3432: BEGIN
3433: FORALL bulk_i IN l_lpn_bulk_rec.lpn_id.first .. l_lpn_bulk_rec.lpn_id.last
3434: UPDATE wms_license_plate_numbers wlpn
3435: SET last_update_date = SYSDATE
3436: , last_updated_by = fnd_global.user_id
3437: , organization_id = l_lpn_bulk_rec.organization_id(bulk_i)
3438: , license_plate_number = l_lpn_bulk_rec.license_plate_number(bulk_i)

Line 3486: FROM wms_license_plate_numbers

3482:
3483: FOR bulk_i IN l_lpn_bulk_rec.lpn_id.first..l_lpn_bulk_rec.lpn_id.last LOOP
3484: BEGIN
3485: SELECT 1 INTO l_dummy_num
3486: FROM wms_license_plate_numbers
3487: WHERE license_plate_number = l_lpn_bulk_rec.license_plate_number(bulk_i);
3488:
3489: IF ( l_debug = 1 ) THEN
3490: mdebug('LPN '||l_lpn_bulk_rec.license_plate_number(bulk_i)||' already exists, cannot update another LPN with this name', G_ERROR);

Line 3521: UPDATE wms_license_plate_numbers wlpn

3517: END LOOP;*/
3518: END IF;
3519:
3520: FORALL bulk_i IN l_lpn_bulk_rec.outermost_lpn_id.first .. l_lpn_bulk_rec.outermost_lpn_id.last
3521: UPDATE wms_license_plate_numbers wlpn
3522: SET last_update_date = SYSDATE
3523: , last_updated_by = fnd_global.user_id
3524: , outermost_lpn_id = l_lpn_bulk_rec.outermost_lpn_id(bulk_i)
3525: , organization_id = l_lpn_bulk_rec.organization_id(bulk_i)

Line 4235: FROM wms_license_plate_numbers

4231: l_change_in_volume_uom VARCHAR2(3);
4232:
4233: CURSOR nested_children_cursor(p_outer_lpn_id NUMBER) IS
4234: SELECT lpn_id
4235: FROM wms_license_plate_numbers
4236: START WITH lpn_id = p_outer_lpn_id
4237: CONNECT BY parent_lpn_id = PRIOR lpn_id;
4238:
4239: CURSOR nested_parent_cursor(p_child_lpn_id NUMBER) IS

Line 4243: FROM wms_license_plate_numbers

4239: CURSOR nested_parent_cursor(p_child_lpn_id NUMBER) IS
4240: SELECT organization_id, parent_lpn_id, lpn_id, inventory_item_id,
4241: tare_weight, tare_weight_uom_code, gross_weight, gross_weight_uom_code,
4242: container_volume, container_volume_uom, content_volume, content_volume_uom_code
4243: FROM wms_license_plate_numbers
4244: START WITH lpn_id = p_child_lpn_id
4245: CONNECT BY lpn_id = PRIOR parent_lpn_id;
4246:
4247: empty_lpn_rec nested_parent_cursor%ROWTYPE;

Line 4323: FROM wms_license_plate_numbers

4319: , organization_id
4320: , inventory_item_id
4321: , tare_weight
4322: , tare_weight_uom_code
4323: FROM wms_license_plate_numbers
4324: START WITH lpn_id = p_lpn_id
4325: CONNECT BY parent_lpn_id = PRIOR lpn_id;
4326:
4327: BEGIN

Line 5045: SELECT 1 FROM wms_license_plate_numbers

5041: SELECT 1 FROM wms_lpn_contents
5042: WHERE organization_id = p_organization_id
5043: AND parent_lpn_id = l_lpn.lpn_id )
5044: OR EXISTS (
5045: SELECT 1 FROM wms_license_plate_numbers
5046: WHERE organization_id = p_organization_id
5047: AND parent_lpn_id = l_lpn.lpn_id
5048: AND lpn_id <> l_content_lpn.lpn_id );
5049: EXCEPTION

Line 5232: SELECT 1 FROM wms_license_plate_numbers

5228: SELECT 1 FROM wms_lpn_contents
5229: WHERE organization_id = p_organization_id
5230: AND parent_lpn_id = l_lpn.lpn_id )
5231: OR EXISTS (
5232: SELECT 1 FROM wms_license_plate_numbers
5233: WHERE organization_id = p_organization_id
5234: AND parent_lpn_id = l_lpn.lpn_id );
5235: EXCEPTION
5236: WHEN NO_DATA_FOUND THEN

Line 5425: SELECT 1 FROM wms_license_plate_numbers

5421: OR EXISTS (
5422: -- Check to make sure that the parent lpn has no lpns in it
5423: -- Ignore the child lpn that will become pregenerated later since
5424: -- we already know it will unpacked from the parent
5425: SELECT 1 FROM wms_license_plate_numbers
5426: WHERE organization_id = p_organization_id
5427: AND parent_lpn_id = empty_lpn_rec.parent_lpn_id
5428: AND lpn_id <> empty_lpn_rec.lpn_id );
5429: EXCEPTION

Line 5486: FROM wms_license_plate_numbers

5482: , l_wt_vol_new.tare_weight
5483: , l_wt_vol_new.tare_weight_uom_code
5484: , l_wt_vol_new.content_volume
5485: , l_wt_vol_new.content_volume_uom_code
5486: FROM wms_license_plate_numbers
5487: WHERE lpn_id = empty_lpn_rec.parent_lpn_id;
5488: END IF;
5489: END IF;
5490: END IF;

Line 7061: UPDATE wms_license_plate_numbers

7057: IF (l_debug = 1) THEN
7058: mdebug('setting lpn id= ' || l_lpn_to_pack || ' to context ' || l_lpn_source, G_INFO);
7059: END IF;
7060: -- Bug5659809: update last_update_date and last_update_by as well
7061: UPDATE wms_license_plate_numbers
7062: SET lpn_context = l_lpn_source
7063: , last_update_date = SYSDATE
7064: , last_updated_by = fnd_global.user_id
7065: WHERE lpn_id = l_lpn_to_pack;

Line 7553: UPDATE wms_license_plate_numbers

7549: AND inventory_item_id = p_content_item_id
7550: AND NVL(revision, G_NULL_CHAR) = NVL(p_revision, G_NULL_CHAR)
7551: AND NVL(lot_number, G_NULL_CHAR) = NVL(p_lot_number, G_NULL_CHAR);
7552:
7553: UPDATE wms_license_plate_numbers
7554: SET last_update_date = SYSDATE,
7555: last_updated_by = fnd_global.user_id,
7556: lpn_context = LPN_CONTEXT_WIP
7557: WHERE lpn_id = p_lpn_id

Line 7619: FROM WMS_LICENSE_PLATE_NUMBERS

7615:
7616: CURSOR nested_lpn_cursor IS
7617: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
7618: revision, lot_number, serial_number, cost_group_id
7619: FROM WMS_LICENSE_PLATE_NUMBERS
7620: WHERE Level <= p_explosion_level
7621: START WITH lpn_id = p_lpn_id
7622: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7623:

Line 7627: FROM WMS_LICENSE_PLATE_NUMBERS

7623:
7624: CURSOR all_nested_lpn_cursor IS
7625: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
7626: revision, lot_number, serial_number, cost_group_id
7627: FROM WMS_LICENSE_PLATE_NUMBERS
7628: START WITH lpn_id = p_lpn_id
7629: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7630:
7631: CURSOR lpn_contents_cursor IS

Line 7906: FROM WMS_LICENSE_PLATE_NUMBERS

7902: THEN
7903: IF ( p_lock = 1 ) THEN
7904: SELECT *
7905: INTO p_lpn
7906: FROM WMS_LICENSE_PLATE_NUMBERS
7907: WHERE LPN_ID = p_lpn.lpn_id
7908: FOR UPDATE;
7909: ELSE
7910: SELECT *

Line 7912: FROM WMS_LICENSE_PLATE_NUMBERS

7908: FOR UPDATE;
7909: ELSE
7910: SELECT *
7911: INTO p_lpn
7912: FROM WMS_LICENSE_PLATE_NUMBERS
7913: WHERE LPN_ID = p_lpn.lpn_id;
7914: END IF;
7915:
7916: RETURN T;

Line 7921: FROM WMS_LICENSE_PLATE_NUMBERS

7917: ELSIF (p_lpn.lpn_id IS NULL OR p_lpn.lpn_id = FND_API.G_MISS_NUM) THEN
7918: IF ( p_lock = 1 ) THEN
7919: SELECT *
7920: INTO p_lpn
7921: FROM WMS_LICENSE_PLATE_NUMBERS
7922: WHERE LICENSE_PLATE_NUMBER = p_lpn.license_plate_number
7923: FOR UPDATE;
7924: ELSE
7925: SELECT *

Line 7927: FROM WMS_LICENSE_PLATE_NUMBERS

7923: FOR UPDATE;
7924: ELSE
7925: SELECT *
7926: INTO p_lpn
7927: FROM WMS_LICENSE_PLATE_NUMBERS
7928: WHERE LICENSE_PLATE_NUMBER = p_lpn.license_plate_number;
7929: END IF;
7930:
7931: RETURN T;

Line 7936: FROM WMS_LICENSE_PLATE_NUMBERS

7932: ELSE
7933: IF ( p_lock = 1 ) THEN
7934: SELECT *
7935: INTO p_lpn
7936: FROM WMS_LICENSE_PLATE_NUMBERS
7937: WHERE LPN_ID = p_lpn.lpn_id
7938: AND LICENSE_PLATE_NUMBER = p_lpn.license_plate_number
7939: FOR UPDATE;
7940: ELSE

Line 7943: FROM WMS_LICENSE_PLATE_NUMBERS

7939: FOR UPDATE;
7940: ELSE
7941: SELECT *
7942: INTO p_lpn
7943: FROM WMS_LICENSE_PLATE_NUMBERS
7944: WHERE LPN_ID = p_lpn.lpn_id
7945: AND LICENSE_PLATE_NUMBER = p_lpn.license_plate_number;
7946: END IF;
7947:

Line 7972: FROM wms_license_plate_numbers

7968: l_progress VARCHAR2(10) := '0';
7969:
7970: CURSOR Nested_LPN_Cursor IS
7971: SELECT lpn_id
7972: FROM wms_license_plate_numbers
7973: WHERE outermost_lpn_id = p_lpn_id;
7974:
7975: lpn_rec Nested_LPN_Cursor%ROWTYPE;
7976: l_lpn_is_valid NUMBER := WMS_CONTAINER_PVT.F;

Line 7990: FROM wms_license_plate_numbers

7986: l_progress := '100';
7987: -- Check if the lpn_id entered is the outermost
7988: BEGIN
7989: SELECT parent_lpn_id INTO l_parent_lpn_id
7990: FROM wms_license_plate_numbers
7991: WHERE organization_id = p_organization_id
7992: AND lpn_id = p_lpn_id;
7993: EXCEPTION
7994: WHEN NO_DATA_FOUND THEN

Line 8171: FROM wms_license_plate_numbers

8167: l_label_return VARCHAR2(1);
8168:
8169: CURSOR Nested_LPN_cur IS
8170: SELECT lpn_id, lpn_context, subinventory_code, locator_id, parent_lpn_id
8171: FROM wms_license_plate_numbers
8172: WHERE lpn_id <> p_outermost_lpn_id
8173: START WITH lpn_id = p_outermost_lpn_id
8174: CONNECT BY parent_lpn_id = PRIOR lpn_id;
8175:

Line 8584: FROM WMS_LICENSE_PLATE_NUMBERS

8580: l_progress VARCHAR2(10) := '0';
8581:
8582: CURSOR nested_lpn_cursor IS
8583: SELECT rowid, lpn_id, parent_lpn_id, subinventory_code, locator_id
8584: FROM WMS_LICENSE_PLATE_NUMBERS
8585: WHERE lpn_id <> p_outermost_lpn_id
8586: START WITH lpn_id = p_outermost_lpn_id
8587: CONNECT BY parent_lpn_id = PRIOR lpn_id;
8588:

Line 8729: FROM wms_license_plate_numbers

8725: l_progress VARCHAR2(10) := '0';
8726:
8727: CURSOR nested_lpn_cursor IS
8728: SELECT rowid, lpn_id
8729: FROM wms_license_plate_numbers
8730: WHERE organization_id = p_organization_id
8731: AND outermost_lpn_id = p_outermost_lpn_id;
8732:
8733: BEGIN

Line 8767: UPDATE wms_license_plate_numbers

8763: DELETE FROM wms_lpn_contents
8764: WHERE parent_lpn_id = lpn_rec.lpn_id;
8765:
8766: -- Reset lpn properties to pregenerated
8767: UPDATE wms_license_plate_numbers
8768: SET lpn_context = LPN_CONTEXT_PREGENERATED
8769: , subinventory_code = NULL
8770: , locator_id = NULL
8771: , parent_lpn_id = NULL

Line 8825: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers

8821: SELECT wda.delivery_id
8822: INTO l_delivery_id
8823: FROM wsh_delivery_details_ob_grp_v wdd,
8824: wsh_delivery_assignments wda
8825: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
8826: WHERE outermost_lpn_id = (SELECT outermost_lpn_id
8827: FROM wms_license_plate_numbers
8828: WHERE lpn_id = p_lpn_id)
8829: AND lpn_context = 11)

Line 8827: FROM wms_license_plate_numbers

8823: FROM wsh_delivery_details_ob_grp_v wdd,
8824: wsh_delivery_assignments wda
8825: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
8826: WHERE outermost_lpn_id = (SELECT outermost_lpn_id
8827: FROM wms_license_plate_numbers
8828: WHERE lpn_id = p_lpn_id)
8829: AND lpn_context = 11)
8830: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
8831: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id