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 904: SELECT wms_license_plate_numbers_s1.NEXTVAL

900: fnd_msg_pub.ADD;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903:
904: SELECT wms_license_plate_numbers_s1.NEXTVAL
905: INTO p_lpn_table(i).lpn_id
906: FROM DUAL;
907:
908: IF (l_debug = 1) THEN

Line 953: INSERT INTO wms_license_plate_numbers (

949: 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);
950: END IF;
951:
952: FORALL j IN l_lpn_bulk_rec.lpn_id.first..l_lpn_bulk_rec.lpn_id.last
953: INSERT INTO wms_license_plate_numbers (
954: last_update_date
955: , last_updated_by
956: , creation_date
957: , created_by

Line 1045: FROM wms_license_plate_numbers

1041: FOR k IN l_lpn_bulk_rec.lpn_id.first..l_lpn_bulk_rec.lpn_id.last LOOP
1042: --l_progress := 'Validate if LPN already exists in the system';
1043: BEGIN
1044: SELECT 1 INTO l_dummy_num
1045: FROM wms_license_plate_numbers
1046: WHERE license_plate_number = l_lpn_bulk_rec.license_plate_number(k);
1047:
1048: IF ( l_debug = 1 ) THEN
1049: mdebug('LPN '||l_lpn_bulk_rec.license_plate_number(k)||' already exists, cannot create it', G_ERROR);

Line 1567: SELECT wms_license_plate_numbers_s2.NEXTVAL

1563:
1564: WHILE ( l_lpn_cnt <= l_quantity ) LOOP
1565:
1566: IF ( l_seq_source = l_from_db_seq ) THEN
1567: SELECT wms_license_plate_numbers_s2.NEXTVAL
1568: INTO l_curr_seq
1569: FROM DUAL;
1570: ELSIF ( l_seq_source = l_from_client ) THEN
1571: -- If taken from client parameters make sure the new seq is within the range

Line 1618: FROM WMS_LICENSE_PLATE_NUMBERS

1614:
1615: BEGIN
1616: SELECT 1
1617: INTO l_dummy_number
1618: FROM WMS_LICENSE_PLATE_NUMBERS
1619: WHERE license_plate_number = l_lpn_tab(l_lpn_cnt).license_plate_number;
1620: EXCEPTION
1621: WHEN NO_DATA_FOUND THEN
1622: l_dummy_number := 2;

Line 1832: FROM wms_license_plate_numbers

1828: , attribute12
1829: , attribute13
1830: , attribute14
1831: , attribute15
1832: FROM wms_license_plate_numbers
1833: START WITH lpn_id = p_parent_lpn_id
1834: CONNECT BY lpn_id = PRIOR parent_lpn_id
1835: FOR UPDATE NOWAIT;
1836:

Line 1885: FROM wms_license_plate_numbers

1881: , attribute12
1882: , attribute13
1883: , attribute14
1884: , attribute15
1885: FROM wms_license_plate_numbers
1886: START WITH parent_lpn_id = p_lpn_id
1887: CONNECT BY parent_lpn_id = PRIOR lpn_id
1888: FOR UPDATE NOWAIT;
1889:

Line 1898: FROM wms_license_plate_numbers wlpn

1894: , msi.primary_uom_code
1895: , msi.serial_number_control_code
1896: , msi.lot_control_code
1897: , msi.revision_qty_control_code
1898: FROM wms_license_plate_numbers wlpn
1899: , wms_lpn_contents wlc
1900: , mtl_system_items msi
1901: WHERE wlpn.organization_id = p_old_org_id
1902: AND wlpn.outermost_lpn_id = p_outermost_lpn_id

Line 2178: FROM wms_license_plate_numbers

2174: , l_old.attribute12
2175: , l_old.attribute13
2176: , l_old.attribute14
2177: , l_old.attribute15
2178: FROM wms_license_plate_numbers
2179: WHERE lpn_id = p_lpn_table(lpn_tbl_cnt).lpn_id;
2180: EXCEPTION
2181: WHEN NO_DATA_FOUND THEN
2182: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

Line 2734: FROM wms_license_plate_numbers

2730: ELSE -- not in table just get from db
2731: l_progress := 'Getting outermost_lpn_id for plpnid='||l_new.parent_lpn_id;
2732: SELECT outermost_lpn_id
2733: INTO l_new.outermost_lpn_id
2734: FROM wms_license_plate_numbers
2735: WHERE lpn_id = l_new.parent_lpn_id;
2736: END IF;
2737: END IF;
2738: END IF;

Line 3455: from wms_license_plate_numbers wlpn

3451: from wsh_delivery_details wdd, wsh_delivery_assignments wda
3452: WHERE wda.delivery_detail_id(+) = wdd.delivery_detail_id AND ROWNUM < 2
3453: AND wdd.lpn_id IN
3454: ( select wlpn.lpn_id
3455: from wms_license_plate_numbers wlpn
3456: where wlpn.outermost_lpn_id = p_lpn_table(1).lpn_id);
3457:
3458: IF (l_delivery_id <> 999) THEN
3459:

Line 3734: UPDATE wms_license_plate_numbers wlpn

3730: END IF;
3731:
3732: BEGIN
3733: FORALL bulk_i IN l_lpn_bulk_rec.lpn_id.first .. l_lpn_bulk_rec.lpn_id.last
3734: UPDATE wms_license_plate_numbers wlpn
3735: SET last_update_date = SYSDATE
3736: , last_updated_by = fnd_global.user_id
3737: , organization_id = l_lpn_bulk_rec.organization_id(bulk_i)
3738: , license_plate_number = l_lpn_bulk_rec.license_plate_number(bulk_i)

Line 3786: FROM wms_license_plate_numbers

3782:
3783: FOR bulk_i IN l_lpn_bulk_rec.lpn_id.first..l_lpn_bulk_rec.lpn_id.last LOOP
3784: BEGIN
3785: SELECT 1 INTO l_dummy_num
3786: FROM wms_license_plate_numbers
3787: WHERE license_plate_number = l_lpn_bulk_rec.license_plate_number(bulk_i);
3788:
3789: IF ( l_debug = 1 ) THEN
3790: mdebug('LPN '||l_lpn_bulk_rec.license_plate_number(bulk_i)||' already exists, cannot update another LPN with this name', G_ERROR);

Line 3821: UPDATE wms_license_plate_numbers wlpn

3817: END LOOP;*/
3818: END IF;
3819:
3820: FORALL bulk_i IN l_lpn_bulk_rec.outermost_lpn_id.first .. l_lpn_bulk_rec.outermost_lpn_id.last
3821: UPDATE wms_license_plate_numbers wlpn
3822: SET last_update_date = SYSDATE
3823: , last_updated_by = fnd_global.user_id
3824: , outermost_lpn_id = l_lpn_bulk_rec.outermost_lpn_id(bulk_i)
3825: , organization_id = l_lpn_bulk_rec.organization_id(bulk_i)

Line 4677: FROM wms_license_plate_numbers

4673: l_change_in_volume_uom VARCHAR2(3);
4674:
4675: CURSOR nested_children_cursor(p_outer_lpn_id NUMBER) IS
4676: SELECT lpn_id
4677: FROM wms_license_plate_numbers
4678: START WITH lpn_id = p_outer_lpn_id
4679: CONNECT BY parent_lpn_id = PRIOR lpn_id;
4680:
4681: CURSOR nested_parent_cursor(p_child_lpn_id NUMBER) IS

Line 4685: FROM wms_license_plate_numbers

4681: CURSOR nested_parent_cursor(p_child_lpn_id NUMBER) IS
4682: SELECT organization_id, parent_lpn_id, lpn_id, inventory_item_id,
4683: tare_weight, tare_weight_uom_code, gross_weight, gross_weight_uom_code,
4684: container_volume, container_volume_uom, content_volume, content_volume_uom_code
4685: FROM wms_license_plate_numbers
4686: START WITH lpn_id = p_child_lpn_id
4687: CONNECT BY lpn_id = PRIOR parent_lpn_id;
4688:
4689: empty_lpn_rec nested_parent_cursor%ROWTYPE;

Line 4765: FROM wms_license_plate_numbers

4761: , organization_id
4762: , inventory_item_id
4763: , tare_weight
4764: , tare_weight_uom_code
4765: FROM wms_license_plate_numbers
4766: START WITH lpn_id = p_lpn_id
4767: CONNECT BY parent_lpn_id = PRIOR lpn_id;
4768:
4769: --13535759

Line 4773: FROM wms_license_plate_numbers

4769: --13535759
4770: --This Cursor gets all the LPNs in the Parent Heirarchy
4771: CURSOR get_all_parents IS
4772: SELECT lpn_id
4773: FROM wms_license_plate_numbers
4774: START WITH lpn_id = p_lpn_id
4775: CONNECT BY lpn_id = PRIOR parent_lpn_id;
4776: --13535759
4777:

Line 5518: SELECT 1 FROM wms_license_plate_numbers

5514: SELECT 1 FROM wms_lpn_contents
5515: WHERE organization_id = p_organization_id
5516: AND parent_lpn_id = l_lpn.lpn_id )
5517: OR EXISTS (
5518: SELECT 1 FROM wms_license_plate_numbers
5519: WHERE organization_id = p_organization_id
5520: AND parent_lpn_id = l_lpn.lpn_id
5521: AND lpn_id <> l_content_lpn.lpn_id );
5522: EXCEPTION

