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


VIEW: APPS.RCV_VIEW_INTERFACE_V

Object Details
Object Name: RCV_VIEW_INTERFACE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.RCV_VIEW_INTERFACE_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
RCV_TRANSACTION_ID NUMBER
Yes
TRANSACTION_TYPE VARCHAR2 (25) Yes
TRANSACTION_DATE DATE
Yes
QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
SHIPMENT_HEADER_ID NUMBER

SHIPMENT_LINE_ID NUMBER

SOURCE_DOCUMENT_CODE VARCHAR2 (25)
DESTINATION_TYPE_CODE VARCHAR2 (25)
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
GRANDPARENT_TRANSACTION_ID NUMBER

PO_HEADER_ID NUMBER

PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

PO_REVISION_NUM NUMBER

REQ_LINE_ID NUMBER

PO_UNIT_PRICE NUMBER

CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_DATE DATE

ROUTING_ID NUMBER

ROUTING_STEP_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

ORGANIZATION_ID NUMBER

SUBINVENTORY VARCHAR2 (10)
LOCATOR_ID NUMBER

LOCATION_ID NUMBER

RECEIPT_EXCEPTION_FLAG VARCHAR2 (1)
INSPECTION_STATUS_CODE VARCHAR2 (25)
VENDOR_LOT_NUM VARCHAR2 (30)
COMMENTS VARCHAR2 (240)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQ_DISTRIBUTION_ID NUMBER

REASON_ID NUMBER

DESTINATION_CONTEXT VARCHAR2 (30)
SOURCE_DOC_UNIT_OF_MEASURE VARCHAR2 (25)
TRANSACTION_TYPE_DSP VARCHAR2 (80) Yes
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
REQ_HEADER_ID NUMBER

RECEIPT_NUM VARCHAR2 (30)
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
RCV_LINE_NUMBER NUMBER

PACKING_SLIP VARCHAR2 (25)
ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
CATEGORY_ID NUMBER

ITEM_REVISION VARCHAR2 (3)
RECEIPT_SOURCE_CODE VARCHAR2 (25)
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

REVISION_QTY_CONTROL_CODE NUMBER

LOT_CONTROL_CODE NUMBER

SHELF_LIFE_CODE NUMBER

SHELF_LIFE_DAYS NUMBER

ITEM_ORGANIZATION_ID NUMBER

INSPECTION_RESULT_DSP VARCHAR2 (80)
PO_NUMBER VARCHAR2 (30)
PO_LINE_NUMBER VARCHAR2 (40)
PO_SHIPMENT_NUMBER NUMBER

PO_RELEASE_NUMBER VARCHAR2 (40)
HAZARD_CLASS_ID VARCHAR2 (40)
UN_NUMBER_ID VARCHAR2 (40)
VENDOR VARCHAR2 (240)
ORDER_TYPE VARCHAR2 (80)
NOTE_TO_RECEIVER VARCHAR2 (480)
INV_REQ_NOTE_TO_RECEIVER VARCHAR2 (4000)
DESTINATION_TYPE_DSP VARCHAR2 (80)
LOCATION VARCHAR2 (60)
BILL_OF_LADING VARCHAR2 (25)
FREIGHT_CARRIER VARCHAR2 (25)
WAYBILL_AIRBILL_NUM VARCHAR2 (20)
VENDOR_ITEM_NUMBER VARCHAR2 (25)
ROUTING_NAME VARCHAR2 (80)
ORDERED_QTY NUMBER

ORDERED_UOM VARCHAR2 (25)
DUE_DATE_VENDOR DATE

DUE_DATE_INTERNAL DATE

REASON_CODE VARCHAR2 (30)
PERSON VARCHAR2 (240)
WIP_ENTITY_ID NUMBER

WIP_LINE_ID NUMBER

WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP_OPERATION_SEQ_NUM NUMBER

WIP_RESOURCE_SEQ_NUM NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
BOM_RESOURCE_ID NUMBER

QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
MOVEMENT_ID NUMBER

INSPECTION_QUALITY_CODE VARCHAR2 (25)
SUBSTITUTE_UNORDERED_CODE VARCHAR2 (25)
TRANSACTION_STATUS_DSP VARCHAR2 (80) Yes
PROCESSING_MODE_DSP VARCHAR2 (80) Yes
QA_COLLECTION_ID NUMBER

EMPLOYEE_ID NUMBER (9)
OE_ORDER_HEADER_ID NUMBER

OE_ORDER_NUM NUMBER

OE_ORDER_LINE_ID NUMBER

OE_ORDER_LINE_NUM NUMBER

CUSTOMER_ID NUMBER

CUSTOMER VARCHAR2 (360)
CUSTOMER_SITE_ID NUMBER

DUE_DATE_CUSTOMER DATE

SECONDARY_QUANTITY NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
SECONDARY_ORDERED_QTY NUMBER

