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_MATERIAL_STATUSES_VL

Line 5: p_status_id mtl_material_statuses_vl.status_id%TYPE

1: PACKAGE BODY inv_ITEM_INQ AS
2: /* $Header: INVIQWMB.pls 120.15 2008/02/13 12:00:39 abaid noship $ */
3:
4: FUNCTION get_status_code (
5: p_status_id mtl_material_statuses_vl.status_id%TYPE
6: ) RETURN VARCHAR2 IS
7: x_status_code mtl_material_statuses_vl.status_code%TYPE;
8: BEGIN
9: IF p_status_id IS NULL THEN

Line 7: x_status_code mtl_material_statuses_vl.status_code%TYPE;

3:
4: FUNCTION get_status_code (
5: p_status_id mtl_material_statuses_vl.status_id%TYPE
6: ) RETURN VARCHAR2 IS
7: x_status_code mtl_material_statuses_vl.status_code%TYPE;
8: BEGIN
9: IF p_status_id IS NULL THEN
10: x_status_code := '';
11: ELSE

Line 14: FROM mtl_material_statuses_vl

10: x_status_code := '';
11: ELSE
12: SELECT status_code
13: INTO x_status_code
14: FROM mtl_material_statuses_vl
15: WHERE status_id = p_status_id;
16: END IF;
17: return x_status_code;
18: END get_status_code;

Line 193: mtl_material_statuses_vl mms1,

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
197: WHERE moq.organization_id = msik.organization_id

Line 194: mtl_material_statuses_vl mms2,

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
197: WHERE moq.organization_id = msik.organization_id
198: AND moq.inventory_item_id = msik.inventory_item_id

Line 195: mtl_material_statuses_vl mms3,

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
197: WHERE moq.organization_id = msik.organization_id
198: AND moq.inventory_item_id = msik.inventory_item_id
199: AND moq.organization_id = msub.organization_id

Line 346: MTL_MATERIAL_STATUSES_vl mms1,

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,
350: CST_COST_GROUPS csg

Line 347: MTL_MATERIAL_STATUSES_vl mms2,

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,
350: CST_COST_GROUPS csg
351: WHERE milk.organization_id(+) = msn.current_organization_id

Line 348: MTL_MATERIAL_STATUSES_vl mms3,

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,
350: CST_COST_GROUPS csg
351: WHERE milk.organization_id(+) = msn.current_organization_id
352: AND milk.subinventory_code(+) = msn.current_subinventory_code

Line 349: MTL_MATERIAL_STATUSES_vl mms4,

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,
350: CST_COST_GROUPS csg
351: WHERE milk.organization_id(+) = msn.current_organization_id
352: AND milk.subinventory_code(+) = msn.current_subinventory_code
353: AND milk.inventory_location_id(+) = msn.current_locator_id

Line 1409: FROM mtl_material_statuses_vl mmst,

1405: /* PACKING CONTEXT */
1406: OPEN x_lot_attributes FOR
1407: SELECT mmst.status_code, mmst.status_id,
1408: msik.shelf_life_code, msik.lot_status_enabled, mtlt.lot_expiration_date
1409: FROM mtl_material_statuses_vl mmst,
1410: mtl_system_items_kfv msik,
1411: mtl_transaction_lots_temp mtlt,
1412: mtl_material_transactions_temp mmtt
1413: WHERE mtlt.lot_number = p_lot_number

Line 1424: FROM mtl_material_statuses_vl mmst,

1420: /* All other Contexts */
1421: OPEN x_lot_attributes FOR
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

Line 1458: FROM mtl_material_statuses_vl mmst,

1454: THEN
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

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 2247: mtl_material_statuses_vl mms1,

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
2251: WHERE moq.organization_id = msik.organization_id

Line 2248: mtl_material_statuses_vl mms2,

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
2251: WHERE moq.organization_id = msik.organization_id
2252: AND moq.inventory_item_id = msik.inventory_item_id

Line 2249: mtl_material_statuses_vl mms3,

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
2251: WHERE moq.organization_id = msik.organization_id
2252: AND moq.inventory_item_id = msik.inventory_item_id
2253: AND moq.organization_id = msub.organization_id

Line 2445: MTL_MATERIAL_STATUSES_vl mms1,

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,
2449: CST_COST_GROUPS csg

Line 2446: MTL_MATERIAL_STATUSES_vl mms2,

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,
2449: CST_COST_GROUPS csg
2450: WHERE milk.organization_id(+) = msn.current_organization_id

Line 2447: MTL_MATERIAL_STATUSES_vl mms3,

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,
2449: CST_COST_GROUPS csg
2450: WHERE milk.organization_id(+) = msn.current_organization_id
2451: AND milk.subinventory_code(+) = msn.current_subinventory_code

Line 2448: MTL_MATERIAL_STATUSES_vl mms4,

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,
2449: CST_COST_GROUPS csg
2450: WHERE milk.organization_id(+) = msn.current_organization_id
2451: AND milk.subinventory_code(+) = msn.current_subinventory_code
2452: AND milk.inventory_location_id(+) = msn.current_locator_id

Line 2718: mtl_material_statuses_vl mms1,

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
2722: WHERE msn.current_organization_id = msik.organization_id

Line 2719: mtl_material_statuses_vl mms2,

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
2722: WHERE msn.current_organization_id = msik.organization_id
2723: AND msn.current_organization_id = p_Organization_Id

Line 2720: mtl_material_statuses_vl mms3,

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
2722: WHERE msn.current_organization_id = msik.organization_id
2723: AND msn.current_organization_id = p_Organization_Id
2724: AND msn.inventory_item_id = p_inventory_item_id

Line 2876: mtl_material_statuses_vl mms1,

2872: FROM mtl_onhand_quantities_detail moq,
2873: mtl_system_items_vl msik, /* Bug 5581528 */
2874: mtl_item_locations milk,
2875: mtl_secondary_inventories msub,
2876: mtl_material_statuses_vl mms1,
2877: mtl_material_statuses_vl mms2
2878: WHERE moq.organization_id = msik.organization_id
2879: AND moq.inventory_item_id = msik.inventory_item_id
2880: AND moq.organization_id = msub.organization_id

Line 2877: mtl_material_statuses_vl mms2

2873: mtl_system_items_vl msik, /* Bug 5581528 */
2874: mtl_item_locations milk,
2875: mtl_secondary_inventories msub,
2876: mtl_material_statuses_vl mms1,
2877: mtl_material_statuses_vl mms2
2878: WHERE moq.organization_id = msik.organization_id
2879: AND moq.inventory_item_id = msik.inventory_item_id
2880: AND moq.organization_id = msub.organization_id
2881: AND moq.subinventory_code = msub.secondary_inventory_name(+)