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 5883: FROM CSI_ITEM_INSTANCES CSI,

5879: */
5880:
5881: CURSOR Lx_Csr_CovProd(Cn_Prod_Id NUMBER,Cn_Org_Id NUMBER,Ln_Organization_Id NUMBER) IS
5882: SELECT MSI.DESCRIPTION Name
5883: FROM CSI_ITEM_INSTANCES CSI,
5884: CSI_I_ORG_ASSIGNMENTS CIOA,
5885: MTL_SYSTEM_ITEMS_B_KFV MSI
5886: WHERE CSI.INSTANCE_ID = Cn_Prod_Id
5887: AND CSI.INSTANCE_ID = CIOA.INSTANCE_ID(+)

Line 8313: FROM csi_item_instances

8309: UNION
8310: SELECT instance_id object_id,
8311: -- null subject_id
8312: -1 subject_id --bug 2740241
8313: FROM csi_item_instances
8314: where instance_id = Cx_CovProd_Id;
8315: */
8316:
8317: CURSOR Lx_Csr_CovProd(Cx_CovProd_Id IN Gx_OKS_Id

Line 8325: FROM CSI_ITEM_INSTANCES CSI

8321: CSI.System_id System_id,
8322: CSI.Owner_party_account_id Owner_party_account_id, --CSI.Owner_party_id Owner_party_id
8323: CSI.install_location_id install_location_id,
8324: CSI.INSTALL_LOCATION_TYPE_CODE install_location_type_code
8325: FROM CSI_ITEM_INSTANCES CSI
8326: WHERE CSI.INSTANCE_ID = Cx_CovProd_Id;
8327:
8328:
8329:

Line 8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;

8350: Lx_Site_Id Okx_Customer_Products_V.Install_Site_Use_Id%TYPE;
8351: */
8352:
8353: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8358: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;

Line 8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;

8351: */
8352:
8353: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8358: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8359:

Line 8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;

8352:
8353: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8358: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8359:
8360: Lx_PARENT_OBJ GT_PARENT_Ref;

Line 8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;

8353: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8358: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8359:
8360: Lx_PARENT_OBJ GT_PARENT_Ref;
8361: Li_PAR_Idx BINARY_INTEGER;

Line 8358: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;

8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;
8358: Lx_Site_Type_Code CSI_ITEM_INSTANCES.Install_location_type_code%TYPE;
8359:
8360: Lx_PARENT_OBJ GT_PARENT_Ref;
8361: Li_PAR_Idx BINARY_INTEGER;
8362:

Line 13283: FROM CSI_ITEM_INSTANCES CSI

13279:
13280: CURSOR Lx_Csr_SysProd(Cx_System_id IN VARCHAR2) IS
13281: SELECT CSI.instance_id CP_Id
13282: ,CSI.System_Id System_Id
13283: FROM CSI_ITEM_INSTANCES CSI
13284: WHERE CSI.System_id = (Cx_System_Id);
13285:
13286:
13287: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS

Line 14039: FROM CSI_ITEM_INSTANCES CSI

14035:
14036: CURSOR Lx_Csr_SysProd(Cx_System_id IN VARCHAR2) IS
14037: SELECT CSI.instance_id CP_Id,
14038: CSI.System_Id System_Id
14039: FROM CSI_ITEM_INSTANCES CSI
14040: WHERE CSI.System_id = (Cx_System_Id);
14041:
14042: l_system_id NUMBER;
14043: l_request_date DATE;