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.CSTPALPC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 157: FROM mtl_material_transactions mmt,

153: to_char(null) "TRANSACTION_TYPE",
154: (to_char(mtt.transaction_type_id)||'-'||to_char(mtt.transaction_action_id)||'-'||to_char(mtt.transaction_source_type_id)) "EVENT_TYPE", -- 4986702
155: 'INV' "TRANSACTION_TYPE_FLAG", -- 4986702
156: mmt.trx_source_line_id "TRX_SOURCE_LINE_ID"
157: FROM mtl_material_transactions mmt,
158: cst_cost_groups ccg,
159: cst_cost_group_assignments ccga,
160: cst_pac_periods cpp,
161: mtl_transaction_types mtt /* Removed the access to view to directly access the base tables Bug 4968702 */

Line 238: mtl_material_transactions mmt,

234: (to_char(mtt.transaction_type_id)||'-'||to_char(mtt.transaction_action_id)||'-'||to_char(mtt.transaction_source_type_id)) "EVENT_TYPE", -- Bug 4968702
235: 'INV' "TRANSACTION_TYPE_FLAG", -- Bug 4968702
236: mmt.trx_source_line_id "TRX_SOURCE_LINE_ID"
237: FROM
238: mtl_material_transactions mmt,
239: cst_cost_groups ccg,
240: cst_cost_group_assignments ccga ,
241: cst_pac_periods cpp,
242: mtl_material_transactions mtt -- Directly Using the base tables. Bug 4968702

Line 242: mtl_material_transactions mtt -- Directly Using the base tables. Bug 4968702

238: mtl_material_transactions mmt,
239: cst_cost_groups ccg,
240: cst_cost_group_assignments ccga ,
241: cst_pac_periods cpp,
242: mtl_material_transactions mtt -- Directly Using the base tables. Bug 4968702
243: WHERE
244: mmt.organization_id = ccga.organization_id AND
245: mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id) AND
246: nvl(mmt.owning_tp_type,2) = 2 AND