MSC_AP_WIP_FS_COMP_DEMANDS

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
FS_WD_HEADER_ID FS_WD_OP_MATERIAL_ID ASSEMBLY_NAME COMPONENT_NAME ORGANIZATION_CODE ASSEMBLY_ITEM_ID COMPONENT_ITEM_ID ORGANIZATION_ID QUANTITY_PER_PRODUCT UOM_CODE BASIS_TYPE YIELD_FACTOR SUPPLY_TYPE WD_OPERATION_ID WORK_DEFINITION_CODE WORK_DEFINITION_ID OPERATION_SEQ_NUMBER OP_EFFECTIVE_FROM_DATE

Name

FS_WD_HEADER_ID

FS_WD_OP_MATERIAL_ID

ASSEMBLY_NAME

COMPONENT_NAME

ORGANIZATION_CODE

ASSEMBLY_ITEM_ID

COMPONENT_ITEM_ID

ORGANIZATION_ID

QUANTITY_PER_PRODUCT

UOM_CODE

BASIS_TYPE

YIELD_FACTOR

SUPPLY_TYPE

WD_OPERATION_ID

WORK_DEFINITION_CODE

WORK_DEFINITION_ID

OPERATION_SEQ_NUMBER

OP_EFFECTIVE_FROM_DATE

Query

SQL_Statement
SELECT FS.FS_WD_HEADER_ID, FS.FS_WD_OP_MATERIAL_ID, EGPITEM.ITEM_NUMBER ASSEMBLY_NAME, EGPITEM2.ITEM_NUMBER COMPONENT_NAME, INVORG.ORGANIZATION_CODE, FSHD.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID, FS.INVENTORY_ITEM_ID COMPONENT_ITEM_ID, FS.ORGANIZATION_ID, FS.QUANTITY_PER_PRODUCT, FS.UOM_CODE, FS.BASIS_TYPE, FS.YIELD_FACTOR, FS.SUPPLY_TYPE, FS.WD_OPERATION_ID, WD.WORK_DEFINITION_CODE, FSHD.WORK_DEFINITION_ID, WDOP.OPERATION_SEQ_NUMBER, WDOP.EFFECTIVE_FROM_DATE OP_EFFECTIVE_FROM_DATE FROM WIE_FS_WD_OP_MATERIALS FS , WIE_FS_WD_HEADERS FSHD , WIS_WORK_DEFINITIONS_V WD , WIS_WD_OPERATIONS_B WDOP , EGP_SYSTEM_ITEMS_B EGPITEM , EGP_SYSTEM_ITEMS_B EGPITEM2 , INV_ORG_PARAMETERS INVORG WHERE FSHD.FS_WD_HEADER_ID(+) = FS.FS_WD_HEADER_ID AND WD.WORK_DEFINITION_ID(+) = FSHD.WORK_DEFINITION_ID AND WD.USED_IN_PLANNING_FLAG(+) = 'Y' AND WD.WORK_METHOD_CODE(+) = 'FLOW_MANUFACTURING' AND WD.STATUS_CODE(+) IN ('ACTIVE', 'PENDING_INACTIVE') AND EGPITEM.INVENTORY_ITEM_ID(+) = FSHD.INVENTORY_ITEM_ID AND EGPITEM.ORGANIZATION_ID(+) = FSHD.ORGANIZATION_ID AND EGPITEM2.INVENTORY_ITEM_ID(+) = FS.INVENTORY_ITEM_ID AND EGPITEM2.ORGANIZATION_ID(+) = FS.ORGANIZATION_ID AND INVORG.ORGANIZATION_ID(+) = FS.ORGANIZATION_ID AND WDOP.WD_OPERATION_ID(+) = FS.WD_OPERATION_ID

SQL_Statement

SELECT

FS.FS_WD_HEADER_ID,

FS.FS_WD_OP_MATERIAL_ID,

EGPITEM.ITEM_NUMBER ASSEMBLY_NAME,

EGPITEM2.ITEM_NUMBER COMPONENT_NAME,

INVORG.ORGANIZATION_CODE,

FSHD.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,

FS.INVENTORY_ITEM_ID COMPONENT_ITEM_ID,

FS.ORGANIZATION_ID,

FS.QUANTITY_PER_PRODUCT,

FS.UOM_CODE,

FS.BASIS_TYPE,

FS.YIELD_FACTOR,

FS.SUPPLY_TYPE,

FS.WD_OPERATION_ID,

WD.WORK_DEFINITION_CODE,

FSHD.WORK_DEFINITION_ID,

WDOP.OPERATION_SEQ_NUMBER,

WDOP.EFFECTIVE_FROM_DATE OP_EFFECTIVE_FROM_DATE

FROM

WIE_FS_WD_OP_MATERIALS FS ,

WIE_FS_WD_HEADERS FSHD ,

WIS_WORK_DEFINITIONS_V WD ,

WIS_WD_OPERATIONS_B WDOP ,

EGP_SYSTEM_ITEMS_B EGPITEM ,

EGP_SYSTEM_ITEMS_B EGPITEM2 ,

INV_ORG_PARAMETERS INVORG

WHERE FSHD.FS_WD_HEADER_ID(+) = FS.FS_WD_HEADER_ID

AND WD.WORK_DEFINITION_ID(+) = FSHD.WORK_DEFINITION_ID

AND WD.USED_IN_PLANNING_FLAG(+) = 'Y'

AND WD.WORK_METHOD_CODE(+) = 'FLOW_MANUFACTURING'

AND WD.STATUS_CODE(+) IN ('ACTIVE', 'PENDING_INACTIVE')

AND EGPITEM.INVENTORY_ITEM_ID(+) = FSHD.INVENTORY_ITEM_ID

AND EGPITEM.ORGANIZATION_ID(+) = FSHD.ORGANIZATION_ID

AND EGPITEM2.INVENTORY_ITEM_ID(+) = FS.INVENTORY_ITEM_ID

AND EGPITEM2.ORGANIZATION_ID(+) = FS.ORGANIZATION_ID

AND INVORG.ORGANIZATION_ID(+) = FS.ORGANIZATION_ID

AND WDOP.WD_OPERATION_ID(+) = FS.WD_OPERATION_ID