INV Item template listing

Description

Imported from BI Publisher
Description: Item template listing xx xx Short Name INVIRTMP Itemp Template Report
Application: Inventory
Source: Item template listing (XML)
Short Name: INVIRTMP_XML
DB package: INV_INVIRTMP_XMLP_PKG

INV Item template listing and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

SELECT
   T.TEMPLATE_NAME,
   T.DESCRIPTION,
   &P_ATTRIBUTE_NAME ATTRIBUTE_NAME,
   TA.REPORT_USER_VALUE,
   F.MEANING ENABLED
FROM
  MTL_ITEM_TEMPLATES T,
  MTL_ITEM_TEMPL_ATTRIBUTES TA,
  MTL_ITEM_ATTRIBUTES  IA,
  FND_LOOKUPS F
WHERE
          F.LOOKUP_TYPE  = 'YES_NO'
AND   IA.ATTRIBUTE_NAME =  TA.ATTRIBUTE_NAME
AND   &P_ATTRIBUTE_NAME IS NOT NULL
AND   F.LOOKUP_CODE = TA.ENABLED_FLAG
AND   TA.TEMPLATE_ID   = T.TEMPLATE_ID
AND   (T.CONTEXT_ORGANIZATION_ID IS NULL OR
           T.CONTEXT_ORGANIZATION_ID = :P_ORG_ID )
AND   (((T.TEMPLATE_ID = :P_TEMPLATE_ID) 
              AND (:P_ALL_TEMPLATE_FLAG = 2) )  
        OR (
       DECODE (:P_ALL_TEMPLATE_FLAG, 2,2,0) = 0))
ORDER BY T.TEMPLATE_NAME, 
	   &P_ATTRIBUTE_NAME