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

Line 490: MTL_SYSTEM_ITEMS msi,

486: sysdate,
487: fnd_global.user_id,
488: fnd_global.conc_login_id
489: From CSP_PLANNING_PARAMETERS cpp,
490: MTL_SYSTEM_ITEMS msi,
491: CST_ITEM_COSTS cic,
492: MTL_PARAMETERS mp
493: where cpp.node_type = 'ORGANIZATION_WH'
494: and mp.organization_id = cpp.organization_id

Line 570: mtl_system_items_b msib,

566: from csp_planning_parameters cpp,
567: csp_usage_headers cuh,
568: cst_item_costs cic,
569: mtl_parameters mp,
570: mtl_system_items_b msib,
571: mtl_item_sub_inventories misi,
572: mtl_secondary_inventories msi,
573: mtl_interorg_ship_methods mism1,
574: mtl_interorg_ship_methods mism2,

Line 2191: mtl_system_items_b msib,

2187: sysdate
2188: from csp_region_items_v cri,
2189: mtl_related_items mri,
2190: mtl_parameters mp,
2191: mtl_system_items_b msib,
2192: mtl_item_sub_inventories misi,
2193: mtl_secondary_inventories msi
2194: where cri.level_id like l_level_id || '%'
2195: and mp.organization_id = cri.organization_id

Line 2241: mtl_system_items_b msib,

2237: fnd_global.user_id,
2238: fnd_global.user_id,
2239: sysdate
2240: from mtl_parameters mp,
2241: mtl_system_items_b msib,
2242: mtl_item_sub_inventories misi,
2243: mtl_secondary_inventories msi,
2244: csp_supply_chain csc
2245: where mp.organization_id = csc.source_organization_id

Line 2419: mtl_system_items_b msib,

2415: fnd_global.user_id,
2416: fnd_global.user_id,
2417: sysdate
2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,
2420: mtl_item_sub_inventories misi,
2421: mtl_secondary_inventories msi,
2422: mtl_material_transactions mmt,
2423: mtl_interorg_ship_methods mism

Line 2485: mtl_system_items_b msib,

2481: fnd_global.user_id,
2482: fnd_global.user_id,
2483: sysdate
2484: from mtl_parameters mp,
2485: mtl_system_items_b msib,
2486: mtl_item_sub_inventories misi,
2487: mtl_secondary_inventories msi,
2488: csp_supply_chain csc,
2489: mtl_interorg_ship_methods mism

Line 2840: MTL_SYSTEM_ITEMS_B msib,

2836: cuh.recommended_min_quantity,
2837: cuh.recommended_max_quantity
2838: from CSP_USAGE_HEADERS cuh,
2839: CSP_PLANNING_PARAMETERS cpp,
2840: MTL_SYSTEM_ITEMS_B msib,
2841: CSP_BUSINESS_RULES_B cbrb
2842: Where msib.INVENTORY_ITEM_ID = cuh.INVENTORY_ITEM_ID
2843: And msib.ORGANIZATION_ID = cuh.ORGANIZATION_ID
2844: And cuh.header_data_type = 4

Line 2986: UPDATE mtl_system_items_b mtl_items

2982:
2983: -- Update Item/Organization Min/Max values
2984: /* To fix R12 BUG 5548326 Modified the whole Apply_Business_Rules procedure to same as 115.10 version */
2985: FOR usg_hdr_rec in c_usg_hdr_item LOOP
2986: UPDATE mtl_system_items_b mtl_items
2987: Set min_minmax_quantity = usg_hdr_rec.recommended_min_quantity,
2988: max_minmax_quantity = usg_hdr_rec.recommended_max_quantity,
2989: mtl_items.inventory_planning_code = 2
2990: WHERE INVENTORY_ITEM_ID = usg_hdr_rec.INVENTORY_ITEM_ID