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


VIEW: APPS.RCV_RECEIPTS_PRINT_INV

Object Details
Object Name: RCV_RECEIPTS_PRINT_INV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.RCV_RECEIPTS_PRINT_INV
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
ITEM_ID NUMBER


ABC_CODE CHAR (0)

ORGANIZATION_ID NUMBER


REVISION_NUM VARCHAR2 (3)

CATEGORY_ID NUMBER


ITEM_DESCRIPTION VARCHAR2 (240)

UN_NUM CHAR (0)

UN_DESCRIPTION CHAR (0)

HAZARD_CLASS CHAR (0)

ROUTING_NAME VARCHAR2 (80)

DOCUMENT_TYPE_CODE VARCHAR2 (80)

DOCUMENT_NUMBER VARCHAR2 (30)

RELEASE_NUM NUMBER


LINE_NUM NUMBER


BUYER_PREPARER_NAME CHAR (0)

SOURCE_TYPE VARCHAR2 (80)

SOURCE VARCHAR2 (240)

SOURCE_UNIT_OF_MEASURE VARCHAR2 (25)

VENDOR_PRODUCT_NUM VARCHAR2 (25)

DUE_DATE DATE


QUANTITY_ORDERED NUMBER


NOTE_TO_RECEIVER CHAR (0)

RECEIPT_NUM VARCHAR2 (30)

RECEIPT_UNIT_OF_MEASURE VARCHAR2 (25)

RECEIPT_DATE DATE


RECEIPT_LOCATION VARCHAR2 (60)

RECEIVER_FIRST_NAME VARCHAR2 (150)

RECEIVER_LAST_NAME VARCHAR2 (150)

FREIGHT_CARRIER VARCHAR2 (25)

QUANTITY_RECEIVED NUMBER


PRIMARY_QUANTITY NUMBER


QUANTITY_REMAINING NUMBER


SHIPMENT_NUM VARCHAR2 (30)

BILL_OF_LADING VARCHAR2 (25)

VENDOR_LOT_NUM VARCHAR2 (30)

PACKING_SLIP_NUM VARCHAR2 (25)

CONTAINERS NUMBER


RECEIVER_COMMENT VARCHAR2 (4000)

TRANSACTION_TYPE CHAR (10)

TRANSACTION_ID NUMBER


GROUP_ID NUMBER


SHIPMENT_HEADER_ID NUMBER


SHIPMENT_LINE_ID NUMBER


DISTRIBUTION_ID NUMBER


PO_HEADER_ID NUMBER


PO_LINE_ID NUMBER


PO_LINE_LOCATION_ID NUMBER


REQUISITION_HEADER_ID NUMBER


REQUISITION_LINE_ID NUMBER


FROM_INTERFACE CHAR (1)

DELIVER_TO_LOCATION VARCHAR2 (60)

PLL_NOTE_TO_RECEIVER CHAR (0)
RECEIVING_SUBINVENTORY VARCHAR2 (10)
LOCATOR_ID NUMBER

LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number in which the material was received or delivered.
TRANSFER_LICENSE_PLATE_NUMBER VARCHAR2 (30)
Transfer License Plate Number in which the material was received or delivered.
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT ITEM_ID
,      ABC_CODE
,      ORGANIZATION_ID
,      REVISION_NUM
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UN_NUM
,      UN_DESCRIPTION
,      HAZARD_CLASS
,      ROUTING_NAME
,      DOCUMENT_TYPE_CODE
,      DOCUMENT_NUMBER
,      RELEASE_NUM
,      LINE_NUM
,      BUYER_PREPARER_NAME
,      SOURCE_TYPE
,      SOURCE
,      SOURCE_UNIT_OF_MEASURE
,      VENDOR_PRODUCT_NUM
,      DUE_DATE
,      QUANTITY_ORDERED
,      NOTE_TO_RECEIVER
,      RECEIPT_NUM
,      RECEIPT_UNIT_OF_MEASURE
,      RECEIPT_DATE
,      RECEIPT_LOCATION
,      RECEIVER_FIRST_NAME
,      RECEIVER_LAST_NAME
,      FREIGHT_CARRIER
,      QUANTITY_RECEIVED
,      PRIMARY_QUANTITY
,      QUANTITY_REMAINING
,      SHIPMENT_NUM
,      BILL_OF_LADING
,      VENDOR_LOT_NUM
,      PACKING_SLIP_NUM
,      CONTAINERS
,      RECEIVER_COMMENT
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      GROUP_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      FROM_INTERFACE
,      DELIVER_TO_LOCATION
,      PLL_NOTE_TO_RECEIVER
,      RECEIVING_SUBINVENTORY
,      LOCATOR_ID
,      LICENSE_PLATE_NUMBER
,      TRANSFER_LICENSE_PLATE_NUMBER
,      ORG_ID
FROM APPS.RCV_RECEIPTS_PRINT_INV;

Dependencies

[top of page]

APPS.RCV_RECEIPTS_PRINT_INV references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_PEOPLE_F
ViewPO_LOOKUP_CODES
ViewRCV_ROUTING_HEADERS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS
SynonymRCV_TRANSACTIONS_INTERFACE
SynonymWMS_LICENSE_PLATE_NUMBERS

APPS.RCV_RECEIPTS_PRINT_INV is not referenced by any database object