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_UOM_API_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 1983: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

1979: FROM MTL_UNITS_OF_MEASURE
1980: WHERE uom_code = v_uom;
1981:
1982: X_MATL_LINE GME_MATERIAL_DETAILS%ROWTYPE;
1983: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1984: l_secondary_def_ind mtl_system_items_b.secondary_default_ind%TYPE;
1985: l_lot_divisible_flag mtl_system_items_b.lot_divisible_flag%TYPE;
1986: L_QTY_TBL MTL_LOT_UOM_CONV_PUB.QUANTITY_UPDATE_REC_TYPE;
1987: X_BATCH_ROW GME_BATCH_HEADER%ROWTYPE;

Line 1984: l_secondary_def_ind mtl_system_items_b.secondary_default_ind%TYPE;

1980: WHERE uom_code = v_uom;
1981:
1982: X_MATL_LINE GME_MATERIAL_DETAILS%ROWTYPE;
1983: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1984: l_secondary_def_ind mtl_system_items_b.secondary_default_ind%TYPE;
1985: l_lot_divisible_flag mtl_system_items_b.lot_divisible_flag%TYPE;
1986: L_QTY_TBL MTL_LOT_UOM_CONV_PUB.QUANTITY_UPDATE_REC_TYPE;
1987: X_BATCH_ROW GME_BATCH_HEADER%ROWTYPE;
1988:

Line 1985: l_lot_divisible_flag mtl_system_items_b.lot_divisible_flag%TYPE;

1981:
1982: X_MATL_LINE GME_MATERIAL_DETAILS%ROWTYPE;
1983: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1984: l_secondary_def_ind mtl_system_items_b.secondary_default_ind%TYPE;
1985: l_lot_divisible_flag mtl_system_items_b.lot_divisible_flag%TYPE;
1986: L_QTY_TBL MTL_LOT_UOM_CONV_PUB.QUANTITY_UPDATE_REC_TYPE;
1987: X_BATCH_ROW GME_BATCH_HEADER%ROWTYPE;
1988:
1989: -- L_FROM_CLASS VARCHAR2(100);

Line 2298: FROM MTL_SYSTEM_ITEMS_B

2294:
2295: BEGIN
2296: SELECT 1
2297: INTO l_ITEM_EXISTS
2298: FROM MTL_SYSTEM_ITEMS_B
2299: WHERE inventory_item_id = p_item_id
2300: AND organization_id = p_org_id;
2301: EXCEPTION
2302: WHEN OTHERS THEN

Line 2327: FROM MTL_SYSTEM_ITEMS_B

2323: l_secondary_uom_code,
2324: l_secondary_def_ind,
2325: l_tracking_quantity_ind,
2326: l_lot_divisible_flag
2327: FROM MTL_SYSTEM_ITEMS_B
2328: WHERE inventory_item_id = p_item_id
2329: AND ORGANIZATION_ID = P_ORG_ID;
2330: EXCEPTION
2331: WHEN OTHERS THEN

Line 2416: FROM mtl_system_items_b

2412: BEGIN
2413:
2414: SELECT LOT_CONTROL_CODE , SHELF_LIFE_CODE
2415: INTO V_LOT_CONTROL_CODE , l_shelf_life_code
2416: FROM mtl_system_items_b
2417: WHERE INVENTORY_ITEM_ID = P_ITEM_ID
2418: AND ORGANIZATION_ID = P_ORG_ID;
2419:
2420: IF (L_DEBUG = 1) THEN