DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_CYCLE_COUNT_ITEMS

Line 2800: mtl_cycle_count_items mcci

2796: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2797: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2798: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2799: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2800: mtl_cycle_count_items mcci
2801: WHERE msik.organization_id = p_organization_id
2802: AND msik.inventory_item_id = mcci.inventory_item_id
2803: AND mcci.cycle_count_header_id = p_cycle_count_header_id
2804: AND (msik.serial_number_control_code IN (1, 6)

Line 2867: mtl_cycle_count_items mcci, mtl_cross_references mcr

2863: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2864: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2865: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2866: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2867: mtl_cycle_count_items mcci, mtl_cross_references mcr
2868: WHERE msik.organization_id = p_organization_id
2869: AND msik.inventory_item_id = mcci.inventory_item_id
2870: AND mcci.cycle_count_header_id = p_cycle_count_header_id
2871: AND (msik.serial_number_control_code IN (1, 6)