DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 2930: mtl_cycle_count_entries mcce

2926: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2927: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2928: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2929: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2930: mtl_cycle_count_entries mcce
2931: WHERE msik.organization_id = p_organization_id
2932: AND msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
2933: AND msik.inventory_item_id = mcce.inventory_item_id
2934: AND mcce.cycle_count_header_id = p_cycle_count_header_id

Line 3003: mtl_cycle_count_entries mcce, mtl_cross_references mcr

2999: NVL(msik.TRACKING_QUANTITY_IND,'P'),
3000: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
3001: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
3002: FROM mtl_system_items_vl msik, /* Bug 5581528 */
3003: mtl_cycle_count_entries mcce, mtl_cross_references mcr
3004: WHERE msik.organization_id = p_organization_id
3005: AND msik.inventory_item_id = mcce.inventory_item_id
3006: AND mcce.cycle_count_header_id = p_cycle_count_header_id
3007: AND mcce.organization_id = p_organization_id

Line 3072: FROM mtl_item_revisions mir, mtl_cycle_count_entries mcce

3068: OPEN x_revs FOR
3069: SELECT UNIQUE mir.revision
3070: , mir.effectivity_date
3071: , NVL(mir.description, '')
3072: FROM mtl_item_revisions mir, mtl_cycle_count_entries mcce
3073: WHERE mir.organization_id = p_organization_id
3074: AND mir.inventory_item_id = p_inventory_item_id
3075: AND mir.revision LIKE (p_revision)
3076: AND mir.inventory_item_id = mcce.inventory_item_id