[Home] [Help]
62: FROM mtl_onhand_quantities_detail moq,
63: mtl_system_items_vl msik, -- Modified for Bug # 5472330
64: mtl_item_locations_kfv milk,
65: mtl_secondary_inventories msub,
66: mtl_lot_numbers mln
67: /* mtl_serial_numbers msn Commenting for bug 1643966 as this table is not reqd. */
68: WHERE moq.organization_id = msik.organization_id
69: AND moq.inventory_item_id = msik.inventory_item_id
70: AND moq.organization_id = msub.organization_id
188: FROM mtl_onhand_quantities_detail moq,
189: mtl_system_items_vl msik, -- Modified for Bug # 5472330
190: mtl_item_locations_kfv milk,
191: mtl_secondary_inventories msub,
192: mtl_lot_numbers mlot,
193: mtl_material_statuses_vl mms1,
194: mtl_material_statuses_vl mms2,
195: mtl_material_statuses_vl mms3,
196: cst_cost_groups csg
341: FROM MTL_SERIAL_NUMBERS msn,
342: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
343: MTL_ITEM_LOCATIONS_KFV milk,
344: MTL_SECONDARY_INVENTORIES msub,
345: MTL_LOT_NUMBERS mlot,
346: MTL_MATERIAL_STATUSES_vl mms1,
347: MTL_MATERIAL_STATUSES_vl mms2,
348: MTL_MATERIAL_STATUSES_vl mms3,
349: MTL_MATERIAL_STATUSES_vl mms4,
554: cst_cost_groups ccg,
555: mtl_item_locations_kfv mlc ,
556: mtl_secondary_inventories msub,
557: mtl_item_locations_kfv milk,
558: mtl_lot_numbers mln,
559: mtl_system_items_vl msiv, /* Bug 5581528 */
560: mfg_lookups mlk
561: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
562: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
623: mtl_item_locations mlc ,
624: mtl_secondary_inventories msub,
625: mtl_item_locations milk,
626: mtl_item_locations milk2,
627: mtl_lot_numbers mln,
628: mtl_system_items_vl msiv, /* Bug 5581528 */
629: mfg_lookups mlk,
630: wms_shipping_transaction_temp wstt
631: WHERE wlc.parent_lpn_id = p_parent_lpn_id
792: cst_cost_groups ccg,
793: mtl_item_locations mlc ,
794: mtl_secondary_inventories msub,
795: mtl_item_locations milk,
796: mtl_lot_numbers mln,
797: mtl_system_items_vl msiv, /* Bug 5581528 */
798: mfg_lookups mlk
799: WHERE
800: lpn.lpn_id = wwlc.parent_lpn_id
982: , wms_license_plate_numbers lpn3
983: , cst_cost_groups ccg
984: , mtl_item_locations mlc
985: , mtl_secondary_inventories msub
986: , mtl_lot_numbers mln
987: , mfg_lookups mlk
988:
989: WHERE lpn.organization_id = p_organization_id
990: AND wlc.inventory_item_id = p_inventory_item_id
1422: SELECT mmst.status_code, mmst.status_id,
1423: msik.shelf_life_code, msik.lot_status_enabled, mln.expiration_date
1424: FROM mtl_material_statuses_vl mmst,
1425: mtl_system_items_kfv msik,
1426: mtl_lot_numbers mln
1427: WHERE mln.lot_number = p_lot_number
1428: AND mln.organization_id = p_organization_id
1429: AND msik.inventory_item_id = p_inventory_item_id
1430: AND mmst.status_id(+) = mln.status_id
2065: FROM mtl_onhand_quantities_detail moq,
2066: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2067: mtl_item_locations mil,
2068: mtl_secondary_inventories msub,
2069: mtl_lot_numbers mln
2070: WHERE moq.organization_id = msik.organization_id
2071: AND moq.inventory_item_id = msik.inventory_item_id
2072: AND moq.organization_id = msub.organization_id
2073: AND moq.subinventory_code = msub.secondary_inventory_name(+)
2242: FROM mtl_onhand_quantities_detail moq,
2243: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2244: mtl_item_locations milk,
2245: mtl_secondary_inventories msub,
2246: mtl_lot_numbers mlot,
2247: mtl_material_statuses_vl mms1,
2248: mtl_material_statuses_vl mms2,
2249: mtl_material_statuses_vl mms3,
2250: cst_cost_groups csg
2440: FROM MTL_SERIAL_NUMBERS msn,
2441: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2442: MTL_ITEM_LOCATIONS milk,
2443: MTL_SECONDARY_INVENTORIES msub,
2444: MTL_LOT_NUMBERS mlot,
2445: MTL_MATERIAL_STATUSES_vl mms1,
2446: MTL_MATERIAL_STATUSES_vl mms2,
2447: MTL_MATERIAL_STATUSES_vl mms3,
2448: MTL_MATERIAL_STATUSES_vl mms4,
2592: FROM MTL_SERIAL_NUMBERS msn,
2593: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2594: MTL_ITEM_LOCATIONS milk,
2595: MTL_SECONDARY_INVENTORIES msub,
2596: MTL_LOT_NUMBERS mln
2597: WHERE msn.inventory_item_id = p_Inventory_Item_Id
2598: AND milk.organization_id(+) = msn.current_organization_id
2599: AND milk.subinventory_code(+) = msn.current_subinventory_code
2600: AND milk.inventory_location_id(+) = msn.current_locator_id
2713: FROM mtl_serial_numbers msn,
2714: mtl_system_items_vl msik, /* Bug 5581528 */
2715: mtl_item_locations milk,
2716: mtl_secondary_inventories msub,
2717: mtl_lot_numbers mlot,
2718: mtl_material_statuses_vl mms1,
2719: mtl_material_statuses_vl mms2,
2720: mtl_material_statuses_vl mms3,
2721: cst_cost_groups csg