APPS.INV_PHY_INV_LOVS dependencies on WMS_LPN_CONTENTS

Line 1687: FROM WMS_LPN_CONTENTS

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 *
1687: FROM WMS_LPN_CONTENTS
1688: WHERE parent_lpn_id = l_current_lpn
1689: AND NVL(serial_summary_entry, 2) = 2;
1690: CURSOR lpn_serial_contents_cursor IS
1691: 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 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