View: SO_INCLUDED_ITEMS_OEXORRSO_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_INCLUDED_ITEMS_OEXORRSO_V

View Text

SELECT EXP.ROWID ROW_ID
, EXP.TOP_BILL_SEQUENCE_ID
, EXP.BILL_SEQUENCE_ID
, EXP.ORGANIZATION_ID
, EXP.EXPLOSION_TYPE
, EXP.COMPONENT_SEQUENCE_ID
, EXP.COMPONENT_ITEM_ID
, EXP.PLAN_LEVEL
, EXP.EXTENDED_QUANTITY
, EXP.SORT_ORDER
, EXP.CREATION_DATE
, EXP.CREATED_BY
, EXP.LAST_UPDATE_DATE
, EXP.LAST_UPDATED_BY
, EXP.GROUP_ID
, EXP.SESSION_ID
, EXP.SELECT_FLAG
, EXP.SELECT_QUANTITY
, EXP.TOP_ITEM_ID
, EXP.CONTEXT
, EXP.HEADER_ID
, EXP.LINE_ID
, EXP.COMPONENT_QUANTITY
, EXP.SO_TRANSACTIONS_FLAG
, EXP.COMPONENT_CODE
, MSI.RESERVABLE_TYPE
, MSI.DESCRIPTION ITEM_DESCRIPTION
, DECODE(MSI.RESERVABLE_TYPE
, 1
, 'Y'
, 'N' ) RESERVABLE_FLAG
, DECODE (MSI.ATP_FLAG
, 'N'
, MSI.ATP_FLAG
, DECODE(BIC.CHECK_ATP
, '1'
, 'Y'
, 'N' )) ATP_FLAG
, EXP.PRIMARY_UOM_CODE
, DECODE(EXP.REQUIRED_FOR_REVENUE
, 1
, 'Y'
, 'N' ) REQUIRED_FOR_REVENUE_FLAG
, OE_QUERY.II_RESERVED_QUANTITY(EXP.LINE_ID
, EXP.COMPONENT_CODE) RESERVED_QUANTITY
, OE_QUERY.II_RELEASED_QUANTITY(EXP.LINE_ID
, EXP.COMPONENT_CODE) RELEASED_QUANTITY
, OE_QUERY.II_SCHEDULE_STATUS_CODE(EXP.LINE_ID
, EXP.COMPONENT_CODE) SCHEDULE_STATUS_CODE
, SOL.MEANING SCHEDULE_STATUS
FROM BOM_CONFIG_EXPLOSIONS EXP
, MTL_SYSTEM_ITEMS_VL MSI
, BOM_INVENTORY_COMPONENTS BIC
, SO_LOOKUPS SOL
WHERE EXP.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND NVL(EXP.ORGANIZATION_ID
, TO_NUMBER(FND_PROFILE.VALUE( 'SO_ORGANIZATION_ID'))) = MSI.ORGANIZATION_ID (+)
AND EXP.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID (+)
AND SOL.LOOKUP_TYPE (+) = 'SCHEDULE STATUS'
AND SOL.LOOKUP_CODE (+) = OE_QUERY.II_SCHEDULE_STATUS_CODE (EXP.LINE_ID
, EXP.COMPONENT_CODE)

Columns