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 MTL_SECONDARY_INVENTORIES

Line 660: mtl_secondary_inventories msi,

656: mmt.cost_group_id,
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 */

Line 697: mtl_secondary_inventories msi,

693: mmt.cost_group_id,
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 */

Line 894: FROM mtl_secondary_inventories msi

890: AND (
891: ( mmt.transaction_action_id = 27
892: AND EXISTS
893: (SELECT NULL
894: FROM mtl_secondary_inventories msi
895: WHERE mmt.subinventory_code = msi.SECONDARY_INVENTORY_NAME
896: AND mmt.organization_id = msi.organization_id
897: AND msi.asset_inventory = 1)
898: -- Physical RMA should not have a logical RMA as child transaction

Line 962: FROM mtl_secondary_inventories msi

958: AND (
959: ( mmt.transaction_action_id = 27
960: AND EXISTS
961: (SELECT NULL
962: FROM mtl_secondary_inventories msi
963: WHERE mmt.subinventory_code = msi.SECONDARY_INVENTORY_NAME
964: AND mmt.organization_id = msi.organization_id
965: AND msi.asset_inventory = 1)
966: -- Physical RMA should not have a logical RMA as child transaction