APPS.OKS_QA_DATA_INTEGRITY dependencies on MTL_SYSTEM_ITEMS

Line 4367: FROM Mtl_system_items

4363: l_cle_rec l_cle_csr%ROWTYPE;
4364:
4365: CURSOR l_status_csr(p_inv_item NUMBER, p_org_id NUMBER) IS
4366: SELECT 1
4367: FROM Mtl_system_items
4368: WHERE Inventory_item_id = p_inv_item
4369: AND Organization_id = p_org_id
4370: AND (SYSDATE BETWEEN
4371: NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE));

Line 4380: FROM MTL_SYSTEM_ITEMS_B_KFV

4376: SELECT service_item_flag, vendor_warranty_flag,
4377: usage_item_flag, serviceable_product_flag,
4378: customer_order_enabled_flag, internal_order_enabled_flag,
4379: invoice_enabled_flag
4380: FROM MTL_SYSTEM_ITEMS_B_KFV
4381: WHERE Inventory_item_id = p_inv_item
4382: AND Organization_id = p_org_id;
4383:
4384: l_chk_service_prod_rec l_chk_service_prod_csr%ROWTYPE;

Line 4416: FROM MTL_SYSTEM_ITEMS_B_KFV --okx_system_items_v

4412: WHERE cle_id = p_id;
4413:
4414: CURSOR l_covitm_csr(p_inv_item NUMBER, p_org_id NUMBER) IS
4415: SELECT DECODE(ENABLED_FLAG, 'Y', 'A', 'I') status
4416: FROM MTL_SYSTEM_ITEMS_B_KFV --okx_system_items_v
4417: WHERE INVENTORY_ITEM_ID = p_inv_item
4418: AND Organization_id = p_org_id
4419: AND serviceable_product_flag = 'Y';
4420:

Line 4427: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK

4423: FROM HZ_PARTIES --okx_parties_v
4424: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION') AND PARTY_ID = l_inv_id;
4425:
4426: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES
4427: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK
4428: CURSOR l_covprod_csr(p_inv_id NUMBER, p_org_id NUMBER) IS
4429: SELECT cs.Service_order_allowed_flag, CP.ACTIVE_END_DATE
4430: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,
4431: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK

Line 4431: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK

4427: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK
4428: CURSOR l_covprod_csr(p_inv_id NUMBER, p_org_id NUMBER) IS
4429: SELECT cs.Service_order_allowed_flag, CP.ACTIVE_END_DATE
4430: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,
4431: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK
4432: WHERE BK.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
4433: AND CP.INSTANCE_STATUS_ID = cs.customer_product_status_id
4434: AND CP.INSTANCE_ID = p_inv_id
4435: AND BK.ORGANIZATION_ID = p_org_id;

Line 7442: FROM mtl_system_items a, okc_k_items b

7438:
7439:
7440: CURSOR get_shipable_flag(cleId NUMBER) IS
7441: SELECT SHIPPABLE_ITEM_FLAG
7442: FROM mtl_system_items a, okc_k_items b
7443: WHERE b.cle_id = cleId AND a.SHIPPABLE_ITEM_FLAG = 'Y'
7444: AND a.INVENTORY_ITEM_ID = b.object1_id1
7445: AND a.ORGANIZATION_ID = b.object1_id2;
7446: