DBA Data[Home] [Help]

APPS.ASO_SERVICE_CONTRACTS_INT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1056: FROM mtl_system_items_vl

1052: CURSOR C_warranty(item_id NUMBER) IS
1053: SELECT description, concatenated_segments
1054: -- SELECT description, segment1
1055: -- FROM aso_i_items_v
1056: FROM mtl_system_items_vl
1057: WHERE inventory_item_id = item_id
1058: AND organization_id = p_organization_id;
1059: /* AND bom_item_type in (1,4)
1060: AND inventory_item_status_code = 'Active'