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.WSMPINVL dependencies on MTL_SYSTEM_ITEMS

Line 1210: from mtl_system_items_kfv

1206: l_serial_ctrl := 0;
1207:
1208: select nvl(serial_number_control_code,2)
1209: into l_serial_ctrl
1210: from mtl_system_items_kfv
1211: WHERE organization_id = crec.organization_id
1212: AND inventory_item_id = crec.inventory_item_id;
1213:
1214: IF l_serial_ctrl <> 1 then

Line 1671: from mtl_system_items_kfv

1667: l_serial_ctrl := 0;
1668:
1669: select nvl(serial_number_control_code,2)
1670: into l_serial_ctrl
1671: from mtl_system_items_kfv
1672: WHERE organization_id = crec.organization_id
1673: AND inventory_item_id = crec.inventory_item_id;
1674:
1675: IF l_serial_ctrl <> 1 then

Line 2065: FROM mtl_system_items

2061:
2062: BEGIN
2063: SELECT 1
2064: into x_dummy
2065: FROM mtl_system_items
2066: WHERE inventory_item_id = crec.inventory_item_id
2067: and organization_id = crec.organization_id
2068: and mtl_transactions_enabled_flag = 'Y'
2069: and lot_control_code=2

Line 2087: FROM mtl_System_items

2083:
2084: BEGIN
2085: SELECT 1
2086: into x_dummy
2087: FROM mtl_System_items
2088: WHERE inventory_item_id = crec.inventory_item_id
2089: and organization_id = crec.organization_id
2090: and ((crec.revision is not null
2091: and revision_qty_control_code <> 1) or

Line 2194: ** MTL_SYSTEM_ITEMS MSI

2190: /*
2191: ** SELECT 1 into x_dummy FROM dual WHERE exists(
2192: ** SELECT 1
2193: ** FROM MTL_SUBINVENTORIES_VAL_V MSVV,
2194: ** MTL_SYSTEM_ITEMS MSI
2195: ** WHERE MSVV.ORGANIZATION_ID = crec.ORGANIZATION_ID
2196: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2197: ** crec.SUBINVENTORY_CODE
2198: ** AND crec.inventory_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 2205: ** MTL_SYSTEM_ITEMS MSI

2201: ** AND MSI.INVENTORY_ASSET_FLAG = 'N'
2202: ** UNION
2203: ** SELECT 1
2204: ** FROM MTL_SUB_AST_TRK_VAL_V MSVV,
2205: ** MTL_SYSTEM_ITEMS MSI
2206: ** WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2207: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2208: ** crec.subinventory_code
2209: ** AND crec.inventory_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 2216: ** MTL_SYSTEM_ITEMS MSI

2212: ** AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2213: ** UNION
2214: ** SELECT 1
2215: ** FROM MTL_ITEM_SUB_AST_TRK_VAL_V MSVV,
2216: ** MTL_SYSTEM_ITEMS MSI
2217: ** WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2218: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2219: ** crec.subinventory_code
2220: ** AND MSVV.inventory_item_id = crec.inventory_item_id

Line 2228: ** MTL_SYSTEM_ITEMS MSI

2224: ** AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2225: ** UNION
2226: ** SELECT 1
2227: ** FROM MTL_ITEM_SUB_VAL_V MSVV,
2228: ** MTL_SYSTEM_ITEMS MSI
2229: ** WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2230: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2231: ** crec.subinventory_code
2232: ** AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1

Line 2260: MTL_SYSTEM_ITEMS MSI

2256:
2257:
2258: SELECT 1 into x_dummy
2259: FROM MTL_SUBINVENTORIES_VAL_V MSVV,
2260: MTL_SYSTEM_ITEMS MSI
2261: WHERE MSVV.ORGANIZATION_ID = crec.ORGANIZATION_ID
2262: AND MSVV.SECONDARY_INVENTORY_NAME =
2263: crec.SUBINVENTORY_CODE
2264: AND crec.inventory_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 2271: MTL_SYSTEM_ITEMS MSI

2267: AND (MSI.INVENTORY_ASSET_FLAG = 'N' OR x_exp_ast_profile = 1) --bugfix 1857638
2268: UNION ALL
2269: SELECT 1
2270: FROM MTL_SUB_AST_TRK_VAL_V MSVV,
2271: MTL_SYSTEM_ITEMS MSI
2272: WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2273: AND MSVV.SECONDARY_INVENTORY_NAME =
2274: crec.subinventory_code
2275: AND crec.inventory_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 2282: MTL_SYSTEM_ITEMS MSI

2278: AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2279: UNION ALL
2280: SELECT 1
2281: FROM MTL_ITEM_SUB_AST_TRK_VAL_V MSVV,
2282: MTL_SYSTEM_ITEMS MSI
2283: WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2284: AND MSVV.SECONDARY_INVENTORY_NAME =
2285: crec.subinventory_code
2286: AND MSVV.inventory_item_id = crec.inventory_item_id

Line 2294: MTL_SYSTEM_ITEMS MSI

2290: AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2291: UNION ALL
2292: SELECT 1
2293: FROM MTL_ITEM_SUB_VAL_V MSVV,
2294: MTL_SYSTEM_ITEMS MSI
2295: WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2296: AND MSVV.SECONDARY_INVENTORY_NAME =
2297: crec.subinventory_code
2298: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1

Line 2334: FROM mtl_system_items MS,

2330: into x_sub_loc_control,
2331: x_org_loc_control,
2332: x_restrict_locators_code,
2333: x_item_loc_control
2334: FROM mtl_system_items MS,
2335: mtl_secondary_inventories MSUB,
2336: mtl_parameters MP
2337: WHERE MP.organization_id = crec.organization_id
2338: AND MS.organization_id = crec.organization_id

Line 4333: MTL_SYSTEM_ITEMS msi

4329:
4330: SELECT msi.primary_uom_code
4331: INTO X_UOM
4332: FROM
4333: MTL_SYSTEM_ITEMS msi
4334: WHERE msi.INVENTORY_ITEM_ID = X_Inventory_Item_Id
4335: AND msi.ORGANIZATION_ID = X_Organization_Id;
4336:
4337: showProgress(

Line 4559: FROM mtl_system_items msi

4555:
4556: l_stmt_num :=20;
4557: SELECT msi.primary_uom_code
4558: INTO x_uom
4559: FROM mtl_system_items msi
4560: WHERE msi.INVENTORY_ITEM_ID = X_Inventory_Item_Id
4561: AND msi.ORGANIZATION_ID = X_Organization_Id;
4562:
4563: l_stmt_num :=30;