DBA Data[Home] [Help]

APPS.INV_LOT_API_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3460: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM

3456:
3457: -- Following query added as a part of the bug fix for Bug # 3330855
3458: SELECT ORGANIZATION_CODE, CONCATENATED_SEGMENTS
3459: INTO v_org_code, v_item_name
3460: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM
3461: WHERE ORG.ORGANIZATION_ID = p_org_id
3462: AND INVENTORY_ITEM_ID = p_inventory_item_id
3463: AND ITEM.ORGANIZATION_ID = p_org_id;
3464: