DBA Data[Home] [Help]

APPS.ASL_INV_ITEM_SUMM_PUB dependencies on MTL_SYSTEM_ITEMS_TL

Line 274: MTL_SYSTEM_ITEMS_TL ITEM,

270: DECODE(B.BOM_ITEM_TYPE,1,'MDL',4,DECODE(B.SERVICE_ITEM_FLAG ,'Y','SRV', DECODE(B.SERVICEABLE_PRODUCT_FLAG,'Y','SVA','STD')),'OPP') ,
271: B.VENDOR_WARRANTY_FLAG,
272: B.PRIMARY_UOM_CODE
273: FROM MTL_SYSTEM_ITEMS_B_KFV B,
274: MTL_SYSTEM_ITEMS_TL ITEM,
275: MTL_ITEM_CATEGORIES MIC,
276: MTL_UNITS_OF_MEASURE_TL UOM
277: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
278: AND MIC.CATEGORY_SET_ID = l_category_set_id

Line 343: MTL_SYSTEM_ITEMS_TL ITEM,

339: DECODE(B.BOM_ITEM_TYPE,1,'MDL',4,DECODE(B.SERVICE_ITEM_FLAG ,'Y','SRV', DECODE(B.SERVICEABLE_PRODUCT_FLAG,'Y','SVA','STD')),'OPP') ,
340: B.VENDOR_WARRANTY_FLAG,
341: B.PRIMARY_UOM_CODE
342: FROM MTL_SYSTEM_ITEMS_B_KFV B,
343: MTL_SYSTEM_ITEMS_TL ITEM,
344: MTL_ITEM_CATEGORIES MIC,
345: MTL_UNITS_OF_MEASURE_TL UOM
346: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
347: AND MIC.CATEGORY_SET_ID = l_category_set_id

Line 480: MTL_SYSTEM_ITEMS_TL ITEM,

476: B.returnable_flag ,
477: B.SERVICEABLE_PRODUCT_FLAG ,
478: 'Y' -- Active Flag to be 'Y'
479: FROM MTL_SYSTEM_ITEMS_B_KFV B,
480: MTL_SYSTEM_ITEMS_TL ITEM,
481: MTL_ITEM_CATEGORIES MIC,
482: MTL_UNITS_OF_MEASURE_TL UOM
483: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
484: AND MIC.CATEGORY_SET_ID = l_category_set_id

Line 503: MTL_SYSTEM_ITEMS_TL ITEM,

499: AND aiid.LANGUAGE_CODE = userenv('LANG')
500: -- if we do not put this part of code and if select does not get records update will raise ora error
501: AND EXISTS (SELECT 1 FROM
502: MTL_SYSTEM_ITEMS_B_KFV B,
503: MTL_SYSTEM_ITEMS_TL ITEM,
504: MTL_ITEM_CATEGORIES MIC,
505: MTL_UNITS_OF_MEASURE_TL UOM
506: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
507: AND MIC.CATEGORY_SET_ID = l_category_set_id

Line 574: MTL_SYSTEM_ITEMS_TL ITEM,

570: DECODE(B.BOM_ITEM_TYPE,1,'MDL',4,DECODE(B.SERVICE_ITEM_FLAG ,'Y','SRV', DECODE(B.SERVICEABLE_PRODUCT_FLAG,'Y','SVA','STD')),'OPP') ,
571: B.VENDOR_WARRANTY_FLAG,
572: B.PRIMARY_UOM_CODE
573: FROM MTL_SYSTEM_ITEMS_B_KFV B,
574: MTL_SYSTEM_ITEMS_TL ITEM,
575: MTL_ITEM_CATEGORIES MIC,
576: MTL_UNITS_OF_MEASURE_TL UOM
577: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
578: AND MIC.CATEGORY_SET_ID = l_category_set_id