VIEW: APPS.AST_ITEM_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT REL.INVENTORY_ITEM_ID , REL.ORGANIZATION_ID , REL.RELATED_ITEM_ID RELATED_INVENTORY_ITEM_ID , ITM.CONCATENATED_SEGMENTS RELATED_INVENTORY_NUMBER , ITM.DESCRIPTION RELATED_DESCRIPTION , LKU.LOOKUP_CODE RELATED_CODE , LKU.MEANING RELATED_CODE_MEANING , REL.RECIPROCAL_FLAG , DECODE(QTY.QUANTITY,NULL,'N',0,'N',DECODE(QTY.QUANTITY/QTY.QUANTITY,-1,'N','Y')) AVAILABLE_FLAG , NVL(QTY.QUANTITY,0) QUANTITY , NULL PRICE_LIST , NULL PRICE_LIST_ID , NULL PRICE_LIST_LINE_ID , ITM.PRIMARY_UOM_CODE , ITM.PRIMARY_UNIT_OF_MEASURE , ITM.LIST_PRICE_PER_UNIT , FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY') LIST_PRICE_CURRENCY_CODE FROM MTL_RELATED_ITEMS REL , MTL_SYSTEM_ITEMS_VL ITM , MTL_ITEM_QUANTITIES_VIEW QTY , MFG_LOOKUPS LKU WHERE ITM.INVENTORY_ITEM_ID = REL.RELATED_ITEM_ID AND ITM.ORGANIZATION_ID = REL.ORGANIZATION_ID AND QTY.INVENTORY_ITEM_ID (+) = ITM.INVENTORY_ITEM_ID AND QTY.ORGANIZATION_ID (+) = ITM.ORGANIZATION_ID AND LKU.LOOKUP_TYPE = 'MTL_RELATIONSHIP_TYPES' AND LKU.LOOKUP_CODE = REL.RELATIONSHIP_TYPE_ID

View Text - HTML Formatted

SELECT REL.INVENTORY_ITEM_ID
, REL.ORGANIZATION_ID
, REL.RELATED_ITEM_ID RELATED_INVENTORY_ITEM_ID
, ITM.CONCATENATED_SEGMENTS RELATED_INVENTORY_NUMBER
, ITM.DESCRIPTION RELATED_DESCRIPTION
, LKU.LOOKUP_CODE RELATED_CODE
, LKU.MEANING RELATED_CODE_MEANING
, REL.RECIPROCAL_FLAG
, DECODE(QTY.QUANTITY
, NULL
, 'N'
, 0
, 'N'
, DECODE(QTY.QUANTITY/QTY.QUANTITY
, -1
, 'N'
, 'Y')) AVAILABLE_FLAG
, NVL(QTY.QUANTITY
, 0) QUANTITY
, NULL PRICE_LIST
, NULL PRICE_LIST_ID
, NULL PRICE_LIST_LINE_ID
, ITM.PRIMARY_UOM_CODE
, ITM.PRIMARY_UNIT_OF_MEASURE
, ITM.LIST_PRICE_PER_UNIT
, FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY') LIST_PRICE_CURRENCY_CODE
FROM MTL_RELATED_ITEMS REL
, MTL_SYSTEM_ITEMS_VL ITM
, MTL_ITEM_QUANTITIES_VIEW QTY
, MFG_LOOKUPS LKU
WHERE ITM.INVENTORY_ITEM_ID = REL.RELATED_ITEM_ID
AND ITM.ORGANIZATION_ID = REL.ORGANIZATION_ID
AND QTY.INVENTORY_ITEM_ID (+) = ITM.INVENTORY_ITEM_ID
AND QTY.ORGANIZATION_ID (+) = ITM.ORGANIZATION_ID
AND LKU.LOOKUP_TYPE = 'MTL_RELATIONSHIP_TYPES'
AND LKU.LOOKUP_CODE = REL.RELATIONSHIP_TYPE_ID