eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QA_DATA_INTEGRITY dependencies on CS_CUSTOMER_PRODUCT_STATUSES

Line 4279: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES

4275: SELECT status
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,

Line 4283: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,

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
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