[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,
592: cst_cost_groups ccg,
593: mtl_item_locations_kfv mlc ,
594: mtl_secondary_inventories msub,
595: mtl_item_locations_kfv milk,
596: mtl_lot_numbers mln,
597: mtl_system_items_vl msiv, /* Bug 5581528 */
598: mfg_lookups mlk
599: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
600: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
699: mtl_item_locations mlc ,
700: mtl_secondary_inventories msub,
701: mtl_item_locations milk,
702: mtl_item_locations milk2,
703: mtl_lot_numbers mln,
704: mtl_system_items_vl msiv, /* Bug 5581528 */
705: mfg_lookups mlk,
706: wms_shipping_transaction_temp wstt
707: WHERE wlc.parent_lpn_id = p_parent_lpn_id
868: cst_cost_groups ccg,
869: mtl_item_locations mlc ,
870: mtl_secondary_inventories msub,
871: mtl_item_locations milk,
872: mtl_lot_numbers mln,
873: mtl_system_items_vl msiv, /* Bug 5581528 */
874: mfg_lookups mlk
875: WHERE
876: lpn.lpn_id = wwlc.parent_lpn_id
1058: , wms_license_plate_numbers lpn3
1059: , cst_cost_groups ccg
1060: , mtl_item_locations mlc
1061: , mtl_secondary_inventories msub
1062: , mtl_lot_numbers mln
1063: , mfg_lookups mlk
1064:
1065: WHERE lpn.organization_id = p_organization_id
1066: AND wlc.inventory_item_id = p_inventory_item_id
1498: SELECT mmst.status_code, mmst.status_id,
1499: msik.shelf_life_code, msik.lot_status_enabled, mln.expiration_date
1500: FROM mtl_material_statuses_vl mmst,
1501: mtl_system_items_kfv msik,
1502: mtl_lot_numbers mln
1503: WHERE mln.lot_number = p_lot_number
1504: AND mln.organization_id = p_organization_id
1505: AND msik.inventory_item_id = p_inventory_item_id
1506: AND mmst.status_id(+) = mln.status_id
2141: FROM mtl_onhand_quantities_detail moq,
2142: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2143: mtl_item_locations mil,
2144: mtl_secondary_inventories msub,
2145: mtl_lot_numbers mln
2146: WHERE moq.organization_id = msik.organization_id
2147: AND moq.inventory_item_id = msik.inventory_item_id
2148: AND moq.organization_id = msub.organization_id
2149: AND moq.subinventory_code = msub.secondary_inventory_name(+)
2338: FROM mtl_onhand_quantities_detail moq,
2339: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2340: mtl_item_locations milk,
2341: mtl_secondary_inventories msub,
2342: mtl_lot_numbers mlot,
2343: mtl_material_statuses_vl mms1,
2344: mtl_material_statuses_vl mms2,
2345: mtl_material_statuses_vl mms3,
2346: cst_cost_groups csg
2536: FROM MTL_SERIAL_NUMBERS msn,
2537: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2538: MTL_ITEM_LOCATIONS milk,
2539: MTL_SECONDARY_INVENTORIES msub,
2540: MTL_LOT_NUMBERS mlot,
2541: MTL_MATERIAL_STATUSES_vl mms1,
2542: MTL_MATERIAL_STATUSES_vl mms2,
2543: MTL_MATERIAL_STATUSES_vl mms3,
2544: MTL_MATERIAL_STATUSES_vl mms4,
2688: FROM MTL_SERIAL_NUMBERS msn,
2689: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2690: MTL_ITEM_LOCATIONS milk,
2691: MTL_SECONDARY_INVENTORIES msub,
2692: MTL_LOT_NUMBERS mln
2693: WHERE msn.inventory_item_id = p_Inventory_Item_Id
2694: AND milk.organization_id(+) = msn.current_organization_id
2695: AND milk.subinventory_code(+) = msn.current_subinventory_code
2696: AND milk.inventory_location_id(+) = msn.current_locator_id
2809: FROM mtl_serial_numbers msn,
2810: mtl_system_items_vl msik, /* Bug 5581528 */
2811: mtl_item_locations milk,
2812: mtl_secondary_inventories msub,
2813: mtl_lot_numbers mlot,
2814: mtl_material_statuses_vl mms1,
2815: mtl_material_statuses_vl mms2,
2816: mtl_material_statuses_vl mms3,
2817: cst_cost_groups csg