DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1465: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

1461: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
1462: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
1463: IS
1464: SELECT DISTINCT MI.comms_nl_trackable_flag
1465: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
1466: WHERE MP.organization_id = MI.organization_id
1467: AND MI.inventory_item_id = c_inventory_item_id
1468: AND MI.organization_id = c_inventory_org_id
1469: AND MI.enabled_flag = 'Y'

Line 2037: FROM MTL_SYSTEM_ITEMS_KFV MTL

2033:
2034: CURSOR get_item_number ( c_inventory_item_id NUMBER, c_inventory_master_org_id NUMBER )
2035: IS
2036: SELECT mtl.concatenated_segments
2037: FROM MTL_SYSTEM_ITEMS_KFV MTL
2038: WHERE
2039: mtl.ORGANIZATION_ID(+) = c_inventory_item_id AND
2040: mtl.inventory_item_id(+) = c_inventory_master_org_id;
2041: