DBA Data[Home] [Help]

APPS.CSI_INV_DISCREPANCY_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 577: mtl_system_items_kfv msk

573: msi.serial_number_control_code serial_code,
574: msi.lot_control_code lot_code
575: FROM mtl_system_items msi,
576: mtl_serial_numbers msn,
577: mtl_system_items_kfv msk
578: WHERE msi.inventory_item_id = msn.inventory_item_id
579: AND msi.organization_id = msn.current_organization_id
580: AND msi.inventory_item_id = msk.inventory_item_id
581: AND msi.organization_id = msk.organization_id

Line 811: FROM MTL_SYSTEM_ITEMS_KFV

807: --
808: BEGIN
809: SELECT concatenated_segments
810: INTO v_item_name
811: FROM MTL_SYSTEM_ITEMS_KFV
812: WHERE inventory_item_id = srl_rec.inventory_item_id
813: AND organization_id = srl_rec.organization_id;
814: EXCEPTION
815: WHEN no_data_found THEN