[Home] [Help] [Dependency Information]
Object Name: | CSP_RECEIVE_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|