APPS.OKS_ENTITLEMENTS_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 6273: MTL_SYSTEM_ITEMS_B_KFV MSI

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(+)
6276: AND CIOA.RELATIONSHIP_TYPE_CODE (+) = 'SOLD_FROM'
6277: AND CSI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 6296: Lv_Prod_Name MTL_SYSTEM_ITEMS_B_KFV.description%TYPE; --VARCHAR2(500);

6292: Lx_Result Gx_Boolean;
6293: Lx_Return_Status Gx_Ret_Sts;
6294:
6295: --Lv_Prod_Name OKX_CUSTOMER_PRODUCTS_V.Name%TYPE; --VARCHAR2(500);
6296: Lv_Prod_Name MTL_SYSTEM_ITEMS_B_KFV.description%TYPE; --VARCHAR2(500);
6297: Ln_ListPrice NUMBER;
6298: Li_TableIdx BINARY_INTEGER;
6299:
6300: BEGIN

Line 15845: FROM mtl_system_items_b_kfv mtl

15841:
15842: CURSOR Lx_Csr_SrvItem (Cx_SrvLine_Id In Gx_OKS_Id, Cn_Organization_Id IN NUMBER) IS
15843: SELECT mtl.concatenated_segments Name
15844: ,mtl.description Description
15845: FROM mtl_system_items_b_kfv mtl
15846: ,Okc_K_Items IT
15847: WHERE IT.Cle_Id = Cx_SrvLine_Id
15848: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')
15849: AND mtl.inventory_item_id = IT.Object1_Id1

Line 20724: MTL_SYSTEM_ITEMS_B_KFV sys

20720: oks_k_lines_b ksl,
20721: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20722: OKC_K_LINES_B Clv,
20723: OKC_K_ITEMS items,
20724: MTL_SYSTEM_ITEMS_B_KFV sys
20725: WHERE HDT.ID = HD.ID
20726: AND HDT.LANGUAGE = USERENV('LANG')
20727: AND Hd.Id = Sv.chr_id
20728: AND Hd.Id = nvl(P_Id,Hd.Id)

Line 20814: MTL_SYSTEM_ITEMS_B_KFV sys

20810: OKC_K_LINES_V Cov,
20811: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20812: OKC_K_LINES_B Clv,
20813: OKC_K_ITEMS items,
20814: MTL_SYSTEM_ITEMS_B_KFV sys
20815: WHERE Hd.Id = Sv.chr_id
20816: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
20817: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)
20818: AND Hd.Id = nvl(P_Id,Hd.Id)

Line 20902: MTL_SYSTEM_ITEMS_B_KFV sys

20898: OKS_K_LINES_B KSL,
20899: OKC_K_LINES_V Cov,
20900: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes
20901: OKC_K_ITEMS items,
20902: MTL_SYSTEM_ITEMS_B_KFV sys
20903: WHERE Hd.Id = Sv.chr_id
20904: AND HDT.ID = HD.ID
20905: AND HDT.LANGUAGE = USERENV('LANG') /*bug 7412576*/
20906: AND Hd.id = SV.DNZ_CHR_ID

Line 20986: MTL_SYSTEM_ITEMS_B_KFV sys

20982: OKS_K_LINES_B KSL,
20983: OKC_K_LINES_V Cov,
20984: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20985: OKC_K_ITEMS items,
20986: MTL_SYSTEM_ITEMS_B_KFV sys
20987: WHERE Hd.Id = Sv.chr_id
20988: AND HDT.ID = HD.ID
20989: AND HDT.LANGUAGE = USERENV('LANG')
20990: AND Hd.id = SV.DNZ_CHR_ID

Line 21062: MTL_SYSTEM_ITEMS_B_KFV sys

21058: OKC_K_LINES_B Cov,
21059: OKC_K_LINES_TL COVTL,
21060: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21061: OKC_K_ITEMS items,
21062: MTL_SYSTEM_ITEMS_B_KFV sys
21063: WHERE Hd.Id = Sv.chr_id
21064: AND Hd.id = SV.DNZ_CHR_ID
21065: AND Hd.Id = P_ID -- nvl(P_Id,Hd.Id)
21066: AND HD.ID=HDT.ID

Line 21131: MTL_SYSTEM_ITEMS_B_KFV sys

21127: OKC_K_LINES_V Cov,
21128: oks_k_lines_b ksl,
21129: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21130: OKC_K_ITEMS items,
21131: MTL_SYSTEM_ITEMS_B_KFV sys
21132: WHERE Hd.Id = Sv.chr_id
21133: AND Hd.id = SV.DNZ_CHR_ID
21134: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
21135: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 21218: MTL_SYSTEM_ITEMS_B_KFV sys

21214: OKC_K_LINES_V Cov,
21215: oks_k_lines_b ksl,
21216: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21217: OKC_K_ITEMS items,
21218: MTL_SYSTEM_ITEMS_B_KFV sys
21219: WHERE Hd.Id = Sv.chr_id
21220: AND HDT.ID = HD.ID
21221: AND HDT.LANGUAGE = USERENV('LANG') /*bug 7412576*/
21222: AND Hd.id = SV.DNZ_CHR_ID