APPS.OKS_ENTITLEMENTS_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 5885: MTL_SYSTEM_ITEMS_B_KFV MSI

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

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

5904: Lx_Result Gx_Boolean;
5905: Lx_Return_Status Gx_Ret_Sts;
5906:
5907: --Lv_Prod_Name OKX_CUSTOMER_PRODUCTS_V.Name%TYPE; --VARCHAR2(500);
5908: Lv_Prod_Name MTL_SYSTEM_ITEMS_B_KFV.description%TYPE; --VARCHAR2(500);
5909: Ln_ListPrice NUMBER;
5910: Li_TableIdx BINARY_INTEGER;
5911:
5912: BEGIN

Line 14483: FROM mtl_system_items_b_kfv mtl

14479:
14480: CURSOR Lx_Csr_SrvItem (Cx_SrvLine_Id In Gx_OKS_Id, Cn_Organization_Id IN NUMBER) IS
14481: SELECT mtl.concatenated_segments Name
14482: ,mtl.description Description
14483: FROM mtl_system_items_b_kfv mtl
14484: ,Okc_K_Items IT
14485: WHERE IT.Cle_Id = Cx_SrvLine_Id
14486: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')
14487: AND mtl.inventory_item_id = IT.Object1_Id1

Line 18436: MTL_SYSTEM_ITEMS_B_KFV sys

18432: oks_k_lines_b ksl,
18433: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18434: OKC_K_LINES_B Clv,
18435: OKC_K_ITEMS items,
18436: MTL_SYSTEM_ITEMS_B_KFV sys
18437: WHERE HDT.ID = HD.ID
18438: AND HDT.LANGUAGE = USERENV('LANG')
18439: AND Hd.Id = Sv.chr_id
18440: AND Hd.Id = nvl(P_Id,Hd.Id)

Line 18526: MTL_SYSTEM_ITEMS_B_KFV sys

18522: OKC_K_LINES_V Cov,
18523: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18524: OKC_K_LINES_B Clv,
18525: OKC_K_ITEMS items,
18526: MTL_SYSTEM_ITEMS_B_KFV sys
18527: WHERE Hd.Id = Sv.chr_id
18528: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
18529: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)
18530: AND Hd.Id = nvl(P_Id,Hd.Id)

Line 18614: MTL_SYSTEM_ITEMS_B_KFV sys

18610: OKS_K_LINES_B KSL,
18611: OKC_K_LINES_V Cov,
18612: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes
18613: OKC_K_ITEMS items,
18614: MTL_SYSTEM_ITEMS_B_KFV sys
18615: WHERE Hd.Id = Sv.chr_id
18616: AND HDT.ID = HD.ID
18617: AND HDT.LANGUAGE = USERENV('LANG') /*bug 7412576*/
18618: AND Hd.id = SV.DNZ_CHR_ID

Line 18698: MTL_SYSTEM_ITEMS_B_KFV sys

18694: OKS_K_LINES_B KSL,
18695: OKC_K_LINES_V Cov,
18696: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18697: OKC_K_ITEMS items,
18698: MTL_SYSTEM_ITEMS_B_KFV sys
18699: WHERE Hd.Id = Sv.chr_id
18700: AND HDT.ID = HD.ID
18701: AND HDT.LANGUAGE = USERENV('LANG')
18702: AND Hd.id = SV.DNZ_CHR_ID

Line 18779: MTL_SYSTEM_ITEMS_B_KFV sys

18775: OKC_K_LINES_V Cov,
18776: oks_k_lines_b ksl,
18777: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18778: OKC_K_ITEMS items,
18779: MTL_SYSTEM_ITEMS_B_KFV sys
18780: WHERE Hd.Id = Sv.chr_id
18781: AND Hd.id = SV.DNZ_CHR_ID
18782: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
18783: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 18866: MTL_SYSTEM_ITEMS_B_KFV sys

18862: OKC_K_LINES_V Cov,
18863: oks_k_lines_b ksl,
18864: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18865: OKC_K_ITEMS items,
18866: MTL_SYSTEM_ITEMS_B_KFV sys
18867: WHERE Hd.Id = Sv.chr_id
18868: AND HDT.ID = HD.ID
18869: AND HDT.LANGUAGE = USERENV('LANG') /*bug 7412576*/
18870: AND Hd.id = SV.DNZ_CHR_ID