DBA Data[Home] [Help]

APPS.OPI_DBI_INV_CCA_PKG dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1088: mtl_cycle_count_headers mcch,

1084: decode (sum (mmt_mta.primary_quantity),
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,

Line 1384: mtl_cycle_count_headers mcch,

1380: decode (sum (mmt_gtv.primary_quantity),
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,

Line 1509: No need to join to MTL_CYCLE_COUNT_HEADERS as we don't need to

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:
1512: MCCE does not store quantities in the primary uom_code. If the
1513: transaction uom is not the same as the primary uom, all

Line 2885: mtl_cycle_count_headers mcch,

2881: decode (sum (mmt_mta.primary_quantity),
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,

Line 3169: mtl_cycle_count_headers mcch,

3165: decode (sum (mmt_gtv.primary_quantity),
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,

Line 3282: No need to join to MTL_CYCLE_COUNT_HEADERS as we don't need to

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:
3285: MCCE does not store quantities in the primary uom_code. If the
3286: transaction uom is not the same as the primary uom, all