DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_CYCLE_COUNT_ITEMS

Line 2650: mtl_cycle_count_items mcci

2646: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2647: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2648: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2649: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2650: mtl_cycle_count_items mcci
2651: WHERE msik.organization_id = p_organization_id
2652: AND msik.inventory_item_id = mcci.inventory_item_id
2653: AND mcci.cycle_count_header_id = p_cycle_count_header_id
2654: AND (msik.serial_number_control_code IN (1, 6)

Line 2714: mtl_cycle_count_items mcci, mtl_cross_references mcr

2710: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2711: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2712: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2713: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2714: mtl_cycle_count_items mcci, mtl_cross_references mcr
2715: WHERE msik.organization_id = p_organization_id
2716: AND msik.inventory_item_id = mcci.inventory_item_id
2717: AND mcci.cycle_count_header_id = p_cycle_count_header_id
2718: AND (msik.serial_number_control_code IN (1, 6)