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 CST_ACCT_INFO_V

Line 662: ,cst_acct_info_v caiv --BUG#7463298

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)
664: /* do not pick up physical SO issue in a drop shipment flow */
665: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)
666: AND mmt.transaction_type_id IN (33, 30)

Line 699: ,cst_acct_info_v caiv --BUG#7463298

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)
701: /* do not pick up physical SO issue in a drop shipment flow */
702: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)
703: AND mmt.transaction_type_id IN (33, 30)

Line 882: ,cst_acct_info_v caiv --BUG#7463298

878: oe_order_lines_all ool,
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'

Line 950: ,cst_acct_info_v caiv --BUG#7463298

946: oe_order_lines_all ool,
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

Line 1282: cst_acct_info_v caiv,

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)
1285: AND TRUNC(cce.event_date) > l_txn_date_tbl(i)
1286: AND cce.event_type IN (3,4)

Line 1773: cst_acct_info_v caiv

1769: DISTINCT caiv.organization_id,
1770: caiv.legal_entity
1771: FROM cst_revenue_recognition_lines crrl,
1772: cst_revenue_cogs_match_lines crcml,
1773: cst_acct_info_v caiv
1774: WHERE crrl.potentially_unmatched_flag='Y'
1775: AND crcml.revenue_om_line_id =crrl.revenue_om_line_id
1776: AND DECODE(p_neg_req_id,NULL,NVL(crrl.request_id,-99),p_neg_req_id) = NVL(crrl.request_id,-99)
1777: -- BUG#7387575

Line 3185: cst_acct_info_v caiv,

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
3188: AND cce.event_date > p_transaction_date
3189: AND cce.event_id = cce.parent_event_id