INV Item template listing

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Item template listing (XML)
Short Name: INVIRTMP_XML
DB package: INV_INVIRTMP_XMLP_PKG
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
Parameter Name SQL text Validation
Caller Responsibility Id
 
Number
Caller Responsibility Appl Id
 
Number
Organization
 
Number
Item Template
 
LOV Oracle
All Template Flag
 
LOV Oracle