DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 610: mtl_system_items_b item

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 */
614: AND NVL(mmt.parent_transaction_id, -1) = DECODE(mmt.transaction_action_id,1,-1,mmt.parent_transaction_id)

Line 791: mtl_system_items_b item

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
795: AND (mmt.costed_flag = 'N' OR mmt.opm_costed_flag = 'N')