[Home] [Help] [Dependency Information]
Object Name: | WIP_BIS_SCRAP_REASONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIP_BIS_SCRAP_REASONS_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Shows the assemblies which were scrapped, the quantity
scrapped, and the reason code for the scrapped quantity
on a given date (grouped by reason.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
TRANSACTION_DATE | DATE | Yes | Transaction Date | |
REASON | VARCHAR2 | (4000) | Reason | |
ITEM_NUMBER | VARCHAR2 | (40) | Item Number | |
ITEM_UOM | VARCHAR2 | (3) | Item UOM | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
QTY_SCRAPPED | NUMBER | Scrapped Quantity |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, TRANSACTION_DATE
, REASON
, ITEM_NUMBER
, ITEM_UOM
, ITEM_DESCRIPTION
, QTY_SCRAPPED
FROM APPS.WIP_BIS_SCRAP_REASONS_V;
APPS.WIP_BIS_SCRAP_REASONS_V is not referenced by any database object
|
|
|