APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4896: FROM mtl_system_items

4892: WHERE claim_id = cv_claim_id;
4893:
4894: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
4895: SELECT primary_uom_code
4896: FROM mtl_system_items
4897: WHERE inventory_item_id = cv_item_id
4898: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
4899:
4900: CURSOR csr_offer_perf(cv_list_header_id IN NUMBER) IS

Line 5512: FROM mtl_system_items

5508: WHERE claim_id = cv_claim_id;
5509:
5510: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
5511: SELECT primary_uom_code
5512: FROM mtl_system_items
5513: WHERE inventory_item_id = cv_item_id
5514: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
5515:
5516: CURSOR csr_offer_perf(cv_list_header_id IN NUMBER) IS

Line 6256: FROM mtl_system_items

6252: WHERE claim_id = cv_claim_id;
6253:
6254: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
6255: SELECT primary_uom_code
6256: FROM mtl_system_items
6257: WHERE inventory_item_id = cv_item_id
6258: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
6259:
6260: -- Fix for Bug 7632911

Line 11940: FROM mtl_system_items ms

11936: l_cust_util_tbl cust_util_tbl_type;
11937:
11938: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
11939: SELECT ms.primary_uom_code
11940: FROM mtl_system_items ms
11941: , mtl_parameters mp
11942: , org_organization_definitions ood
11943: WHERE ms.inventory_item_id = cv_item_id
11944: AND ms.organization_id = mp.organization_id