APPS.OKS_QA_DATA_INTEGRITY dependencies on CSI_ITEM_INSTANCES

Line 2231: FROM csi_item_instances

2227: WHERE cle_id = p_cle_id ;
2228:
2229: CURSOR l_product_csr(p_cp_id NUMBER) IS
2230: SELECT inventory_item_id
2231: FROM csi_item_instances
2232: WHERE instance_id = p_cp_id;
2233:
2234: l_cp_id NUMBER;
2235:

Line 4241: FROM csi_item_instances -- okx_cust_prod_v

4237: l_chk_service_prod_rec l_chk_service_prod_csr%ROWTYPE;
4238:
4239: CURSOR l_get_inv_item_csr (p_cp_id NUMBER) IS
4240: SELECT inventory_item_id
4241: FROM csi_item_instances -- okx_cust_prod_v
4242: WHERE instance_id = p_cp_id;
4243:
4244: l_get_inv_item_rec l_get_inv_item_csr%ROWTYPE;
4245:

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

6204: WHERE cle_id = p_cle_id ;
6205:
6206: CURSOR l_product_csr(p_cp_id NUMBER) IS
6207: SELECT inventory_item_id
6208: FROM csi_item_instances
6209: WHERE instance_id = p_cp_id;
6210:
6211: l_cp_id NUMBER;
6212: l_sts_code VARCHAR2(100);

Line 7422: FROM csi_item_instances

7418:
7419:
7420: CURSOR Exact_Item_Inst(l_instance_id NUMBER) IS
7421: SELECT instance_id, quantity, unit_of_measure
7422: FROM csi_item_instances
7423: WHERE instance_id = l_instance_id;
7424:
7425: l_exact_item_inst Exact_Item_Inst%ROWTYPE;
7426: