VIEW: APPS.EAM_REQUIREMENT_OPERATIONS_V

Source

View Text - Preformatted

SELECT wrov.ROW_ID, wrov.INVENTORY_ITEM_ID, wrov.CONCATENATED_SEGMENTS, wrov.ITEM_DESCRIPTION, wrov.ITEM_PRIMARY_UOM_CODE, wrov.INVENTORY_ASSET_FLAG, wrov.LOCATION_CONTROL_CODE, wrov.RESTRICT_SUBINVENTORIES_CODE, wrov.RESTRICT_LOCATORS_CODE, wrov.ORGANIZATION_ID, wrov.WIP_ENTITY_ID, wrov.OPERATION_SEQ_NUM, wrov.REPETITIVE_SCHEDULE_ID, wrov.LINE_ID, wrov.LAST_UPDATE_DATE, wrov.LAST_UPDATED_BY, wrov.CREATION_DATE, wrov.CREATED_BY, wrov.LAST_UPDATE_LOGIN, wrov.REQUEST_ID, wrov.PROGRAM_APPLICATION_ID, wrov.PROGRAM_ID, wrov.PROGRAM_UPDATE_DATE, wrov.DEPARTMENT_ID, wrov.DEPARTMENT_CODE, wrov.WIP_SUPPLY_TYPE, wrov.WIP_SUPPLY_MEANING, wrov.DATE_REQUIRED, wrov.REQUIRED_QUANTITY, wrov.QUANTITY_ISSUED, wrov.QUANTITY_OPEN, wrov.QUANTITY_PER_ASSEMBLY, wrov.COMMENTS, wrov.SUPPLY_SUBINVENTORY, wrov.SUPPLY_LOCATOR_ID, wrov.MRP_NET_FLAG, wrov.MPS_REQUIRED_QUANTITY, wrov.MPS_DATE_REQUIRED, wrov.ROUTING_EXISTS_FLAG, wrov.FIRST_UNIT_START_DATE, wrov.FIRST_UNIT_COMPLETION_DATE, wrov.LAST_UNIT_COMPLETION_DATE, wrov.ATTRIBUTE_CATEGORY, wrov.ATTRIBUTE1, wrov.ATTRIBUTE2, wrov.ATTRIBUTE3, wrov.ATTRIBUTE4, wrov.ATTRIBUTE5, wrov.ATTRIBUTE6, wrov.ATTRIBUTE7, wrov.ATTRIBUTE8, wrov.ATTRIBUTE9, wrov.ATTRIBUTE10, wrov.ATTRIBUTE11, wrov.ATTRIBUTE12, wrov.ATTRIBUTE13, wrov.ATTRIBUTE14, wrov.ATTRIBUTE15, eam_material_allocqty_pkg.allocated_quantity(wrov.wip_entity_id, wrov.operation_seq_num,wrov.organization_id,wrov.inventory_item_id), wrov.AUTO_REQUEST_MATERIAL, wrov.RELEASED_QUANTITY, wro.suggested_vendor_name, wro.vendor_id, wro.unit_price, msi.stock_enabled_flag from wip_requirement_operations_v wrov, wip_requirement_operations wro, mtl_system_items msi WHERE wrov.row_id = wro.rowid and wro.organization_id = msi.organization_id and wro.inventory_item_id = msi.inventory_item_id

View Text - HTML Formatted

SELECT WROV.ROW_ID
, WROV.INVENTORY_ITEM_ID
, WROV.CONCATENATED_SEGMENTS
, WROV.ITEM_DESCRIPTION
, WROV.ITEM_PRIMARY_UOM_CODE
, WROV.INVENTORY_ASSET_FLAG
, WROV.LOCATION_CONTROL_CODE
, WROV.RESTRICT_SUBINVENTORIES_CODE
, WROV.RESTRICT_LOCATORS_CODE
, WROV.ORGANIZATION_ID
, WROV.WIP_ENTITY_ID
, WROV.OPERATION_SEQ_NUM
, WROV.REPETITIVE_SCHEDULE_ID
, WROV.LINE_ID
, WROV.LAST_UPDATE_DATE
, WROV.LAST_UPDATED_BY
, WROV.CREATION_DATE
, WROV.CREATED_BY
, WROV.LAST_UPDATE_LOGIN
, WROV.REQUEST_ID
, WROV.PROGRAM_APPLICATION_ID
, WROV.PROGRAM_ID
, WROV.PROGRAM_UPDATE_DATE
, WROV.DEPARTMENT_ID
, WROV.DEPARTMENT_CODE
, WROV.WIP_SUPPLY_TYPE
, WROV.WIP_SUPPLY_MEANING
, WROV.DATE_REQUIRED
, WROV.REQUIRED_QUANTITY
, WROV.QUANTITY_ISSUED
, WROV.QUANTITY_OPEN
, WROV.QUANTITY_PER_ASSEMBLY
, WROV.COMMENTS
, WROV.SUPPLY_SUBINVENTORY
, WROV.SUPPLY_LOCATOR_ID
, WROV.MRP_NET_FLAG
, WROV.MPS_REQUIRED_QUANTITY
, WROV.MPS_DATE_REQUIRED
, WROV.ROUTING_EXISTS_FLAG
, WROV.FIRST_UNIT_START_DATE
, WROV.FIRST_UNIT_COMPLETION_DATE
, WROV.LAST_UNIT_COMPLETION_DATE
, WROV.ATTRIBUTE_CATEGORY
, WROV.ATTRIBUTE1
, WROV.ATTRIBUTE2
, WROV.ATTRIBUTE3
, WROV.ATTRIBUTE4
, WROV.ATTRIBUTE5
, WROV.ATTRIBUTE6
, WROV.ATTRIBUTE7
, WROV.ATTRIBUTE8
, WROV.ATTRIBUTE9
, WROV.ATTRIBUTE10
, WROV.ATTRIBUTE11
, WROV.ATTRIBUTE12
, WROV.ATTRIBUTE13
, WROV.ATTRIBUTE14
, WROV.ATTRIBUTE15
, EAM_MATERIAL_ALLOCQTY_PKG.ALLOCATED_QUANTITY(WROV.WIP_ENTITY_ID
, WROV.OPERATION_SEQ_NUM
, WROV.ORGANIZATION_ID
, WROV.INVENTORY_ITEM_ID)
, WROV.AUTO_REQUEST_MATERIAL
, WROV.RELEASED_QUANTITY
, WRO.SUGGESTED_VENDOR_NAME
, WRO.VENDOR_ID
, WRO.UNIT_PRICE
, MSI.STOCK_ENABLED_FLAG
FROM WIP_REQUIREMENT_OPERATIONS_V WROV
, WIP_REQUIREMENT_OPERATIONS WRO
, MTL_SYSTEM_ITEMS MSI
WHERE WROV.ROW_ID = WRO.ROWID
AND WRO.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND WRO.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID