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 1086: (select 1 from mtl_serial_numbers msn

1082: AND nvl(wlc.cost_group_id, 9999) = nvl(p_cost_group_id, 9999) */
1083: AND ((p_cost_group_id IS NULL) OR
1084: (wlc.cost_group_id = p_cost_group_id) OR
1085: ( ( 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
1086: (select 1 from mtl_serial_numbers msn
1087: where msn.lpn_id = wlc.parent_lpn_id
1088: and msn.cost_group_id = p_cost_group_id
1089: )
1090: )

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

1090: )
1091: ) -- Bug 4731897
1092: --AND nvl(wlc.cost_group_id, nvl(p_cost_group_id, 9999) )= nvl(p_cost_group_id, 9999)--Bug 4731897
1093: -- Bug 4928751
1094: AND (p_serial_number IS NULL OR EXISTS (SELECT 1 FROM mtl_serial_numbers msn
1095: WHERE msn.serial_number=p_serial_number
1096: AND msn.current_organization_id=p_organization_id
1097: AND msn.lpn_id=wlc.parent_lpn_id
1098: AND msn.inventory_item_id=p_inventory_item_id ) )

Line 1535: mtl_serial_numbers_temp msnt,

1531: /* PACKING CONTEXT */
1532: OPEN x_serial_attributes FOR
1533: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_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

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

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

Line 1576: from mtl_serial_numbers

1572: * Add current status of resides in receiving
1573: */
1574: OPEN x_serialLOV for
1575: select serial_number, current_subinventory_code, current_locator_id, lot_number,'', current_status, ''
1576: from mtl_serial_numbers
1577: where current_organization_id = p_organization_id
1578: and inventory_item_id = p_inventory_item_id
1579: --and current_status in (3, 5)
1580: AND current_status in (3, 5, 7)

Line 1597: from mtl_serial_numbers msn, mtl_item_locations_kfv milk

1593: */
1594: OPEN x_serialLOV for
1595: select msn.serial_number, msn.current_subinventory_code, milk.concatenated_segments
1596: , msn.lot_number,'', msn.current_status, '', msn.current_locator_id
1597: from mtl_serial_numbers msn, mtl_item_locations_kfv milk
1598: where msn.current_organization_id = p_organization_id
1599: and msn.inventory_item_id = p_inventory_item_id
1600: --and msn.current_status in (3, 5)
1601: AND msn.current_status in (3, 5, 7)

Line 1624: from mtl_serial_numbers

1620: BEGIN
1621:
1622: OPEN x_serialLOV for
1623: select serial_number, current_subinventory_code, current_locator_id, lot_number,'', current_status, ''
1624: from mtl_serial_numbers
1625: where current_organization_id = p_organization_id
1626: and inventory_item_id = p_inventory_item_id
1627: AND(
1628: (current_organization_id = p_organization_id AND current_status = 1)

Line 1666: from mtl_serial_numbers

1662: /* FP-J Lot/Serial Support Enhancements
1663: * Add current status of resides in receiving */
1664: OPEN x_serialLOV for
1665: select serial_number, current_subinventory_code, current_locator_id, lot_number
1666: from mtl_serial_numbers
1667: where current_organization_id = p_organization_id
1668: and inventory_item_id = p_inventory_item_id
1669: --and current_status in (3, 5)
1670: AND current_status in (3, 5, 7)

Line 1695: FROM mtl_serial_numbers

1691: IS
1692: BEGIN
1693: OPEN x_serial_number FOR
1694: SELECT serial_number, current_subinventory_code, current_locator_id, lot_number, 'A', 'A', 'A'
1695: FROM mtl_serial_numbers
1696: WHERE inventory_item_id = TO_NUMBER(p_item_id)
1697: AND (group_mark_id is null OR group_mark_id = -1)
1698: AND current_organization_id = p_organization_id
1699: --AND ( (current_organization_id = p_organization_id AND current_status = 1)

Line 1719: from mtl_serial_numbers ms

1715: p_lot_number IN VARCHAR2) IS
1716: BEGIN
1717: open x_serial_numbers FOR
1718: select ms.serial_number, ms.lpn_id
1719: from mtl_serial_numbers ms
1720: where ms.inventory_item_id = p_inventory_item_id
1721: and ms.current_organization_id = p_organization_id
1722: and nvl(ms.revision, '$@#$%') =
1723: decode(p_revision, NULL, nvl(ms.revision, '$@#$%'), p_revision)

Line 1764: FROM mtl_serial_numbers_temp msnt,

1760: THEN
1761: /* PACKING CONTEXT */
1762: OPEN x_serial_numbers FOR
1763: SELECT msnt.fm_serial_number, mmtt.transfer_lpn_id, mtlt.lot_number
1764: FROM mtl_serial_numbers_temp msnt,
1765: mtl_material_transactions_temp mmtt,
1766: mtl_transaction_lots_temp mtlt
1767: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1768: and nvl(mtlt.serial_transaction_temp_id,mmtt.transaction_temp_id) = msnt.transaction_temp_id

Line 1780: FROM mtl_serial_numbers ms

1776: * Add current status of resides in receiving */
1777: /* All other Contexts */
1778: OPEN x_serial_numbers FOR
1779: SELECT ms.serial_number, ms.lpn_id
1780: FROM mtl_serial_numbers ms
1781: WHERE ms.inventory_item_id = p_inventory_item_id
1782: AND ms.current_organization_id = p_organization_id
1783: AND nvl(ms.revision, '$@#$%') = decode(p_revision, NULL, nvl(ms.revision, '$@#$%'), p_revision)
1784: AND nvl(ms.lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(ms.lot_number, '$@#$%'), p_lot_number)

Line 2450: FROM MTL_SERIAL_NUMBERS msn,

2446: 1,
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

Line 2536: FROM MTL_SERIAL_NUMBERS msn,

2532: -- INVCONV start
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,

Line 2602: FROM mtl_serial_numbers

2598: p_restrict_unit_numbers IN VARCHAR2) IS
2599: BEGIN
2600: OPEN x_unit_numbers FOR
2601: SELECT distinct end_item_unit_number
2602: FROM mtl_serial_numbers
2603: WHERE inventory_item_id = p_inventory_item_id
2604: AND current_organization_id = p_organization_id
2605: AND end_item_unit_number IS NOT NULL
2606: AND end_item_unit_number like (p_restrict_unit_numbers)

Line 2630: from mtl_serial_numbers ms

2626: p_serial_number IN VARCHAR2 := NULL) IS
2627: BEGIN
2628: open x_serial_numbers FOR
2629: select ms.serial_number, ms.lpn_id
2630: from mtl_serial_numbers ms
2631: where ms.inventory_item_id = p_inventory_item_id
2632: and ms.current_organization_id = p_organization_id
2633: and nvl(ms.revision, '$@#$%') =
2634: decode(p_revision, NULL, nvl(ms.revision, '$@#$%'), p_revision)

Line 2688: FROM MTL_SERIAL_NUMBERS msn,

2684: msik.serial_number_control_code,
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

Line 2809: FROM mtl_serial_numbers msn,

2805: msik.lot_control_code lot_control_code,
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,