APPS.OKS_QA_DATA_INTEGRITY dependencies on CSI_ITEM_INSTANCES

Line 2300: FROM csi_item_instances

2296: WHERE cle_id = p_cle_id ;
2297:
2298: CURSOR l_product_csr(p_cp_id NUMBER) IS
2299: SELECT inventory_item_id
2300: FROM csi_item_instances
2301: WHERE instance_id = p_cp_id;
2302:
2303: l_cp_id NUMBER;
2304:

Line 4388: FROM csi_item_instances -- okx_cust_prod_v

4384: l_chk_service_prod_rec l_chk_service_prod_csr%ROWTYPE;
4385:
4386: CURSOR l_get_inv_item_csr (p_cp_id NUMBER) IS
4387: SELECT inventory_item_id
4388: FROM csi_item_instances -- okx_cust_prod_v
4389: WHERE instance_id = p_cp_id;
4390:
4391: l_get_inv_item_rec l_get_inv_item_csr%ROWTYPE;
4392:

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 6355: FROM csi_item_instances

6351: WHERE cle_id = p_cle_id ;
6352:
6353: CURSOR l_product_csr(p_cp_id NUMBER) IS
6354: SELECT inventory_item_id
6355: FROM csi_item_instances
6356: WHERE instance_id = p_cp_id;
6357:
6358: l_cp_id NUMBER;
6359: l_sts_code VARCHAR2(100);

Line 7571: FROM csi_item_instances

7567:
7568:
7569: CURSOR Exact_Item_Inst(l_instance_id NUMBER) IS
7570: SELECT instance_id, quantity, unit_of_measure
7571: FROM csi_item_instances
7572: WHERE instance_id = l_instance_id;
7573:
7574: l_exact_item_inst Exact_Item_Inst%ROWTYPE;
7575: