APPS.OKS_QA_DATA_INTEGRITY dependencies on MTL_SYSTEM_ITEMS_B_KFV

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;