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.CST_REVENUECOGSMATCH_PVT dependencies on MTL_PARAMETERS

Line 659: mtl_parameters mp,

655: mmt.transaction_date,
656: mmt.cost_group_id,
657: (-1*mmt.primary_quantity) quantity
658: FROM mtl_material_transactions mmt,
659: mtl_parameters mp,
660: mtl_secondary_inventories msi,
661: mtl_system_items_b item
662: ,cst_acct_info_v caiv --BUG#7463298
663: WHERE mmt.transaction_action_id in (1,7)

Line 696: mtl_parameters mp,

692: mmt.transaction_date,
693: mmt.cost_group_id,
694: (-1*mmt.primary_quantity) quantity
695: FROM mtl_material_transactions mmt,
696: mtl_parameters mp,
697: mtl_secondary_inventories msi,
698: mtl_system_items_b item
699: ,cst_acct_info_v caiv --BUG#7463298
700: WHERE mmt.transaction_action_id in (1,7)

Line 883: ,mtl_parameters mp --BUG#9306124

879: cst_revenue_cogs_match_lines crcml,
880: cst_cogs_events cce,
881: mtl_system_items_b item
882: ,cst_acct_info_v caiv --BUG#7463298
883: ,mtl_parameters mp --BUG#9306124
884: WHERE mmt.transaction_source_type_id = 12
885: AND mmt.transaction_action_id in (26,27) -- UT: see if this forces index use, otherwise take it out since repeated below
886: AND mmt.costed_flag = 'N'
887: AND mmt.cogs_recognition_percent IS NULL

Line 951: ,mtl_parameters mp --BUG#9306124

947: cst_revenue_cogs_match_lines crcml,
948: cst_cogs_events cce,
949: mtl_system_items_b item
950: ,cst_acct_info_v caiv --BUG#7463298
951: ,mtl_parameters mp --BUG#9306124
952: WHERE mmt.transaction_source_type_id = 12
953: AND mmt.transaction_action_id in (26,27) -- UT: see if this forces index use, otherwise take it out since repeated below
954: AND mmt.opm_costed_flag IS NOT NULL
955: AND mmt.cogs_recognition_percent IS NULL

Line 1280: mtl_parameters mp,

1276: nvl(mp.process_enabled_flag,'N'),
1277: oap.acct_period_id -- acct period ID, I should store this in CCE so I don't keep having to go back to OAP
1278: FROM cst_cogs_events cce,
1279: cst_revenue_cogs_match_lines crcml,
1280: mtl_parameters mp,
1281: org_acct_periods oap,
1282: cst_acct_info_v caiv,
1283: mtl_system_items msi
1284: WHERE cce.cogs_om_line_id = l_cogs_om_line_id_tbl(i)

Line 1593: mtl_parameters mp,

1589: ,MAX(crrl.rowid) l_rowid
1590: FROM cst_revenue_cogs_match_lines crcml,
1591: cst_revenue_recognition_lines crrl,
1592: cst_cogs_events cce,
1593: mtl_parameters mp,
1594: gl_period_statuses gps,
1595: cst_lists_temp clt,
1596: mtl_system_items msi
1597: --{BUG#6809034

Line 3183: mtl_parameters mp,

3179: nvl(mp.process_enabled_flag,'N'),
3180: oap.acct_period_id
3181: FROM cst_cogs_events cce,
3182: cst_revenue_cogs_match_lines crcml,
3183: mtl_parameters mp,
3184: org_acct_periods oap,
3185: cst_acct_info_v caiv,
3186: mtl_system_items msi
3187: WHERE cce.cogs_om_line_id = p_cogs_om_line_id

Line 4221: mtl_parameters mp,

4217: sob.currency_code,
4218: NVL(mmt.transaction_source_id, -1)
4219: FROM cst_cogs_events cce,
4220: cst_revenue_cogs_match_lines crcml,
4221: mtl_parameters mp,
4222: gl_sets_of_books sob,
4223: mtl_material_transactions mmt -- joining here to use the index on costed_flag
4224: WHERE
4225: cce.mmt_transaction_id = mmt.transaction_id

Line 4556: mtl_parameters mp,

4552: l_event_date_tbl(i),
4553: l_le_date_tbl(i),
4554: l_mmt_txn_id_tbl(i)
4555: FROM
4556: mtl_parameters mp,
4557: pjm_org_parameters pop,
4558: mtl_material_transactions mmt
4559: WHERE mmt.transaction_id = l_mmt_txn_id_tbl(i) --bug#14180892
4560: AND mp.organization_id = mmt.organization_id