Line 5753: SELECT 1 FROM wms_license_plate_numbers

5749: SELECT 1 FROM wms_lpn_contents
5750: WHERE organization_id = p_organization_id
5751: AND parent_lpn_id = l_lpn.lpn_id )
5752: OR EXISTS (
5753: SELECT 1 FROM wms_license_plate_numbers
5754: WHERE organization_id = p_organization_id
5755: AND parent_lpn_id = l_lpn.lpn_id );
5756: EXCEPTION
5757: WHEN NO_DATA_FOUND THEN

Line 5950: SELECT 1 FROM wms_license_plate_numbers

5946: OR EXISTS (
5947: -- Check to make sure that the parent lpn has no lpns in it
5948: -- Ignore the child lpn that will become pregenerated later since
5949: -- we already know it will unpacked from the parent
5950: SELECT 1 FROM wms_license_plate_numbers
5951: WHERE organization_id = p_organization_id
5952: AND parent_lpn_id = empty_lpn_rec.parent_lpn_id
5953: AND lpn_id <> empty_lpn_rec.lpn_id );
5954: EXCEPTION

Line 6011: FROM wms_license_plate_numbers

6007: , l_wt_vol_new.tare_weight
6008: , l_wt_vol_new.tare_weight_uom_code
6009: , l_wt_vol_new.content_volume
6010: , l_wt_vol_new.content_volume_uom_code
6011: FROM wms_license_plate_numbers
6012: WHERE lpn_id = empty_lpn_rec.parent_lpn_id;
6013: END IF;
6014: END IF;
6015: END IF;

