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_ENTITLEMENTS_PVT dependencies on CSI_ITEM_INSTANCES

Line 6271: FROM CSI_ITEM_INSTANCES CSI,

6267: */
6268:
6269: CURSOR Lx_Csr_CovProd(Cn_Prod_Id NUMBER,Cn_Org_Id NUMBER,Ln_Organization_Id NUMBER) IS
6270: SELECT MSI.DESCRIPTION Name
6271: FROM CSI_ITEM_INSTANCES CSI,
6272: CSI_I_ORG_ASSIGNMENTS CIOA,
6273: MTL_SYSTEM_ITEMS_B_KFV MSI
6274: WHERE CSI.INSTANCE_ID = Cn_Prod_Id
6275: AND CSI.INSTANCE_ID = CIOA.INSTANCE_ID(+)

Line 8701: FROM csi_item_instances

8697: UNION
8698: SELECT instance_id object_id,
8699: -- null subject_id
8700: -1 subject_id --bug 2740241
8701: FROM csi_item_instances
8702: where instance_id = Cx_CovProd_Id;
8703: */
8704:
8705: CURSOR Lx_Csr_CovProd(Cx_CovProd_Id IN Gx_OKS_Id

Line 8713: FROM CSI_ITEM_INSTANCES CSI

8709: CSI.System_id System_id,
8710: CSI.Owner_party_account_id Owner_party_account_id, --CSI.Owner_party_id Owner_party_id
8711: CSI.install_location_id install_location_id,
8712: CSI.INSTALL_LOCATION_TYPE_CODE install_location_type_code
8713: FROM CSI_ITEM_INSTANCES CSI
8714: WHERE CSI.INSTANCE_ID = Cx_CovProd_Id;
8715:
8716:
8717:

Line 8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;

8738: Lx_Site_Id Okx_Customer_Products_V.Install_Site_Use_Id%TYPE;
8739: */
8740:
8741: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8746: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;

Line 8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;

8739: */
8740:
8741: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8746: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8747:

Line 8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;

8740:
8741: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8746: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8747:
8748: Lx_PARENT_OBJ GT_PARENT_Ref;

Line 8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;

8741: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8746: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8747:
8748: Lx_PARENT_OBJ GT_PARENT_Ref;
8749: Li_PAR_Idx BINARY_INTEGER;

Line 8746: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;

8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8746: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8747:
8748: Lx_PARENT_OBJ GT_PARENT_Ref;
8749: Li_PAR_Idx BINARY_INTEGER;
8750:

Line 14641: FROM CSI_ITEM_INSTANCES CSI

14637:
14638: CURSOR Lx_Csr_SysProd(Cx_System_id IN VARCHAR2) IS
14639: SELECT CSI.instance_id CP_Id
14640: ,CSI.System_Id System_Id
14641: FROM CSI_ITEM_INSTANCES CSI
14642: WHERE CSI.System_id = (Cx_System_Id);
14643:
14644:
14645: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS

Line 15397: FROM CSI_ITEM_INSTANCES CSI

15393:
15394: CURSOR Lx_Csr_SysProd(Cx_System_id IN VARCHAR2) IS
15395: SELECT CSI.instance_id CP_Id,
15396: CSI.System_Id System_Id
15397: FROM CSI_ITEM_INSTANCES CSI
15398: WHERE CSI.System_id = (Cx_System_Id);
15399:
15400: l_system_id NUMBER;
15401: l_request_date DATE;