INV_ALM_INTERFACE_ERRORS_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name
TRANSACTION_ID INVENTORY_ITEM_ID ORGANIZATION_ID REVISION SUBINVENTORY_CODE LOCATOR_ID TRANSACTION_TYPE_ID TRANSACTION_ACTION_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_QUANTITY TRANSACTION_UOM PRIMARY_QUANTITY TRANSACTION_DATE TRANSFER_ORGANIZATION_ID TRANSFER_SUBINVENTORY TRANSFER_LOCATOR_ID RCV_TRANSACTION_ID ALM_INTERFACE_STATUS ALM_INTERFACE_ERROR_CODE

Query

SQL_Statement

SELECT INV_MATERIAL_TXNS.TRANSACTION_ID, INV_MATERIAL_TXNS.INVENTORY_ITEM_ID, INV_MATERIAL_TXNS.ORGANIZATION_ID, INV_MATERIAL_TXNS.REVISION, INV_MATERIAL_TXNS.SUBINVENTORY_CODE, INV_MATERIAL_TXNS.LOCATOR_ID, INV_MATERIAL_TXNS.TRANSACTION_TYPE_ID, INV_MATERIAL_TXNS.TRANSACTION_ACTION_ID, INV_MATERIAL_TXNS.TRANSACTION_SOURCE_TYPE_ID, INV_MATERIAL_TXNS.TRANSACTION_QUANTITY, INV_MATERIAL_TXNS.TRANSACTION_UOM, INV_MATERIAL_TXNS.PRIMARY_QUANTITY, INV_MATERIAL_TXNS.TRANSACTION_DATE, INV_MATERIAL_TXNS.TRANSFER_ORGANIZATION_ID, INV_MATERIAL_TXNS.TRANSFER_SUBINVENTORY, INV_MATERIAL_TXNS.TRANSFER_LOCATOR_ID, INV_MATERIAL_TXNS.RCV_TRANSACTION_ID, INV_MATERIAL_TXNS.ALM_INTERFACE_STATUS, INV_MATERIAL_TXNS.ALM_INTERFACE_ERROR_CODE FROM INV_MATERIAL_TXNS WHERE ALM_INTERFACE_STATUS = 'ORA_P'