DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.QA_ERES_RCV_TRANS_INTERFACE_V

Object Details
Object Name: QA_ERES_RCV_TRANS_INTERFACE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QA_ERES_RCV_TRANS_INTERFACE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes txn ID
PARENT_TRANSACTION_ID NUMBER

Parent transaction ID
ORGANIZATION_ID NUMBER

org ID
ORGANIZATION_CODE VARCHAR2 (3)
org code
ORGANIZATION_NAME VARCHAR2 (240)
org name
SHIPMENT_HEADER_ID NUMBER

shipment header ID
RECEIPT_NUMBER VARCHAR2 (30)
receipt num
ORDER_TYPE VARCHAR2 (25) Yes order type
SOURCE_DOCUMENT_CODE VARCHAR2 (25)
source document code
ORDER_NUMBER VARCHAR2 (50)
order num
REQUISITION_NUMBER VARCHAR2 (20)
requisition num
ITEM_ID NUMBER

item ID
ITEM VARCHAR2 (40)
item num
ITEM_REVISION VARCHAR2 (3)
item rev
ITEM_DESCRIPTION VARCHAR2 (240)
item description
LOCATION_ID NUMBER

location id
LOCATION VARCHAR2 (60)
location
LOCATION_DESCRIPTION VARCHAR2 (240)
location description
SUBINVENTORY VARCHAR2 (10)
subinventory
LOCATOR_ID NUMBER

locator ID
LOCATOR CHAR (1)
locator
TRANSACTION_QUANTITY NUMBER

txn qty
TRANSACTION_UOM VARCHAR2 (25)
uom
SECONDARY_QUANTITY NUMBER

secondary qty
SECONDARY_UOM VARCHAR2 (25)
secondary uom
DESTINATION_TYPE VARCHAR2 (25)
destination type
RECEIPT_ROUTING_ID NUMBER

receipt routing ID
RECEIPT_ROUTING VARCHAR2 (80)
receipt routing
TRANSACTION_DATE DATE
Yes txn date
SUPPLIER_ID NUMBER

supplier ID
SUPPLIER VARCHAR2 (240)
supplier
SUPPLIER_LOT VARCHAR2 (30)
supplier lot
SUPPLIER_ITEM VARCHAR2 (25)
supplier item
CUSTOMER_ID NUMBER

customer ID
CUSTOMER VARCHAR2 (360)
customer
CUSTOMER_ITEM VARCHAR2 (50)
customer_item
HAZARD_CLASS_ID NUMBER

hazard class ID
HAZARD_CLASS VARCHAR2 (4000)
hazard class
UN_NUMBER_ID NUMBER

UN num ID
UN_NUMBER VARCHAR2 (4000)
UM Num
PROJECT_NUMBER VARCHAR2 (4000)
project
TASK_NUMBER VARCHAR2 (4000)
task
PO_RELEASE_NUMBER NUMBER

PO release
PO_RELEASE_LINE_NUMBER NUMBER

PO release line
SHIPMENT_NUMBER NUMBER

shipment
ORDERED_QUANTITY NUMBER

ordered qty
ORDERED_UOM VARCHAR2 (25)
ordered uom
DUE_DATE DATE

due date
JOB_OR_SCHEDULE VARCHAR2 (240)
job or schedule code
WIP_LINE_NUMBER VARCHAR2 (10)
WIP Line
OPERATION_SEQUENCE NUMBER

Op seq
DEPARTMENT VARCHAR2 (10)
department
KANBAN_NUMBER VARCHAR2 (200)
Kanban num
QA_COLLECTION_ID NUMBER

collection ID
LAST_UPDATE_DATE DATE
Yes standard WHO column
LAST_UPDATED_BY NUMBER
Yes standard WHO column
LAST_UPDATE_LOGIN NUMBER

standard WHO column
CREATION_DATE DATE
Yes standard WHO column
CREATED_BY NUMBER
Yes standard WHO column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      PARENT_TRANSACTION_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      SHIPMENT_HEADER_ID
,      RECEIPT_NUMBER
,      ORDER_TYPE
,      SOURCE_DOCUMENT_CODE
,      ORDER_NUMBER
,      REQUISITION_NUMBER
,      ITEM_ID
,      ITEM
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      LOCATION_ID
,      LOCATION
,      LOCATION_DESCRIPTION
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      DESTINATION_TYPE
,      RECEIPT_ROUTING_ID
,      RECEIPT_ROUTING
,      TRANSACTION_DATE
,      SUPPLIER_ID
,      SUPPLIER
,      SUPPLIER_LOT
,      SUPPLIER_ITEM
,      CUSTOMER_ID
,      CUSTOMER
,      CUSTOMER_ITEM
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      UN_NUMBER_ID
,      UN_NUMBER
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PO_RELEASE_NUMBER
,      PO_RELEASE_LINE_NUMBER
,      SHIPMENT_NUMBER
,      ORDERED_QUANTITY
,      ORDERED_UOM
,      DUE_DATE
,      JOB_OR_SCHEDULE
,      WIP_LINE_NUMBER
,      OPERATION_SEQUENCE
,      DEPARTMENT
,      KANBAN_NUMBER
,      QA_COLLECTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM APPS.QA_ERES_RCV_TRANS_INTERFACE_V;

Dependencies

[top of page]

APPS.QA_ERES_RCV_TRANS_INTERFACE_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
SynonymMTL_CUSTOMER_ITEMS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_KANBAN_CARDS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE
SynonymOE_ORDER_HEADERS
SynonymOE_ORDER_LINES_ALL
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
ViewPO_VENDORS
ViewQA_CUSTOMERS_LOV_V
PL/SQL PackageQA_ERES_PKG - show dependent code
PL/SQL PackageRCV_PROJECT_GRP - show dependent code
ViewRCV_ROUTING_HEADERS
ViewRCV_SHIPMENT_HEADERS_V
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS_INTERFACE
SynonymWIP_ENTITIES
SynonymWIP_LINES

APPS.QA_ERES_RCV_TRANS_INTERFACE_V is not referenced by any database object