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 2171: mtl_system_items_b msib,

2167: sysdate
2168: from csp_region_items_v cri,
2169: mtl_related_items mri,
2170: mtl_parameters mp,
2171: mtl_system_items_b msib,
2172: mtl_item_sub_inventories misi,
2173: mtl_secondary_inventories msi
2174: where cri.level_id like l_level_id || '%'
2175: and mp.organization_id = cri.organization_id

Line 2221: mtl_system_items_b msib,

2217: fnd_global.user_id,
2218: fnd_global.user_id,
2219: sysdate
2220: from mtl_parameters mp,
2221: mtl_system_items_b msib,
2222: mtl_item_sub_inventories misi,
2223: mtl_secondary_inventories msi,
2224: csp_supply_chain csc
2225: where mp.organization_id = csc.source_organization_id

Line 2399: mtl_system_items_b msib,

2395: fnd_global.user_id,
2396: fnd_global.user_id,
2397: sysdate
2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,
2400: mtl_item_sub_inventories misi,
2401: mtl_secondary_inventories msi,
2402: mtl_material_transactions mmt,
2403: mtl_interorg_ship_methods mism

Line 2465: mtl_system_items_b msib,

2461: fnd_global.user_id,
2462: fnd_global.user_id,
2463: sysdate
2464: from mtl_parameters mp,
2465: mtl_system_items_b msib,
2466: mtl_item_sub_inventories misi,
2467: mtl_secondary_inventories msi,
2468: csp_supply_chain csc,
2469: mtl_interorg_ship_methods mism

Line 2820: MTL_SYSTEM_ITEMS_B msib,

2816: cuh.recommended_min_quantity,
2817: cuh.recommended_max_quantity
2818: from CSP_USAGE_HEADERS cuh,
2819: CSP_PLANNING_PARAMETERS cpp,
2820: MTL_SYSTEM_ITEMS_B msib,
2821: CSP_BUSINESS_RULES_B cbrb
2822: Where msib.INVENTORY_ITEM_ID = cuh.INVENTORY_ITEM_ID
2823: And msib.ORGANIZATION_ID = cuh.ORGANIZATION_ID
2824: And cuh.header_data_type = 4

Line 2966: UPDATE mtl_system_items_b mtl_items

2962:
2963: -- Update Item/Organization Min/Max values
2964: /* To fix R12 BUG 5548326 Modified the whole Apply_Business_Rules procedure to same as 115.10 version */
2965: FOR usg_hdr_rec in c_usg_hdr_item LOOP
2966: UPDATE mtl_system_items_b mtl_items
2967: Set min_minmax_quantity = usg_hdr_rec.recommended_min_quantity,
2968: max_minmax_quantity = usg_hdr_rec.recommended_max_quantity,
2969: mtl_items.inventory_planning_code = 2
2970: WHERE INVENTORY_ITEM_ID = usg_hdr_rec.INVENTORY_ITEM_ID