Line 7621: UPDATE wms_license_plate_numbers

7617: IF (l_debug = 1) THEN
7618: mdebug('setting lpn id= ' || l_lpn_to_pack || ' to context ' || l_lpn_source, G_INFO);
7619: END IF;
7620: -- Bug5659809: update last_update_date and last_update_by as well
7621: UPDATE wms_license_plate_numbers
7622: SET lpn_context = l_lpn_source
7623: , last_update_date = SYSDATE
7624: , last_updated_by = fnd_global.user_id
7625: WHERE lpn_id = l_lpn_to_pack;

Line 8113: UPDATE wms_license_plate_numbers

8109: AND inventory_item_id = p_content_item_id
8110: AND NVL(revision, G_NULL_CHAR) = NVL(p_revision, G_NULL_CHAR)
8111: AND NVL(lot_number, G_NULL_CHAR) = NVL(p_lot_number, G_NULL_CHAR);
8112:
8113: UPDATE wms_license_plate_numbers
8114: SET last_update_date = SYSDATE,
8115: last_updated_by = fnd_global.user_id,
8116: lpn_context = LPN_CONTEXT_WIP
8117: WHERE lpn_id = p_lpn_id

Line 8179: FROM WMS_LICENSE_PLATE_NUMBERS

8175:
8176: CURSOR nested_lpn_cursor IS
8177: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
8178: revision, lot_number, serial_number, cost_group_id
8179: FROM WMS_LICENSE_PLATE_NUMBERS
8180: WHERE Level <= p_explosion_level
8181: START WITH lpn_id = p_lpn_id
8182: CONNECT BY parent_lpn_id = PRIOR lpn_id;
8183:

Line 8187: FROM WMS_LICENSE_PLATE_NUMBERS

