APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 661: mtl_system_items_b item

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)
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)

Line 698: mtl_system_items_b item

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)
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)

Line 881: mtl_system_items_b item

877: FROM mtl_material_transactions mmt,
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

Line 949: mtl_system_items_b item

945: FROM mtl_material_transactions mmt,
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