DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 609: mtl_secondary_inventories msi,

605: mmt.cost_group_id,
606: (-1*mmt.primary_quantity) quantity
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 */

Line 790: mtl_secondary_inventories msi,

786: FROM mtl_material_transactions mmt,
787: oe_order_lines_all ool,
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