APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_ACCT_INFO_V

Line 611: ,cst_acct_info_v caiv --BUG#7463298

607: FROM mtl_material_transactions mmt,
608: mtl_parameters mp,
609: mtl_secondary_inventories msi,
610: mtl_system_items_b item
611: ,cst_acct_info_v caiv --BUG#7463298
612: WHERE mmt.transaction_action_id in (1,7)
613: /* do not pick up physical SO issue in a drop shipment flow */
614: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)
615: AND mmt.transaction_type_id IN (33, 30)

Line 792: ,cst_acct_info_v caiv --BUG#7463298

788: cst_revenue_cogs_match_lines crcml,
789: cst_cogs_events cce,
790: mtl_secondary_inventories msi,
791: mtl_system_items_b item
792: ,cst_acct_info_v caiv --BUG#7463298
793: WHERE mmt.transaction_source_type_id = 12
794: AND mmt.transaction_action_id in (26,27) -- UT: see if this forces index use, otherwise take it out since repeated below
795: AND (mmt.costed_flag = 'N' OR mmt.opm_costed_flag = 'N')
796: AND mmt.cogs_recognition_percent IS NULL

Line 1104: cst_acct_info_v caiv,

1100: FROM cst_cogs_events cce,
1101: cst_revenue_cogs_match_lines crcml,
1102: mtl_parameters mp,
1103: org_acct_periods oap,
1104: cst_acct_info_v caiv,
1105: mtl_system_items msi
1106: WHERE cce.cogs_om_line_id = l_cogs_om_line_id_tbl(i)
1107: AND cce.event_date > l_txn_date_tbl(i)
1108: AND cce.event_id = cce.parent_event_id

Line 1568: cst_acct_info_v caiv

1564: DISTINCT caiv.organization_id,
1565: caiv.legal_entity
1566: FROM cst_revenue_recognition_lines crrl,
1567: cst_revenue_cogs_match_lines crcml,
1568: cst_acct_info_v caiv
1569: WHERE crrl.potentially_unmatched_flag='Y'
1570: AND DECODE(p_neg_req_id,NULL,NVL(crrl.request_id,-99),p_neg_req_id) = NVL(crrl.request_id,-99)
1571: -- BUG#7387575
1572: AND crcml.revenue_om_line_id = crrl.revenue_om_line_id

Line 1595: cst_acct_info_v caiv

1591: DISTINCT caiv.organization_id,
1592: caiv.legal_entity
1593: FROM cst_revenue_recognition_lines crrl,
1594: cst_revenue_cogs_match_lines crcml,
1595: cst_acct_info_v caiv
1596: WHERE crrl.potentially_unmatched_flag='Y'
1597: AND crcml.revenue_om_line_id =crrl.revenue_om_line_id
1598: AND DECODE(p_neg_req_id,NULL,NVL(crrl.request_id,-99),p_neg_req_id) = NVL(crrl.request_id,-99)
1599: -- BUG#7387575

Line 3161: cst_acct_info_v caiv,

3157: FROM cst_cogs_events cce,
3158: cst_revenue_cogs_match_lines crcml,
3159: mtl_parameters mp,
3160: org_acct_periods oap,
3161: cst_acct_info_v caiv,
3162: mtl_system_items msi
3163: WHERE cce.cogs_om_line_id = p_cogs_om_line_id
3164: AND cce.event_date > p_transaction_date
3165: AND cce.event_id = cce.parent_event_id