APPS.OZF_AR_INTERFACE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1147: FROM mtl_system_items_vl

1143: WHERE reason_code_id = cv_reason_code_id;
1144:
1145: CURSOR csr_product_desc(cv_inventory_item_id IN NUMBER) IS
1146: SELECT SUBSTRB(description, 1, 240)
1147: FROM mtl_system_items_vl
1148: WHERE inventory_item_id = cv_inventory_item_id
1149: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
1150:
1151: CURSOR csr_offer_name(cv_claim_line_id IN NUMBER)IS