DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 2776: mtl_cycle_count_entries mcce

2772: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2773: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2774: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2775: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2776: mtl_cycle_count_entries mcce
2777: WHERE msik.organization_id = p_organization_id
2778: AND msik.concatenated_segments LIKE (p_concatenated_segments)
2779: AND msik.inventory_item_id = mcce.inventory_item_id
2780: AND mcce.cycle_count_header_id = p_cycle_count_header_id

Line 2848: mtl_cycle_count_entries mcce, mtl_cross_references mcr

2844: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2845: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2846: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2847: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2848: mtl_cycle_count_entries mcce, mtl_cross_references mcr
2849: WHERE msik.organization_id = p_organization_id
2850: AND msik.inventory_item_id = mcce.inventory_item_id
2851: AND mcce.cycle_count_header_id = p_cycle_count_header_id
2852: AND mcce.organization_id = p_organization_id

Line 2917: FROM mtl_item_revisions mir, mtl_cycle_count_entries mcce

2913: OPEN x_revs FOR
2914: SELECT UNIQUE mir.revision
2915: , mir.effectivity_date
2916: , NVL(mir.description, '')
2917: FROM mtl_item_revisions mir, mtl_cycle_count_entries mcce
2918: WHERE mir.organization_id = p_organization_id
2919: AND mir.inventory_item_id = p_inventory_item_id
2920: AND mir.revision LIKE (p_revision)
2921: AND mir.inventory_item_id = mcce.inventory_item_id