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

Line 785: mtl_system_items MSI,

781: , 702
782: , l_program_id
783: , SYSDATE
784: FROM cst_pac_item_costs CPIC,
785: mtl_system_items MSI,
786: (SELECT inventory_item_id, based_on_rollup_flag
787: FROM cst_item_costs_interface
788: WHERE group_id = l_grp_id) BORF, -- based_on_rollup_flag backed up from destination cost type
789: (SELECT cic.inventory_item_id, cic.based_on_rollup_flag

Line 900: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items

896: , l_program_id
897: , SYSDATE
898: FROM cst_pac_item_costs CPIC,
899: cst_pac_item_cost_details CPICD,
900: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
901: WHERE CPIC.pac_period_id = p_period_id
902: AND CPIC.cost_group_id = p_from_cost_group_id
903: AND CPIC.cost_layer_id = CPICD.cost_layer_id
904: AND MSI.inventory_item_id = CPIC.inventory_item_id

Line 1063: mtl_system_items MSI,

1059: , 702
1060: , l_program_id
1061: , SYSDATE
1062: FROM cst_pac_item_costs CPIC,
1063: mtl_system_items MSI,
1064: (SELECT cic.inventory_item_id, based_on_rollup_flag
1065: FROM cst_cost_types cct, cst_item_costs cic
1066: WHERE cic.organization_id = p_to_org_id
1067: AND cct.cost_type_id = p_to_cost_type_id

Line 1173: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items

1169: , l_program_id
1170: , SYSDATE
1171: FROM cst_pac_item_costs CPIC,
1172: cst_pac_item_cost_details CPICD,
1173: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
1174: WHERE CPIC.pac_period_id = p_period_id
1175: AND CPIC.cost_group_id = p_from_cost_group_id
1176: AND CPIC.cost_layer_id = CPICD.cost_layer_id
1177: AND MSI.inventory_item_id = CPIC.inventory_item_id

Line 1466: mtl_system_items MSI,

1462: , 702
1463: , l_program_id
1464: , SYSDATE
1465: FROM cst_pac_item_costs CPIC,
1466: mtl_system_items MSI,
1467: (SELECT inventory_item_id, based_on_rollup_flag
1468: FROM cst_item_costs_interface
1469: WHERE group_id = l_grp_id) BORF, -- based_on_rollup_flag backed up from destination cost type
1470: (SELECT cic.inventory_item_id, cic.based_on_rollup_flag

Line 1582: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items

1578: , l_program_id
1579: , SYSDATE
1580: FROM cst_pac_item_costs CPIC,
1581: cst_pac_item_cost_details CPICD,
1582: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
1583: WHERE CPIC.pac_period_id = p_period_id
1584: AND CPIC.cost_group_id = p_from_cost_group_id
1585: AND CPIC.cost_layer_id = CPICD.cost_layer_id
1586: AND MSI.inventory_item_id = CPIC.inventory_item_id