[Home] [Help]
59: msik.serial_number_control_code,
60: moq.cost_group_id
61:
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. */
185: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
186: msik.lot_control_code lot_control_code,
187: msik.serial_number_control_code serial_number_control_code
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,
277: msn.serial_number,
278: msik.primary_uom_code,
279: 1
280: FROM MTL_SERIAL_NUMBERS msn,
281: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
282: MTL_ITEM_LOCATIONS_KFV milk
283: WHERE milk.organization_id(+) = msn.current_organization_id
284: AND milk.subinventory_code(+) = msn.current_subinventory_code
285: AND milk.inventory_location_id(+) = msn.current_locator_id
338: mms4.status_code serial_status,
339: msik.primary_uom_code,
340: 1
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,
484: cst_cost_groups ccg,
485: mtl_item_locations_kfv mlc ,
486: mtl_secondary_inventories msub,
487: mtl_item_locations_kfv milk,
488: mtl_system_items_vl msiv, /* Bug 5581528 */
489: mfg_lookups mlk
490: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
491: AND lpn.lpn_id = mmtt.transfer_lpn_id
492: AND lpn.organization_id = mp.organization_id
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
601: AND lpn.lpn_id = mmtt.transfer_lpn_id
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
708: AND lpn.lpn_id = wlc.parent_lpn_id
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
877: AND lpn.organization_id = mp.organization_id
1052: , msiv.secondary_uom_code
1053: -- INVCONV end
1054: FROM WMS_LPN_CONTENTS wlc
1055: , WMS_LICENSE_PLATE_NUMBERS lpn
1056: , mtl_system_items_vl msiv -- Modified for Bug # 5472330
1057: , mtl_parameters mp
1058: , wms_license_plate_numbers lpn3
1059: , cst_cost_groups ccg
1060: , mtl_item_locations mlc
1482: OPEN x_lot_attributes FOR
1483: SELECT mmst.status_code, mmst.status_id,
1484: msik.shelf_life_code, msik.lot_status_enabled, mtlt.lot_expiration_date
1485: FROM mtl_material_statuses_vl mmst,
1486: mtl_system_items_kfv msik,
1487: mtl_transaction_lots_temp mtlt,
1488: mtl_material_transactions_temp mmtt
1489: WHERE mtlt.lot_number = p_lot_number
1490: AND mmtt.organization_id = p_organization_id
1497: OPEN x_lot_attributes FOR
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
1534: FROM mtl_material_statuses_vl mmst,
1535: mtl_serial_numbers_temp msnt,
1536: mtl_material_transactions_temp mmtt,
1537: mtl_transaction_lots_temp mtlt,
1538: mtl_system_items_b msik
1539: WHERE mmtt.organization_id = p_organization_id
1540: AND mmtt.inventory_item_id = p_inventory_item_id
1541: AND msik.organization_id = mmtt.organization_id
1542: AND msik.inventory_item_id = mmtt.inventory_item_id
1547: ELSE
1548: /* All other Contexts */
1549: OPEN x_serial_attributes FOR
1550: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_id
1551: FROM mtl_material_statuses_vl mmst, mtl_serial_numbers msn, mtl_system_items_b msik
1552: WHERE msn.current_organization_id = p_organization_id
1553: AND msn.inventory_item_id = p_inventory_item_id
1554: AND msik.organization_id = msn.current_organization_id
1555: AND msik.inventory_item_id = msn.inventory_item_id
1842: cursor iteminfo is
1843: select nvl(msi.revision_qty_control_code, 1)
1844: ,nvl(msi.lot_control_code, 1)
1845: ,nvl(msi.serial_number_control_code,1)
1846: from mtl_system_items msi
1847: where organization_id = p_organization_id
1848: and inventory_item_id = p_inventory_item_id;
1849:
1850: BEGIN
1982: cursor iteminfo is
1983: select nvl(msi.revision_qty_control_code, 1)
1984: ,nvl(msi.lot_control_code, 1)
1985: ,nvl(msi.serial_number_control_code,1)
1986: from mtl_system_items msi
1987: where organization_id = p_organization_id
1988: and inventory_item_id = p_inventory_item_id;
1989:
1990: BEGIN
2138: sum(nvl(moq.secondary_transaction_quantity, 0)),
2139: msik.secondary_uom_code
2140: -- INVCONV end
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
2335: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2336: msik.secondary_uom_code secondary_uom_code
2337: -- INVCONV end
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,
2447: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2448: INV_PROJECT.GET_TASK_NUMBER task_number,
2449: msik.serial_number_control_code serial_number_control_code
2450: FROM MTL_SERIAL_NUMBERS msn,
2451: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2452: MTL_ITEM_LOCATIONS milk
2453: WHERE milk.organization_id(+) = msn.current_organization_id
2454: AND milk.subinventory_code(+) = msn.current_subinventory_code
2455: AND milk.inventory_location_id(+) = msn.current_locator_id
2533: ---NVL(msik.tracking_quantity_ind, 'P'),
2534: ---msik.secondary_uom_code
2535: -- INVCONV end
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,
2685: msn.cost_group_id,
2686: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2687: INV_PROJECT.GET_TASK_NUMBER task_number
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
2806: msik.serial_number_control_code serial_number_control_code,
2807: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2808: INV_PROJECT.GET_TASK_NUMBER task_number
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,
2981: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
2982: msik.lot_control_code lot_control_code,
2983: msik.serial_number_control_code serial_number_control_code
2984: FROM mtl_onhand_quantities_detail moq,
2985: mtl_system_items_vl msik, /* Bug 5581528 */
2986: mtl_item_locations milk,
2987: mtl_secondary_inventories msub,
2988: mtl_material_statuses_vl mms1,
2989: mtl_material_statuses_vl mms2