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


VIEW: APPS.CSP_RECEIVE_LINES_V

Object Details
Object Name: CSP_RECEIVE_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
DOC_TYPE VARCHAR2 (80)
Document type
DOC_TYPE_CODE VARCHAR2 (30)
Document type code
SOURCE_TYPE_CODE VARCHAR2 (8)
Source type code
RECEIPT_SOURCE_CODE VARCHAR2 (14)
Receipt source code
ORDER_TYPE_CODE VARCHAR2 (25)
Order type code
ORDER_TYPE CHAR (0)
Order type
PO_HEADER_ID NUMBER

PO Header identifier
PO_NUMBER VARCHAR2 (20)
PO Number
PO_LINE_ID NUMBER

PO Line identifier
PO_LINE_NUMBER NUMBER

PO Line number
PO_LINE_LOCATION_ID NUMBER

PO Line location identifier
PO_SHIPMENT_NUMBER NUMBER

PO Shipment number
PO_RELEASE_ID NUMBER

PO Release identifier
PO_RELEASE_NUMBER NUMBER

PO Release number
REQ_HEADER_ID NUMBER

Requisition header identifier
REQ_NUMBER VARCHAR2 (20)
Requisition number
REQ_LINE_ID NUMBER

Requisition line identifier
REQ_LINE NUMBER

Requisition line
REQ_DISTRIBUTION_ID NUMBER

Requisition distribution identifier
RCV_SHIPMENT_HEADER_ID NUMBER

Receive shipment header identifier
RCV_SHIPMENT_NUMBER VARCHAR2 (30)
Receive shipment number
RCV_SHIPMENT_LINE_ID NUMBER

Receive shipment line identifier
RCV_LINE_NUMBER NUMBER

Receive line number
FROM_ORGANIZATION_ID NUMBER

From organization identifier
TO_ORGANIZATION_ID NUMBER

To organization identifier
VENDOR_ID NUMBER

Vendor identifier
VENDOR_SITE_ID NUMBER

Vendor site identifier
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)
Outside operation flag
ITEM_ID NUMBER

Item identifier
UOM_CODE VARCHAR2 (0)
Unit of measure code
PRIMARY_UOM VARCHAR2 (25)
Primary unit of measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary unit of measure class
ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER

Item allowed units lookup code
ITEM_LOCATOR_CONTROL NUMBER

Item locator control
RESTRICT_LOCATORS_CODE VARCHAR2 (1)
Restric locators code
RESTRICT_SUBINVENTORIES_CODE VARCHAR2 (1)
Restrice subinventories code
SHELF_LIFE_CODE NUMBER

Shelf life code
SHELF_LIFE_DAYS NUMBER

Shelf life days
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial number control code
LOT_CONTROL_CODE NUMBER

Lot control code
ITEM_REV_CONTROL_FLAG_TO VARCHAR2 (1)
Item revision control flag
ITEM_REV_CONTROL_FLAG_FROM VARCHAR2 (1)
Item revision control flag
ITEM_NUMBER VARCHAR2 (40)
Item number
ITEM_REVISION VARCHAR2 (3)
Item revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
ITEM_CATEGORY_ID NUMBER

Item category identifier
HAZARD_CLASS CHAR (0)
Hazard class
UN_NUMBER CHAR (0)
UN Number
VENDOR_ITEM_NUMBER VARCHAR2 (25)
Vendor item number
SHIP_TO_LOCATION_ID NUMBER

Ship to location identifier
SHIP_TO_LOCATION CHAR (0)
Ship to location
PACKING_SLIP VARCHAR2 (25)
Packing slip
ROUTING_ID NUMBER

Routing identifier
ROUTING_NAME CHAR (0)
Routing name
NEED_BY_DATE DATE

Need by date
EXPECTED_RECEIPT_DATE DATE

Expected receipt date
ORDERED_QTY NUMBER

Ordered quantity
ORDERED_UOM VARCHAR2 (25)
Ordered unit of measure
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
Government context
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection required flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt required flag
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce ship to location code
UNIT_PRICE NUMBER

Unit Price
CURRENCY_CODE VARCHAR2 (15)
Currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency converion type
CURRENCY_CONVERSION_DATE DATE

Currency converion date
CURRENCY_CONVERSION_RATE NUMBER

Currency converion rate
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to receiver
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type code
DELIVER_TO_PERSON_ID NUMBER (9)
Deliver to person identifier
DELIVER_TO_LOCATION_ID NUMBER

Deliver to location identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination subinventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment Column
CLOSED_CODE VARCHAR2 (30)
Closed code
ASN_TYPE VARCHAR2 (0)
ASN Type
BILL_OF_LADING VARCHAR2 (25)
Bill of lading
SHIPPED_DATE DATE

Shipped date
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight carrier code
WAYBILL_AIRBILL_NUM VARCHAR2 (30)
Waybill number
FREIGHT_BILL_NUM VARCHAR2 (35)
Freight bill number
VENDOR_LOT_NUM VARCHAR2 (30)
Vendor lot number
CONTAINER_NUM VARCHAR2 (35)
Container number
TRUCK_NUM VARCHAR2 (35)
Truck number
BAR_CODE_LABEL VARCHAR2 (35)
Bar code label
RATE_TYPE_DISPLAY VARCHAR2 (0)
Rate type display
MATCH_OPTION VARCHAR2 (25)
Match option
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of origin code
OE_ORDER_HEADER_ID NUMBER

Order header identifier
OE_ORDER_NUM NUMBER

Order number
OE_ORDER_LINE_ID NUMBER

Order line identifier
OE_ORDER_LINE_NUM NUMBER

Order line number
CUSTOMER_ID NUMBER

Customer identifier
CUSTOMER_SITE_ID NUMBER

Customer site identifier
CUSTOMER_ITEM_NUM VARCHAR2 (0)
Customer item number
PLL_NOTE_TO_RECEIVER VARCHAR2 (0)
PLL Note to receiver
PO_DISTRIBUTION_ID NUMBER

PO Distribution identifier
TRANSACTION_QTY NUMBER

Transaction quantity
WIP_ENTITY_ID NUMBER

WIP Entity identifier
WIP_OPERATION_SEQ_NUM NUMBER

WIP Operation sequence number
WIP_RESOURCE_SEQ_NUM NUMBER

QIP Resource sequence number
WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP Repetitive schedule identifier
WIP_LINE_ID NUMBER

WIP Line identifier
BOM_RESOURCE_ID NUMBER

BOM Resource identifier
DESTINATION_TYPE CHAR (0)
Destination type
LOCATION CHAR (0)
Location
CURRENCY_CONVERSION_RATE_POD NUMBER

Currency conversion rate
CURRENCY_CONVERSION_DATE_POD DATE

Currency conversion date
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
SET_OF_BOOKS_ID_SOB NUMBER

Set of books identifier
CURRENCY_CODE_SOB VARCHAR2 (15)
Currency code
COST_GROUP_ID NUMBER

Cost group identifier
SERIAL_NUM VARCHAR2 (30)
Serial number
LOT_NUM VARCHAR2 (80)
Lot number
LOT_QUANTITY NUMBER

Lot quantity
LOT_PRIMARY_QUANTITY NUMBER

Lot primary quantity
Query Text

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


SELECT DOC_TYPE
,      DOC_TYPE_CODE
,      SOURCE_TYPE_CODE
,      RECEIPT_SOURCE_CODE
,      ORDER_TYPE_CODE
,      ORDER_TYPE
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_LINE_LOCATION_ID
,      PO_SHIPMENT_NUMBER
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      REQ_HEADER_ID
,      REQ_NUMBER
,      REQ_LINE_ID
,      REQ_LINE
,      REQ_DISTRIBUTION_ID
,      RCV_SHIPMENT_HEADER_ID
,      RCV_SHIPMENT_NUMBER
,      RCV_SHIPMENT_LINE_ID
,      RCV_LINE_NUMBER
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      OUTSIDE_OPERATION_FLAG
,      ITEM_ID
,      UOM_CODE
,      PRIMARY_UOM
,      PRIMARY_UOM_CLASS
,      ITEM_ALLOWED_UNITS_LOOKUP_CODE
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      SHELF_LIFE_CODE
,      SHELF_LIFE_DAYS
,      SERIAL_NUMBER_CONTROL_CODE
,      LOT_CONTROL_CODE
,      ITEM_REV_CONTROL_FLAG_TO
,      ITEM_REV_CONTROL_FLAG_FROM
,      ITEM_NUMBER
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      ITEM_CATEGORY_ID
,      HAZARD_CLASS
,      UN_NUMBER
,      VENDOR_ITEM_NUMBER
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      PACKING_SLIP
,      ROUTING_ID
,      ROUTING_NAME
,      NEED_BY_DATE
,      EXPECTED_RECEIPT_DATE
,      ORDERED_QTY
,      ORDERED_UOM
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      NOTE_TO_RECEIVER
,      DESTINATION_TYPE_CODE
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      DESTINATION_SUBINVENTORY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CLOSED_CODE
,      ASN_TYPE
,      BILL_OF_LADING
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      WAYBILL_AIRBILL_NUM
,      FREIGHT_BILL_NUM
,      VENDOR_LOT_NUM
,      CONTAINER_NUM
,      TRUCK_NUM
,      BAR_CODE_LABEL
,      RATE_TYPE_DISPLAY
,      MATCH_OPTION
,      COUNTRY_OF_ORIGIN_CODE
,      OE_ORDER_HEADER_ID
,      OE_ORDER_NUM
,      OE_ORDER_LINE_ID
,      OE_ORDER_LINE_NUM
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_ITEM_NUM
,      PLL_NOTE_TO_RECEIVER
,      PO_DISTRIBUTION_ID
,      TRANSACTION_QTY
,      WIP_ENTITY_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_LINE_ID
,      BOM_RESOURCE_ID
,      DESTINATION_TYPE
,      LOCATION
,      CURRENCY_CONVERSION_RATE_POD
,      CURRENCY_CONVERSION_DATE_POD
,      PROJECT_ID
,      TASK_ID
,      SET_OF_BOOKS_ID_SOB
,      CURRENCY_CODE_SOB
,      COST_GROUP_ID
,      SERIAL_NUM
,      LOT_NUM
,      LOT_QUANTITY
,      LOT_PRIMARY_QUANTITY
FROM APPS.CSP_RECEIVE_LINES_V;

Dependencies

[top of page]

APPS.CSP_RECEIVE_LINES_V references the following:

SchemaAPPS
ViewFND_LOOKUP_VALUES_VL
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SUPPLY
SynonymMTL_SYSTEM_ITEMS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_UNITS_OF_MEASURE
SynonymOE_ORDER_HEADERS_ALL
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymRCV_LOTS_SUPPLY
SynonymRCV_SERIALS_SUPPLY
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
APPS.CSP_RECEIVE_LINES_V is referenced by following:

SchemaAPPS
Package BodyCSFW_ORDER_PARTS - show dependent code
Package BodyCSP_TRANSACTIONS_PUB - show dependent code