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.17 2011/12/10 11:59:53 ssrikaku ship $ */
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 1485: FROM mtl_material_statuses_vl mmst,

1481: /* PACKING CONTEXT */
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

Line 1500: FROM mtl_material_statuses_vl mmst,

1496: /* All other Contexts */
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

Line 1534: FROM mtl_material_statuses_vl mmst,

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

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

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

Line 2344: mtl_material_statuses_vl mms2,

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

Line 2345: mtl_material_statuses_vl mms3,

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
2347: WHERE moq.organization_id = msik.organization_id
2348: AND moq.inventory_item_id = msik.inventory_item_id
2349: AND moq.organization_id = msub.organization_id

Line 2541: MTL_MATERIAL_STATUSES_vl mms1,

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

Line 2542: MTL_MATERIAL_STATUSES_vl mms2,

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

Line 2543: MTL_MATERIAL_STATUSES_vl mms3,

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

Line 2544: MTL_MATERIAL_STATUSES_vl mms4,

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,
2545: CST_COST_GROUPS csg
2546: WHERE milk.organization_id(+) = msn.current_organization_id
2547: AND milk.subinventory_code(+) = msn.current_subinventory_code
2548: AND milk.inventory_location_id(+) = msn.current_locator_id

Line 2814: mtl_material_statuses_vl mms1,

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

Line 2815: mtl_material_statuses_vl mms2,

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

Line 2816: mtl_material_statuses_vl mms3,

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
2818: WHERE msn.current_organization_id = msik.organization_id
2819: AND msn.current_organization_id = p_Organization_Id
2820: AND msn.inventory_item_id = p_inventory_item_id

Line 2988: mtl_material_statuses_vl mms1,

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
2990: WHERE moq.organization_id = msik.organization_id
2991: AND moq.inventory_item_id = msik.inventory_item_id
2992: AND moq.organization_id = msub.organization_id

Line 2989: mtl_material_statuses_vl mms2

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
2990: WHERE moq.organization_id = msik.organization_id
2991: AND moq.inventory_item_id = msik.inventory_item_id
2992: AND moq.organization_id = msub.organization_id
2993: AND moq.subinventory_code = msub.secondary_inventory_name(+)