APPS.INV_PHY_INV_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 916: FROM WMS_LICENSE_PLATE_NUMBERS

912: */
913: BEGIN
914: SELECT outermost_lpn_id
915: INTO l_outermost_lpn_id
916: FROM WMS_LICENSE_PLATE_NUMBERS
917: WHERE lpn_id = p_parent_lpn_id;
918: EXCEPTION
919: WHEN OTHERS THEN
920: IF (l_debug = 1) THEN

Line 1134: FROM WMS_LICENSE_PLATE_NUMBERS

1130: */
1131: BEGIN
1132: SELECT outermost_lpn_id
1133: INTO l_outermost_lpn_id
1134: FROM WMS_LICENSE_PLATE_NUMBERS
1135: WHERE lpn_id = p_parent_lpn_id;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: IF (l_debug = 1) THEN

Line 1569: FROM WMS_LICENSE_PLATE_NUMBERS

1565:
1566: BEGIN
1567: SELECT outermost_lpn_id
1568: INTO l_outermost_lpn_id
1569: FROM WMS_LICENSE_PLATE_NUMBERS
1570: WHERE lpn_id = p_parent_lpn_id;
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: IF (l_debug = 1) THEN

Line 1682: FROM WMS_LICENSE_PLATE_NUMBERS

1678: l_current_lpn NUMBER;
1679: l_temp_uom_code VARCHAR2(3);
1680: CURSOR nested_lpn_cursor IS
1681: SELECT *
1682: FROM WMS_LICENSE_PLATE_NUMBERS
1683: START WITH lpn_id = p_parent_lpn_id
1684: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1685: CURSOR lpn_contents_cursor IS
1686: SELECT *

Line 2120: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc

2116:
2117: IF p_serial_number IS NULL
2118: THEN
2119: SELECT quantity, secondary_quantity INTO l_sys_qty, l_sec_sys_qty
2120: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc
2121: WHERE wlpn.lpn_id = wlc.parent_lpn_id
2122: AND wlpn.lpn_id = p_parent_lpn_id
2123: AND wlpn.subinventory_code = l_subinv
2124: AND wlpn.locator_id = l_locator

Line 2134: FROM wms_license_plate_numbers wlpn

2130: ELSIF p_serial_number IS NOT NULL
2131: THEN
2132:
2133: SELECT 1 INTO l_sys_qty
2134: FROM wms_license_plate_numbers wlpn
2135: WHERE wlpn.lpn_id = p_parent_lpn_id
2136: AND wlpn.subinventory_code = l_subinv
2137: AND wlpn.locator_id = l_locator;
2138:

Line 2250: FROM wms_license_plate_numbers wlp, mtl_physical_adjustments mpa, wms_lpn_contents wlc

2246: wlc.secondary_quantity,
2247: wlc.serial_summary_entry,
2248: wlc.revision,
2249: wlc.cost_group_id
2250: FROM wms_license_plate_numbers wlp, mtl_physical_adjustments mpa, wms_lpn_contents wlc
2251: WHERE wlp.lpn_id = wlc.parent_lpn_id
2252: AND mpa.parent_lpn_id = wlp.lpn_id
2253: AND mpa.organization_id = p_org_id
2254: AND mpa.physical_inventory_id = p_phy_inv_id