eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_INQ dependencies on MTL_SERIAL_NUMBERS

Line 67: /* mtl_serial_numbers msn Commenting for bug 1643966 as this table is not reqd. */

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
71: AND moq.subinventory_code = msub.secondary_inventory_name(+)

Line 280: FROM MTL_SERIAL_NUMBERS msn,

276: msn.lot_number,
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

Line 341: FROM MTL_SERIAL_NUMBERS msn,

337: msn.serial_number,
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,

Line 1010: (select 1 from mtl_serial_numbers msn

1006: AND nvl(wlc.cost_group_id, 9999) = nvl(p_cost_group_id, 9999) */
1007: AND ((p_cost_group_id IS NULL) OR
1008: (wlc.cost_group_id = p_cost_group_id) OR
1009: ( ( wlc.cost_group_id IS NULL OR wlc.cost_group_id <> p_cost_group_id )AND msiv.serial_number_control_code in (2,5) AND exists
1010: (select 1 from mtl_serial_numbers msn
1011: where msn.lpn_id = wlc.parent_lpn_id
1012: and msn.cost_group_id = p_cost_group_id
1013: )
1014: )

Line 1018: AND (p_serial_number IS NULL OR EXISTS (SELECT 1 FROM mtl_serial_numbers msn

1014: )
1015: ) -- Bug 4731897
1016: --AND nvl(wlc.cost_group_id, nvl(p_cost_group_id, 9999) )= nvl(p_cost_group_id, 9999)--Bug 4731897
1017: -- Bug 4928751
1018: AND (p_serial_number IS NULL OR EXISTS (SELECT 1 FROM mtl_serial_numbers msn
1019: WHERE msn.serial_number=p_serial_number
1020: AND msn.current_organization_id=p_organization_id
1021: AND msn.lpn_id=wlc.parent_lpn_id
1022: AND msn.inventory_item_id=p_inventory_item_id ) )

Line 1459: mtl_serial_numbers_temp msnt,

1455: /* PACKING CONTEXT */
1456: OPEN x_serial_attributes FOR
1457: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_id
1458: FROM mtl_material_statuses_vl mmst,
1459: mtl_serial_numbers_temp msnt,
1460: mtl_material_transactions_temp mmtt,
1461: mtl_transaction_lots_temp mtlt,
1462: mtl_system_items_b msik
1463: WHERE mmtt.organization_id = p_organization_id

Line 1475: FROM mtl_material_statuses_vl mmst, mtl_serial_numbers msn, mtl_system_items_b msik

1471: ELSE
1472: /* All other Contexts */
1473: OPEN x_serial_attributes FOR
1474: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_id
1475: FROM mtl_material_statuses_vl mmst, mtl_serial_numbers msn, mtl_system_items_b msik
1476: WHERE msn.current_organization_id = p_organization_id
1477: AND msn.inventory_item_id = p_inventory_item_id
1478: AND msik.organization_id = msn.current_organization_id
1479: AND msik.inventory_item_id = msn.inventory_item_id

Line 1500: from mtl_serial_numbers

1496: * Add current status of resides in receiving
1497: */
1498: OPEN x_serialLOV for
1499: select serial_number, current_subinventory_code, current_locator_id, lot_number,'', current_status, ''
1500: from mtl_serial_numbers
1501: where current_organization_id = p_organization_id
1502: and inventory_item_id = p_inventory_item_id
1503: --and current_status in (3, 5)
1504: AND current_status in (3, 5, 7)

Line 1521: from mtl_serial_numbers msn, mtl_item_locations_kfv milk

1517: */
1518: OPEN x_serialLOV for
1519: select msn.serial_number, msn.current_subinventory_code, milk.concatenated_segments
1520: , msn.lot_number,'', msn.current_status, '', msn.current_locator_id
1521: from mtl_serial_numbers msn, mtl_item_locations_kfv milk
1522: where msn.current_organization_id = p_organization_id
1523: and msn.inventory_item_id = p_inventory_item_id
1524: --and msn.current_status in (3, 5)
1525: AND msn.current_status in (3, 5, 7)

Line 1548: from mtl_serial_numbers

1544: BEGIN
1545:
1546: OPEN x_serialLOV for
1547: select serial_number, current_subinventory_code, current_locator_id, lot_number,'', current_status, ''
1548: from mtl_serial_numbers
1549: where current_organization_id = p_organization_id
1550: and inventory_item_id = p_inventory_item_id
1551: AND(
1552: (current_organization_id = p_organization_id AND current_status = 1)

Line 1590: from mtl_serial_numbers

1586: /* FP-J Lot/Serial Support Enhancements
1587: * Add current status of resides in receiving */
1588: OPEN x_serialLOV for
1589: select serial_number, current_subinventory_code, current_locator_id, lot_number
1590: from mtl_serial_numbers
1591: where current_organization_id = p_organization_id
1592: and inventory_item_id = p_inventory_item_id
1593: --and current_status in (3, 5)
1594: AND current_status in (3, 5, 7)

Line 1619: FROM mtl_serial_numbers

1615: IS
1616: BEGIN
1617: OPEN x_serial_number FOR
1618: SELECT serial_number, current_subinventory_code, current_locator_id, lot_number, 'A', 'A', 'A'
1619: FROM mtl_serial_numbers
1620: WHERE inventory_item_id = TO_NUMBER(p_item_id)
1621: AND (group_mark_id is null OR group_mark_id = -1)
1622: AND current_organization_id = p_organization_id
1623: --AND ( (current_organization_id = p_organization_id AND current_status = 1)

Line 1643: from mtl_serial_numbers ms

1639: p_lot_number IN VARCHAR2) IS
1640: BEGIN
1641: open x_serial_numbers FOR
1642: select ms.serial_number, ms.lpn_id
1643: from mtl_serial_numbers ms
1644: where ms.inventory_item_id = p_inventory_item_id
1645: and ms.current_organization_id = p_organization_id
1646: and nvl(ms.revision, '$@#$%') =
1647: decode(p_revision, NULL, nvl(ms.revision, '$@#$%'), p_revision)

Line 1688: FROM mtl_serial_numbers_temp msnt,

1684: THEN
1685: /* PACKING CONTEXT */
1686: OPEN x_serial_numbers FOR
1687: SELECT msnt.fm_serial_number, mmtt.transfer_lpn_id, mtlt.lot_number
1688: FROM mtl_serial_numbers_temp msnt,
1689: mtl_material_transactions_temp mmtt,
1690: mtl_transaction_lots_temp mtlt
1691: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1692: and nvl(mtlt.serial_transaction_temp_id,mmtt.transaction_temp_id) = msnt.transaction_temp_id

Line 1704: FROM mtl_serial_numbers ms

1700: * Add current status of resides in receiving */
1701: /* All other Contexts */
1702: OPEN x_serial_numbers FOR
1703: SELECT ms.serial_number, ms.lpn_id
1704: FROM mtl_serial_numbers ms
1705: WHERE ms.inventory_item_id = p_inventory_item_id
1706: AND ms.current_organization_id = p_organization_id
1707: AND nvl(ms.revision, '$@#$%') = decode(p_revision, NULL, nvl(ms.revision, '$@#$%'), p_revision)
1708: AND nvl(ms.lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(ms.lot_number, '$@#$%'), p_lot_number)

Line 2354: FROM MTL_SERIAL_NUMBERS msn,

2350: 1,
2351: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2352: INV_PROJECT.GET_TASK_NUMBER task_number,
2353: msik.serial_number_control_code serial_number_control_code
2354: FROM MTL_SERIAL_NUMBERS msn,
2355: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2356: MTL_ITEM_LOCATIONS milk
2357: WHERE milk.organization_id(+) = msn.current_organization_id
2358: AND milk.subinventory_code(+) = msn.current_subinventory_code

Line 2440: FROM MTL_SERIAL_NUMBERS msn,

2436: -- INVCONV start
2437: ---NVL(msik.tracking_quantity_ind, 'P'),
2438: ---msik.secondary_uom_code
2439: -- INVCONV end
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,

Line 2506: FROM mtl_serial_numbers

2502: p_restrict_unit_numbers IN VARCHAR2) IS
2503: BEGIN
2504: OPEN x_unit_numbers FOR
2505: SELECT distinct end_item_unit_number
2506: FROM mtl_serial_numbers
2507: WHERE inventory_item_id = p_inventory_item_id
2508: AND current_organization_id = p_organization_id
2509: AND end_item_unit_number IS NOT NULL
2510: AND end_item_unit_number like (p_restrict_unit_numbers)

Line 2534: from mtl_serial_numbers ms

2530: p_serial_number IN VARCHAR2 := NULL) IS
2531: BEGIN
2532: open x_serial_numbers FOR
2533: select ms.serial_number, ms.lpn_id
2534: from mtl_serial_numbers ms
2535: where ms.inventory_item_id = p_inventory_item_id
2536: and ms.current_organization_id = p_organization_id
2537: and nvl(ms.revision, '$@#$%') =
2538: decode(p_revision, NULL, nvl(ms.revision, '$@#$%'), p_revision)

Line 2592: FROM MTL_SERIAL_NUMBERS msn,

2588: msik.serial_number_control_code,
2589: msn.cost_group_id,
2590: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2591: INV_PROJECT.GET_TASK_NUMBER task_number
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

Line 2713: FROM mtl_serial_numbers msn,

2709: msik.lot_control_code lot_control_code,
2710: msik.serial_number_control_code serial_number_control_code,
2711: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2712: INV_PROJECT.GET_TASK_NUMBER task_number
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,