SECONDARY_ORDERED_UOM VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
MATCHING_BASIS VARCHAR2 (30)
AMOUNT NUMBER

CURRENCY_NAME VARCHAR2 (80)
JOB_NAME VARCHAR2 (700)
JOB_DESCRIPTION VARCHAR2 (240)
ORG_ID NUMBER

Organization identifier
LCM_SHIPMENT_LINE_ID NUMBER

Added for LCM-RCV Integration project
UNIT_LANDED_COST NUMBER

Added for LCM-RCV Integration project
PROCESSING_STATUS_CODE VARCHAR2 (25) Yes Processing status code for Interface row.
Query Text

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


SELECT ROW_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      RCV_TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      QUANTITY
,      UNIT_OF_MEASURE
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      SOURCE_DOCUMENT_CODE
,      DESTINATION_TYPE_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      GRANDPARENT_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_REVISION_NUM
,      REQ_LINE_ID
,      PO_UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ROUTING_ID
,      ROUTING_STEP_ID
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORGANIZATION_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATION_ID
,      RECEIPT_EXCEPTION_FLAG
,      INSPECTION_STATUS_CODE
,      VENDOR_LOT_NUM
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQ_DISTRIBUTION_ID
,      REASON_ID
,      DESTINATION_CONTEXT
,      SOURCE_DOC_UNIT_OF_MEASURE
,      TRANSACTION_TYPE_DSP
,      GOVERNMENT_CONTEXT
,      USSGL_TRANSACTION_CODE
,      REQ_HEADER_ID
,      RECEIPT_NUM
,      RCV_SHIPMENT_NUMBER
,      RCV_LINE_NUMBER
,      PACKING_SLIP
,      ITEM_ID
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      ITEM_REVISION
,      RECEIPT_SOURCE_CODE
,      ITEM_ALLOWED_UNITS_LOOKUP_CODE
,      SERIAL_NUMBER_CONTROL_CODE
,      REVISION_QTY_CONTROL_CODE
,      LOT_CONTROL_CODE
,      SHELF_LIFE_CODE
,      SHELF_LIFE_DAYS
,      ITEM_ORGANIZATION_ID
,      INSPECTION_RESULT_DSP
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
,      PO_RELEASE_NUMBER
,      HAZARD_CLASS_ID
,      UN_NUMBER_ID
,      VENDOR
,      ORDER_TYPE
,      NOTE_TO_RECEIVER
,      INV_REQ_NOTE_TO_RECEIVER
,      DESTINATION_TYPE_DSP
,      LOCATION
,      BILL_OF_LADING
,      FREIGHT_CARRIER
,      WAYBILL_AIRBILL_NUM
,      VENDOR_ITEM_NUMBER
,      ROUTING_NAME
,      ORDERED_QTY
,      ORDERED_UOM
,      DUE_DATE_VENDOR
,      DUE_DATE_INTERNAL
,      REASON_CODE
,      PERSON
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      DEPARTMENT_CODE
,      BOM_RESOURCE_ID
,      QTY_RCV_EXCEPTION_CODE
,      MOVEMENT_ID
,      INSPECTION_QUALITY_CODE
,      SUBSTITUTE_UNORDERED_CODE
,      TRANSACTION_STATUS_DSP
,      PROCESSING_MODE_DSP
,      QA_COLLECTION_ID
,      EMPLOYEE_ID
,      OE_ORDER_HEADER_ID
,      OE_ORDER_NUM
,      OE_ORDER_LINE_ID
,      OE_ORDER_LINE_NUM
,      CUSTOMER_ID
,      CUSTOMER
,      CUSTOMER_SITE_ID
,      DUE_DATE_CUSTOMER
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_ORDERED_QTY
,      SECONDARY_ORDERED_UOM
,      QC_GRADE
,      MATCHING_BASIS
,      AMOUNT
,      CURRENCY_NAME
,      JOB_NAME
,      JOB_DESCRIPTION
,      ORG_ID
,      LCM_SHIPMENT_LINE_ID
,      UNIT_LANDED_COST
,      PROCESSING_STATUS_CODE
FROM APPS.RCV_VIEW_INTERFACE_V;

Dependencies

[top of page]

APPS.RCV_VIEW_INTERFACE_V references the following:

SchemaAPPS
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
ViewOE_SOLD_TO_ORGS_V
SynonymOE_TRANSACTION_TYPES_ALL
SynonymOE_TRANSACTION_TYPES_TL
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPER_ALL_PEOPLE_F
SynonymPER_JOBS
SynonymPO_HEADERS_ALL
ViewPO_JOB_ASSOCIATIONS
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_LINES
ViewPO_VENDORS
ViewRCV_ROUTING_HEADERS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS_INTERFACE

APPS.RCV_VIEW_INTERFACE_V is not referenced by any database object