[Home] [Help]
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
1094: parallel(mmt) parallel(mta) parallel(log)
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
1390: -- quantity is summed correctly and then it can be joined with
1503: date (i.e. entry_status_code = 5 and approval_date > global start date).
1504:
1505: The adjustment quantity is always 0 and hit/miss tolerances are not
1506: needed since all entries are, by definition, hits. We still need to join
1507: to MTL_CYCLE_COUNT_CLASSES to get the count and count class information.
1508:
1509: No need to join to MTL_CYCLE_COUNT_HEADERS as we don't need to
1510: get any tolerances.
1511:
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
1659: -- exact matches are approved at the time entry is completed
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
2891: mmt.organization_id,
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
3175: -- by transaction_id and primary_quantity level.
3276: date (i.e. entry_status_code = 5 and approval_date > global start date).
3277:
3278: The adjustment quantity is always 0 and hit/miss tolerances are not
3279: needed since all entries are, by definition, hits. We still need to join
3280: to MTL_CYCLE_COUNT_CLASSES to get the count and count class information.
3281:
3282: No need to join to MTL_CYCLE_COUNT_HEADERS as we don't need to
3283: get any tolerances.
3284:
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
3423: WHERE mcce.last_update_date >= l_from_bound_date