[Home] [Help]
468: SELECT DISTINCT wlc.lot_number
469: , mln.description
470: , mln.expiration_date
471: , mmst.status_code
472: FROM mtl_lot_numbers mln, wms_lpn_contents wlc,
473: mtl_material_statuses_tl mmst
474: WHERE mln.lot_number = wlc.lot_number
475: AND mln.inventory_item_id = p_inventory_item_id
476: AND mln.organization_id = p_organization_id
775: OPEN x_cost_group_lov FOR
776: SELECT ccg.cost_group
777: , ccg.cost_group_id
778: , ccg.description
779: FROM cst_cost_groups ccg, wms_lpn_contents wlc
780: WHERE ccg.cost_group LIKE (p_from_cost_group)
781: AND ccg.cost_group_id = wlc.cost_group_id
782: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
783: AND ((wlc.revision = p_revision)
1744: , mln.description
1745: , mln.expiration_date
1746: , '0'
1747: , '0' --wlc.quantity
1748: FROM mtl_lot_numbers mln, wms_lpn_contents wlc
1749: WHERE wlc.organization_id = p_organization_id
1750: AND wlc.inventory_item_id = p_item_id
1751: AND wlc.parent_lpn_id = p_lpn_id --BUG12394466 removed the NVL condition for perf as parent_lpn_id is NOT NULL column
1752: AND mln.inventory_item_id = wlc.inventory_item_id
1765: , mln.description
1766: , mln.expiration_date
1767: , '0'
1768: , wlc.quantity
1769: FROM mtl_lot_numbers mln, wms_lpn_contents wlc
1770: WHERE wlc.organization_id = p_organization_id
1771: AND wlc.inventory_item_id = p_item_id
1772: AND wlc.parent_lpn_id = p_lpn_id --BUG12394466 removed the NVL condition for perf as parent_lpn_id is NOT NULL column
1773: AND mln.inventory_item_id = wlc.inventory_item_id
2002: , mmst.status_code
2003: , mtlt.primary_quantity
2004: , mtlt.transaction_quantity
2005: FROM mtl_lot_numbers mln,
2006: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
2007: mtl_material_statuses_tl mmst
2008: WHERE mln.organization_id = p_organization_id
2009: AND mln.inventory_item_id = p_item_id
2010: AND mln.lot_number LIKE (p_lot_number)
2065: , mmst.status_code
2066: , mtlt.primary_quantity
2067: , mtlt.transaction_quantity
2068: FROM mtl_lot_numbers mln,
2069: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
2070: mtl_material_statuses_tl mmst
2071: WHERE mln.organization_id = p_organization_id
2072: AND mln.inventory_item_id = p_item_id
2073: AND mln.lot_number LIKE (p_lot_number)
2185: SELECT DISTINCT mln.lot_number
2186: , mln.description
2187: , mln.expiration_date
2188: , mstl.status_code
2189: FROM mtl_lot_numbers mln, wms_lpn_contents wlpnc, mtl_material_statuses_b mstb, mtl_material_statuses_tl mstl
2190: WHERE wlpnc.parent_lpn_id = p_lpn_id
2191: AND wlpnc.organization_id = p_org_id
2192: AND wlpnc.inventory_item_id = p_item_id
2193: AND ((wlpnc.revision = p_revision
2299: SELECT DISTINCT mln.lot_number
2300: , mln.description
2301: , mln.expiration_date
2302: , mmst.status_code
2303: FROM mtl_lot_numbers mln, wms_lpn_contents wlc,
2304: mtl_material_statuses_tl mmst
2305: WHERE wlc.organization_id = p_organization_id
2306: AND wlc.inventory_item_id = p_item_id
2307: AND wlc.parent_lpn_id = p_lpn_id
2443: SELECT mln.lot_number
2444: , mln.description
2445: , mln.expiration_date
2446: , mmst.status_code
2447: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2448: WHERE wlpn.license_plate_number = p_lpn
2449: AND wlc.parent_lpn_id = wlpn.lpn_id
2450: AND mln.lot_number = wlc.lot_number
2451: AND mln.organization_id = p_organization_id
2493: SELECT mln.lot_number
2494: , mln.description
2495: , mln.expiration_date
2496: , mmst.status_code
2497: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2498: WHERE wlpn.license_plate_number = p_lpn
2499: AND wlc.parent_lpn_id = wlpn.lpn_id
2500: AND mln.lot_number = wlc.lot_number
2501: AND mln.organization_id = p_organization_id