Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_ITEM_RELATIONSHIPS_V |
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