8183:
8184: CURSOR all_nested_lpn_cursor IS
8185: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
8186: revision, lot_number, serial_number, cost_group_id
8187: FROM WMS_LICENSE_PLATE_NUMBERS
8188: START WITH lpn_id = p_lpn_id
8189: CONNECT BY parent_lpn_id = PRIOR lpn_id;
8190:
8191: CURSOR lpn_contents_cursor IS

Line 8471: FROM WMS_LICENSE_PLATE_NUMBERS

8467: THEN
8468: IF ( p_lock = 1 ) THEN
8469: SELECT *
8470: INTO p_lpn
8471: FROM WMS_LICENSE_PLATE_NUMBERS
8472: WHERE LPN_ID = p_lpn.lpn_id
8473: FOR UPDATE;
8474: ELSE
8475: SELECT *

Line 8477: FROM WMS_LICENSE_PLATE_NUMBERS

8473: FOR UPDATE;
8474: ELSE
8475: SELECT *
8476: INTO p_lpn
8477: FROM WMS_LICENSE_PLATE_NUMBERS
8478: WHERE LPN_ID = p_lpn.lpn_id;
8479: END IF;
8480:
8481: RETURN T;

Line 8486: FROM WMS_LICENSE_PLATE_NUMBERS

8482: ELSIF (p_lpn.lpn_id IS NULL OR p_lpn.lpn_id = FND_API.G_MISS_NUM) THEN
8483: IF ( p_lock = 1 ) THEN
8484: SELECT *
8485: INTO p_lpn
8486: FROM WMS_LICENSE_PLATE_NUMBERS
8487: WHERE LICENSE_PLATE_NUMBER = p_lpn.license_plate_number
8488: FOR UPDATE;
8489: ELSE
8490: SELECT *

Line 8492: FROM WMS_LICENSE_PLATE_NUMBERS

8488: FOR UPDATE;
8489: ELSE
8490: SELECT *
8491: INTO p_lpn
8492: FROM WMS_LICENSE_PLATE_NUMBERS
8493: WHERE LICENSE_PLATE_NUMBER = p_lpn.license_plate_number;
8494: END IF;
8495:
8496: RETURN T;

Line 8501: FROM WMS_LICENSE_PLATE_NUMBERS

8497: ELSE
8498: IF ( p_lock = 1 ) THEN
8499: SELECT *
8500: INTO p_lpn
8501: FROM WMS_LICENSE_PLATE_NUMBERS
8502: WHERE LPN_ID = p_lpn.lpn_id
8503: AND LICENSE_PLATE_NUMBER = p_lpn.license_plate_number
8504: FOR UPDATE;
8505: ELSE

Line 8508: FROM WMS_LICENSE_PLATE_NUMBERS

8504: FOR UPDATE;
8505: ELSE
8506: SELECT *
8507: INTO p_lpn
8508: FROM WMS_LICENSE_PLATE_NUMBERS
8509: WHERE LPN_ID = p_lpn.lpn_id
8510: AND LICENSE_PLATE_NUMBER = p_lpn.license_plate_number;
8511: END IF;
8512:

Line 8537: FROM wms_license_plate_numbers

8533: l_progress VARCHAR2(10) := '0';
8534:
8535: CURSOR Nested_LPN_Cursor IS
8536: SELECT lpn_id, lpn_context
8537: FROM wms_license_plate_numbers
8538: WHERE outermost_lpn_id = p_lpn_id;
8539:
8540: lpn_rec Nested_LPN_Cursor%ROWTYPE;
8541: l_lpn_is_valid NUMBER := WMS_CONTAINER_PVT.F;

Line 8555: FROM wms_license_plate_numbers

8551: l_progress := '100';
8552: -- Check if the lpn_id entered is the outermost
8553: BEGIN
8554: SELECT parent_lpn_id INTO l_parent_lpn_id
8555: FROM wms_license_plate_numbers
8556: WHERE organization_id = p_organization_id
8557: AND lpn_id = p_lpn_id;
8558: EXCEPTION
8559: WHEN NO_DATA_FOUND THEN

Line 8742: FROM wms_license_plate_numbers

8738: l_label_return VARCHAR2(1);
8739:
8740: CURSOR Nested_LPN_cur IS
8741: SELECT lpn_id, lpn_context, subinventory_code, locator_id, parent_lpn_id
8742: FROM wms_license_plate_numbers
8743: WHERE lpn_id <> p_outermost_lpn_id
8744: START WITH lpn_id = p_outermost_lpn_id
8745: CONNECT BY parent_lpn_id = PRIOR lpn_id;
8746:

