APPS.OKS_QA_DATA_INTEGRITY dependencies on MTL_SYSTEM_ITEMS

Line 4220: FROM Mtl_system_items

4216: l_cle_rec l_cle_csr%ROWTYPE;
4217:
4218: CURSOR l_status_csr(p_inv_item NUMBER, p_org_id NUMBER) IS
4219: SELECT 1
4220: FROM Mtl_system_items
4221: WHERE Inventory_item_id = p_inv_item
4222: AND Organization_id = p_org_id
4223: AND (SYSDATE BETWEEN
4224: NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE));

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;

Line 7293: FROM mtl_system_items a, okc_k_items b

7289:
7290:
7291: CURSOR get_shipable_flag(cleId NUMBER) IS
7292: SELECT SHIPPABLE_ITEM_FLAG
7293: FROM mtl_system_items a, okc_k_items b
7294: WHERE b.cle_id = cleId AND a.SHIPPABLE_ITEM_FLAG = 'Y'
7295: AND a.INVENTORY_ITEM_ID = b.object1_id1
7296: AND a.ORGANIZATION_ID = b.object1_id2;
7297: