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

VIEW: APPS.CSP_RECEIVING_LINES_V

Object Details
Object Name: CSP_RECEIVING_LINES_V
Object Type: VIEW
Owner: APPS
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
SOURCE_TYPE VARCHAR2 (30)
Source type
HEADER_ID NUMBER

Header identifier
LINE_ID NUMBER

Line identifier
ORGANIZATION_ID NUMBER

Organization identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory name
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ITEM_NUMBER VARCHAR2 (40)
Item number
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial number control code
REVISION_QTY_CONTROL_CODE NUMBER

Revision control code
SERIAL_NUMBER VARCHAR2 (30)
Serial number
REVISION VARCHAR2 (3)
Revision
UOM_CODE VARCHAR2 (25)
Unit of measure
ORDER_QUANTITY NUMBER

Order quantity
BALANCE_DUE NUMBER

Balance due
SHIP_QUANTITY NUMBER

Shipped quantity
REQ_LINE_DETAIL_ID NUMBER (38)
Requirement line detail identifier
PACKLIST_LINE_ID NUMBER

Packlist line identifier
TRANSACTION_TEMP_ID NUMBER

Transaction temporary identifier
SHIPMENT_NUMBER VARCHAR2 (30)
Shipment number
SHIPMENT_LINE_NUM NUMBER

Shipment line number
SHIPMENT_LINE_ID NUMBER

Shipment line identifier
Query Text

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


SELECT SOURCE_TYPE
,      HEADER_ID
,      LINE_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER_CONTROL_CODE
,      REVISION_QTY_CONTROL_CODE
,      SERIAL_NUMBER
,      REVISION
,      UOM_CODE
,      ORDER_QUANTITY
,      BALANCE_DUE
,      SHIP_QUANTITY
,      REQ_LINE_DETAIL_ID
,      PACKLIST_LINE_ID
,      TRANSACTION_TEMP_ID
,      SHIPMENT_NUMBER
,      SHIPMENT_LINE_NUM
,      SHIPMENT_LINE_ID
FROM APPS.CSP_RECEIVING_LINES_V;

Dependencies

[top of page]

APPS.CSP_RECEIVING_LINES_V references the following:

SchemaAPPS
ViewCSP_RECV_PARTS_V
SynonymCSP_REQ_LINE_DETAILS
PL/SQL PackageCSP_TRANSACTIONS_PUB - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_RESERVATIONS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_TXN_REQUEST_LINES
SynonymOE_ORDER_LINES_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymRCV_SERIALS_SUPPLY
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
TYPESYS_PLSQL_6985A3A1_924_1
APPS.CSP_RECEIVING_LINES_V is referenced by following:

SchemaAPPS
Package BodyCSM_MULTI_MOBQRY_PKG - show dependent code
Package BodyCSM_ORDERS_PKG - show dependent code