[Home] [Help]
446: SELECT DISTINCT wlc.lot_number
447: , mln.description
448: , mln.expiration_date
449: , mmst.status_code
450: FROM mtl_lot_numbers mln, wms_lpn_contents wlc,
451: mtl_material_statuses_tl mmst
452: WHERE mln.lot_number = wlc.lot_number
453: AND mln.inventory_item_id = p_inventory_item_id
454: AND mln.organization_id = p_organization_id
753: OPEN x_cost_group_lov FOR
754: SELECT ccg.cost_group
755: , ccg.cost_group_id
756: , ccg.description
757: FROM cst_cost_groups ccg, wms_lpn_contents wlc
758: WHERE ccg.cost_group LIKE (p_from_cost_group)
759: AND ccg.cost_group_id = wlc.cost_group_id
760: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
761: AND ((wlc.revision = p_revision)
1720: , mln.description
1721: , mln.expiration_date
1722: , '0'
1723: , '0' --wlc.quantity
1724: FROM mtl_lot_numbers mln, wms_lpn_contents wlc
1725: WHERE wlc.organization_id = p_organization_id
1726: AND wlc.inventory_item_id = p_item_id
1727: AND NVL(wlc.parent_lpn_id, '0') = NVL(p_lpn_id, NVL(wlc.parent_lpn_id, '0'))
1728: AND mln.inventory_item_id = wlc.inventory_item_id
1741: , mln.description
1742: , mln.expiration_date
1743: , '0'
1744: , wlc.quantity
1745: FROM mtl_lot_numbers mln, wms_lpn_contents wlc
1746: WHERE wlc.organization_id = p_organization_id
1747: AND wlc.inventory_item_id = p_item_id
1748: AND NVL(wlc.parent_lpn_id, '0') = NVL(p_lpn_id, NVL(wlc.parent_lpn_id, '0'))
1749: AND mln.inventory_item_id = wlc.inventory_item_id
1978: , mmst.status_code
1979: , mtlt.primary_quantity
1980: , mtlt.transaction_quantity
1981: FROM mtl_lot_numbers mln,
1982: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
1983: mtl_material_statuses_tl mmst
1984: WHERE mln.organization_id = p_organization_id
1985: AND mln.inventory_item_id = p_item_id
1986: AND mln.lot_number LIKE (p_lot_number)
2041: , mmst.status_code
2042: , mtlt.primary_quantity
2043: , mtlt.transaction_quantity
2044: FROM mtl_lot_numbers mln,
2045: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
2046: mtl_material_statuses_tl mmst
2047: WHERE mln.organization_id = p_organization_id
2048: AND mln.inventory_item_id = p_item_id
2049: AND mln.lot_number LIKE (p_lot_number)
2155: SELECT DISTINCT mln.lot_number
2156: , mln.description
2157: , mln.expiration_date
2158: , mstl.status_code
2159: FROM mtl_lot_numbers mln, wms_lpn_contents wlpnc, mtl_material_statuses_b mstb, mtl_material_statuses_tl mstl
2160: WHERE wlpnc.parent_lpn_id = p_lpn_id
2161: AND wlpnc.organization_id = p_org_id
2162: AND wlpnc.inventory_item_id = p_item_id
2163: AND ((wlpnc.revision = p_revision
2269: SELECT DISTINCT mln.lot_number
2270: , mln.description
2271: , mln.expiration_date
2272: , mmst.status_code
2273: FROM mtl_lot_numbers mln, wms_lpn_contents wlc,
2274: mtl_material_statuses_tl mmst
2275: WHERE wlc.organization_id = p_organization_id
2276: AND wlc.inventory_item_id = p_item_id
2277: AND wlc.parent_lpn_id = p_lpn_id
2407: SELECT mln.lot_number
2408: , mln.description
2409: , mln.expiration_date
2410: , mmst.status_code
2411: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2412: WHERE wlpn.license_plate_number = p_lpn
2413: AND wlc.parent_lpn_id = wlpn.lpn_id
2414: AND mln.lot_number = wlc.lot_number
2415: AND mln.organization_id = p_organization_id
2451: SELECT mln.lot_number
2452: , mln.description
2453: , mln.expiration_date
2454: , mmst.status_code
2455: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2456: WHERE wlpn.license_plate_number = p_lpn
2457: AND wlc.parent_lpn_id = wlpn.lpn_id
2458: AND mln.lot_number = wlc.lot_number
2459: AND mln.organization_id = p_organization_id