Line 9157: FROM WMS_LICENSE_PLATE_NUMBERS

9153: l_progress VARCHAR2(10) := '0';
9154:
9155: CURSOR nested_lpn_cursor IS
9156: SELECT rowid, lpn_id, parent_lpn_id, subinventory_code, locator_id
9157: FROM WMS_LICENSE_PLATE_NUMBERS
9158: WHERE lpn_id <> p_outermost_lpn_id
9159: START WITH lpn_id = p_outermost_lpn_id
9160: CONNECT BY parent_lpn_id = PRIOR lpn_id;
9161:

Line 9302: FROM wms_license_plate_numbers

9298: l_progress VARCHAR2(10) := '0';
9299:
9300: CURSOR nested_lpn_cursor IS
9301: SELECT rowid, lpn_id
9302: FROM wms_license_plate_numbers
9303: WHERE organization_id = p_organization_id
9304: AND outermost_lpn_id = p_outermost_lpn_id;
9305:
9306: BEGIN

Line 9340: UPDATE wms_license_plate_numbers

9336: DELETE FROM wms_lpn_contents
9337: WHERE parent_lpn_id = lpn_rec.lpn_id;
9338:
9339: -- Reset lpn properties to pregenerated
9340: UPDATE wms_license_plate_numbers
9341: SET lpn_context = LPN_CONTEXT_PREGENERATED
9342: , subinventory_code = NULL
9343: , locator_id = NULL
9344: , parent_lpn_id = NULL

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

9394: SELECT wda.delivery_id
9395: INTO l_delivery_id
9396: FROM wsh_delivery_details_ob_grp_v wdd,
9397: wsh_delivery_assignments wda
9398: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
9399: WHERE outermost_lpn_id = (SELECT outermost_lpn_id
9400: FROM wms_license_plate_numbers
9401: WHERE lpn_id = p_lpn_id)
9402: AND lpn_context = 11)

Line 9400: FROM wms_license_plate_numbers

9396: FROM wsh_delivery_details_ob_grp_v wdd,
9397: wsh_delivery_assignments wda
9398: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
9399: WHERE outermost_lpn_id = (SELECT outermost_lpn_id
9400: FROM wms_license_plate_numbers
9401: WHERE lpn_id = p_lpn_id)
9402: AND lpn_context = 11)
9403: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
9404: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 9484: FROM wms_license_plate_numbers

9480: END IF;
9481:
9482: if p_lpn_context is null THEN
9483: SELECT lpn_context INTO l_lpn_context
9484: FROM wms_license_plate_numbers
9485: WHERE lpn_id = p_lpn_id
9486: AND organization_id = p_org;
9487: else
9488: l_lpn_context := p_lpn_context;

Line 9499: FROM wms_license_plate_numbers

9495: FROM mtl_material_transactions_temp mmtt,
9496: mtl_system_items_b_kfv msikfv
9497: WHERE transfer_lpn_id IN
9498: (SELECT lpn_id
9499: FROM wms_license_plate_numbers
9500: START WITH lpn_id = p_lpn_id
9501: CONNECT BY PRIOR lpn_id = parent_lpn_id
9502: )
9503: AND mmtt.inventory_item_id = msikfv.inventory_item_id

Line 9514: FROM wms_license_plate_numbers

9510: FROM WMS_LPN_CONTENTS wlc,
9511: mtl_system_items_b_kfv msikfv
9512: WHERE wlc.parent_lpn_id IN
9513: (SELECT lpn_id
9514: FROM wms_license_plate_numbers
9515: START WITH lpn_id = p_lpn_id
9516: CONNECT BY PRIOR lpn_id = parent_lpn_id
9517: )
9518: AND wlc.inventory_item_id = msikfv.inventory_item_id

Line 9569: FROM WMS_LICENSE_PLATE_NUMBERS

9565: BEGIN
9566:
9567: SELECT OUTERMOST_LPN_ID, LICENSE_PLATE_NUMBER
9568: INTO L_OUTER_LPN_ID, L_LPN_NAME
9569: FROM WMS_LICENSE_PLATE_NUMBERS
9570: WHERE LPN_ID = P_LPN_ID;
9571:
9572: L_TYPE_NAME := 'ORGLPNLCK####'||L_OUTER_LPN_ID || '####' || P_ORG_ID;
9573: