APPS.OKS_QA_DATA_INTEGRITY dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4233: FROM MTL_SYSTEM_ITEMS_B_KFV

4229: SELECT service_item_flag, vendor_warranty_flag,
4230: usage_item_flag, serviceable_product_flag,
4231: customer_order_enabled_flag, internal_order_enabled_flag,
4232: invoice_enabled_flag
4233: FROM MTL_SYSTEM_ITEMS_B_KFV
4234: WHERE Inventory_item_id = p_inv_item
4235: AND Organization_id = p_org_id;
4236:
4237: l_chk_service_prod_rec l_chk_service_prod_csr%ROWTYPE;

Line 4269: FROM MTL_SYSTEM_ITEMS_B_KFV --okx_system_items_v

4265: WHERE cle_id = p_id;
4266:
4267: CURSOR l_covitm_csr(p_inv_item NUMBER, p_org_id NUMBER) IS
4268: SELECT DECODE(ENABLED_FLAG, 'Y', 'A', 'I') status
4269: FROM MTL_SYSTEM_ITEMS_B_KFV --okx_system_items_v
4270: WHERE INVENTORY_ITEM_ID = p_inv_item
4271: AND Organization_id = p_org_id
4272: AND serviceable_product_flag = 'Y';
4273:

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

4276: FROM HZ_PARTIES --okx_parties_v
4277: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION') AND PARTY_ID = l_inv_id;
4278:
4279: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES
4280: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK
4281: CURSOR l_covprod_csr(p_inv_id NUMBER, p_org_id NUMBER) IS
4282: SELECT cs.Service_order_allowed_flag, CP.ACTIVE_END_DATE
4283: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,
4284: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK

Line 4284: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK

4280: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK
4281: CURSOR l_covprod_csr(p_inv_id NUMBER, p_org_id NUMBER) IS
4282: SELECT cs.Service_order_allowed_flag, CP.ACTIVE_END_DATE
4283: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,
4284: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK
4285: WHERE BK.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
4286: AND CP.INSTANCE_STATUS_ID = cs.customer_product_status_id
4287: AND CP.INSTANCE_ID = p_inv_id
4288: AND BK.ORGANIZATION_ID = p_org_id;