DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_LOVS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 433: FROM mtl_system_items_kfv msik

429: NVL(TRACKING_QUANTITY_IND,'P'),
430: NVL(DUAL_UOM_DEVIATION_HIGH,0),
431: NVL(DUAL_UOM_DEVIATION_LOW,0)
432: -- INVCONV , NSRIVAST, END
433: FROM mtl_system_items_kfv msik
434: WHERE msik.organization_id = p_organization_id
435: AND msik.inventory_item_flag = 'Y'
436: AND msik.stock_enabled_flag = 'Y'
437: AND msik.concatenated_segments LIKE p_item||l_append

Line 519: FROM mtl_system_items_kfv msik,

515: NVL(TRACKING_QUANTITY_IND,'P'),
516: NVL(DUAL_UOM_DEVIATION_HIGH,0),
517: NVL(DUAL_UOM_DEVIATION_LOW,0)
518: -- INVCONV , NSRIVAST, END
519: FROM mtl_system_items_kfv msik,
520: mtl_cross_references mcr
521: WHERE msik.organization_id = p_organization_id
522: AND msik.inventory_item_id = mcr.inventory_item_id
523: AND mcr.cross_reference_type = g_gtin_cross_ref_type