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.OPI_DBI_INV_CCA_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 1092: mtl_secondary_inventories subs,

1088: mtl_cycle_count_headers mcch,
1089: mtl_cycle_count_items mcci,
1090: mtl_cycle_count_classes mccc,
1091: mtl_system_items_b msi,
1092: mtl_secondary_inventories subs,
1093: (SELECT /*+ no_merge
1094: parallel(mmt) parallel(mta) parallel(log)
1095: use_hash(mmt mta log)*/
1096: mmt.organization_id,

Line 1388: mtl_secondary_inventories subs,

1384: mtl_cycle_count_headers mcch,
1385: mtl_cycle_count_items mcci,
1386: mtl_cycle_count_classes mccc,
1387: mtl_system_items_b msi,
1388: mtl_secondary_inventories subs,
1389: -- below select is grouped at transaction_id, quantity level so that
1390: -- quantity is summed correctly and then it can be joined with
1391: -- mcce and other tables outside.
1392: (SELECT mmt.organization_id,

Line 1657: mtl_secondary_inventories subs,

1653: FROM mtl_cycle_count_entries mcce,
1654: mtl_cycle_count_items mcci,
1655: mtl_cycle_count_classes mccc,
1656: mtl_system_items_b msi,
1657: mtl_secondary_inventories subs,
1658: mtl_parameters mp
1659: -- exact matches are approved at the time entry is completed
1660: -- hence it is not possible that status of a cycle count entry
1661: -- changes once the load is collected for that date range.

Line 2889: mtl_secondary_inventories subs,

2885: mtl_cycle_count_headers mcch,
2886: mtl_cycle_count_items mcci,
2887: mtl_cycle_count_classes mccc,
2888: mtl_system_items_b msi,
2889: mtl_secondary_inventories subs,
2890: (SELECT
2891: mmt.organization_id,
2892: mmt.inventory_item_id,
2893: mmt.transaction_date,

Line 3173: mtl_secondary_inventories subs,

3169: mtl_cycle_count_headers mcch,
3170: mtl_cycle_count_items mcci,
3171: mtl_cycle_count_classes mccc,
3172: mtl_system_items_b msi,
3173: mtl_secondary_inventories subs,
3174: -- as MMT to GTV is one to many relation grouping is done
3175: -- by transaction_id and primary_quantity level.
3176: (SELECT mmt.organization_id,
3177: mmt.transaction_id,

Line 3421: mtl_secondary_inventories subs,

3417: FROM mtl_cycle_count_entries mcce,
3418: mtl_cycle_count_items mcci,
3419: mtl_cycle_count_classes mccc,
3420: mtl_system_items_b msi,
3421: mtl_secondary_inventories subs,
3422: mtl_parameters mp
3423: WHERE mcce.last_update_date >= l_from_bound_date
3424: AND mcce.last_update_date < l_to_bound_date
3425: AND mcce.organization_id = mp.organization_id