VIEW: APPS.SO_INCLUDED_ITEMS_OEXORRSO_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)