[Home] [Help]
1085: 0, C_EXACT_MATCH,
1086: C_NO_MATCH)
1087: FROM mtl_cycle_count_entries mcce,
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
1381: 0, C_EXACT_MATCH,
1382: C_NO_MATCH) exact_match
1383: FROM mtl_cycle_count_entries mcce,
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
1650: NULL,
1651: NULL,
1652: C_EXACT_MATCH
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
2882: 0, C_EXACT_MATCH,
2883: C_NO_MATCH)
2884: FROM mtl_cycle_count_entries mcce,
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
3166: 0, C_EXACT_MATCH,
3167: C_NO_MATCH) exact_match
3168: FROM mtl_cycle_count_entries mcce,
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
3414: NULL,
3415: NULL,
3416: C_EXACT_MATCH
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