APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4510: FROM mtl_system_items

4506: WHERE claim_id = cv_claim_id;
4507:
4508: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
4509: SELECT primary_uom_code
4510: FROM mtl_system_items
4511: WHERE inventory_item_id = cv_item_id
4512: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
4513:
4514: CURSOR csr_offer_perf(cv_list_header_id IN NUMBER) IS

Line 5206: FROM mtl_system_items

5202: WHERE claim_id = cv_claim_id;
5203:
5204: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
5205: SELECT primary_uom_code
5206: FROM mtl_system_items
5207: WHERE inventory_item_id = cv_item_id
5208: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
5209:
5210: -- Fix for Bug 7632911

Line 9681: FROM mtl_system_items ms

9677: l_cust_util_tbl cust_util_tbl_type;
9678:
9679: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
9680: SELECT ms.primary_uom_code
9681: FROM mtl_system_items ms
9682: , mtl_parameters mp
9683: , org_organization_definitions ood
9684: WHERE ms.inventory_item_id = cv_item_id
9685: AND ms.organization_id = mp.organization_id