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


TABLE: PO.RCV_SHIPMENT_LINES

Object Details
Object Name: RCV_SHIPMENT_LINES
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.RCV_SHIPMENT_LINES
Subobject Name:
Status: VALID


RCV_SHIPMENT_LINES stores information about items that have been
shipped and/or received from a specific receipt source.
.
RCV_SHIPMENT_LINES also stores information about the default
destination for intransit shipments.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCV_SHIPMENT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_LINE_ID
RCV_SHIPMENT_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_HEADER_ID
ColumnLINE_NUM
RCV_SHIPMENT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_ID
ColumnTO_ORGANIZATION_ID
ColumnFROM_ORGANIZATION_ID
RCV_SHIPMENT_LINES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOE_ORDER_LINE_ID
RCV_SHIPMENT_LINES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASN_LPN_ID
RCV_SHIPMENT_LINES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_RELEASE_ID
RCV_SHIPMENT_LINES_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOE_ORDER_HEADER_ID
RCV_SHIPMENT_LINES_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_ORGANIZATION_ID
RCV_SHIPMENT_LINES_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLCM_SHIPMENT_LINE_ID
RCV_SHIPMENT_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
RCV_SHIPMENT_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_ID
RCV_SHIPMENT_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_LOCATION_ID
RCV_SHIPMENT_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMPLOYEE_ID
RCV_SHIPMENT_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVER_TO_PERSON_ID
RCV_SHIPMENT_LINES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTAINER_NUM
ColumnTO_ORGANIZATION_ID
ColumnSHIPMENT_HEADER_ID
RCV_SHIPMENT_LINES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUISITION_LINE_ID
RCV_SHIPMENT_LINES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKING_SLIP
Columns
Name Datatype Length Mandatory Comments
SHIPMENT_LINE_ID NUMBER
Yes Shipment line unique identifier
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).
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).
SHIPMENT_HEADER_ID NUMBER
Yes Shipment header unique identifier
LINE_NUM NUMBER
Yes Shipment line number
CATEGORY_ID NUMBER

Item category unique identifier
QUANTITY_SHIPPED NUMBER

Number of items shipped
QUANTITY_RECEIVED NUMBER

Number of items received
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure of the shipment
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
ITEM_ID NUMBER

Item identifier
ITEM_REVISION VARCHAR2 (3)
Item revision number
VENDOR_ITEM_NUM VARCHAR2 (25)
Supplier's item number
VENDOR_LOT_NUM VARCHAR2 (30)
Supplier's lot number
UOM_CONVERSION_RATE NUMBER

Not currently used
SHIPMENT_LINE_STATUS_CODE VARCHAR2 (25)
Receipt status of the shipment line
SOURCE_DOCUMENT_CODE VARCHAR2 (25)
Source document type
PO_HEADER_ID NUMBER

Purchase order header unique identifier
PO_RELEASE_ID NUMBER

Purchase order release unique identifier
PO_LINE_ID NUMBER

Purchase order line unique identifier
PO_LINE_LOCATION_ID NUMBER

Purchase order shipment unique identifier
PO_DISTRIBUTION_ID NUMBER

Purchase order distribution unique identifier
REQUISITION_LINE_ID NUMBER

Requisition line unique identifier
REQ_DISTRIBUTION_ID NUMBER

Requisition distribution unique identifier
ROUTING_HEADER_ID NUMBER

Receiving routing unique identifier
PACKING_SLIP VARCHAR2 (25)
Packing slip number
FROM_ORGANIZATION_ID NUMBER

Source organization unique identifier
DELIVER_TO_PERSON_ID NUMBER (9)
Requester unique identifier
EMPLOYEE_ID NUMBER (9)
Receiver unique identifier
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type for items
TO_ORGANIZATION_ID NUMBER

Destination organization unique identifier
TO_SUBINVENTORY VARCHAR2 (10)
Default destination subinventory
LOCATOR_ID NUMBER

Not currently used
DELIVER_TO_LOCATION_ID NUMBER

Deliver-to location unique identifier
CHARGE_ACCOUNT_ID NUMBER

Intransit charge account unique identifier
TRANSPORTATION_ACCOUNT_ID NUMBER

Intransit transportation account unique identifier
SHIPMENT_UNIT_PRICE NUMBER

Item unit price
TRANSFER_COST NUMBER

Intransit transfer cost
TRANSPORTATION_COST NUMBER

Intransit transportation cost
COMMENTS VARCHAR2 (4000)
Receiver or Approver comments
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
REASON_ID NUMBER

Transaction reason unique identifier
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
DESTINATION_CONTEXT VARCHAR2 (30)
Destination descriptive flexfield context
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary unit of measure for the item
EXCESS_TRANSPORT_REASON VARCHAR2 (25)
Excess transportation reason code
EXCESS_TRANSPORT_RESPONSIBLE VARCHAR2 (25)
Excess transportation responsibility code
EXCESS_TRANSPORT_AUTH_NUM VARCHAR2 (30)
Excess transportation authorization number
ASN_LINE_FLAG VARCHAR2 (1)
Indicates whether item is on an Advance Shipment Notice (ASN). Used by missing ASN Items Processor to determine whether shipped items were received.
ORIGINAL_ASN_PARENT_LINE_ID VARCHAR2 (1)
Reference to original ASN Line
ORIGINAL_ASN_LINE_FLAG VARCHAR2 (1)
Original ASN line flag
VENDOR_CUM_SHIPPED_QUANTITY NUMBER

Supplier's quantity shipped specified on the ASN - populated for parent lines only
NOTICE_UNIT_PRICE NUMBER

EDI transaction 857 unit price of this item
TAX_NAME VARCHAR2 (50)
EDI transaction 857 tax name indicated at the detail level
TAX_AMOUNT NUMBER

EDI transaction 857 tax amount indicated at the detail level
INVOICE_STATUS_CODE VARCHAR2 (25)
EDI transaction 857 status code to determine which line has been transferred to Oracle Payables
CUM_COMPARISON_FLAG VARCHAR2 (1)
Not used
CONTAINER_NUM VARCHAR2 (35)
Unique container identifier for the line
TRUCK_NUM VARCHAR2 (35)
Number of the truck
BAR_CODE_LABEL VARCHAR2 (35)
Label for the barcode
TRANSFER_PERCENTAGE NUMBER

Transfer percentage for costing
MRC_SHIPMENT_UNIT_PRICE VARCHAR2 (2000)
MRC_TRANSFER_COST VARCHAR2 (2000)
MRC_TRANSPORTATION_COST VARCHAR2 (2000)
MRC_NOTICE_UNIT_PRICE VARCHAR2 (2000)
SHIP_TO_LOCATION_ID NUMBER

Unique identifier for the ship-to location
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Code for the country of manufacture
OE_ORDER_HEADER_ID NUMBER

Sales order unique identifier
OE_ORDER_LINE_ID NUMBER

Sales order line unique identifier
CUSTOMER_ITEM_NUM VARCHAR2 (50)
Customer's item number
COST_GROUP_ID NUMBER

Cost Group Identifier for the material on the shipment line for Oracle WMS
SECONDARY_QUANTITY_SHIPPED NUMBER

Quantity of item shipped in secondary unit of measure
SECONDARY_QUANTITY_RECEIVED NUMBER

Quantity received in secondary unit of measure
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
Secondary unit of measure of the shipment
QC_GRADE VARCHAR2 (150)
Quality grade of the shipment line
MMT_TRANSACTION_ID NUMBER

Inventory Transaction Identifier
ASN_LPN_ID NUMBER

The lpn_id for ASNs only
AMOUNT NUMBER

Reserved for future use
AMOUNT_RECEIVED NUMBER

Amount Received in purchase order currency
JOB_ID NUMBER

Job identifier
TIMECARD_ID NUMBER

Timecard Identifier
TIMECARD_OVN NUMBER

Timecard version number
OSA_FLAG VARCHAR2 (1)
Indicates if this shipment line is a shikyu item
REQUESTED_AMOUNT NUMBER

requested amount for a Work Confirmation
MATERIAL_STORED_AMOUNT NUMBER

material stored amount for a work confirmation
APPROVAL_STATUS VARCHAR2 (25)
Approval status of the work confirmation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='APPROVAL_STATUS')
AMOUNT_SHIPPED NUMBER

amount shipped
LCM_SHIPMENT_LINE_ID NUMBER

LCM Shipment line identifier
UNIT_LANDED_COST NUMBER

LCM unit landed cost
Query Text

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


SELECT SHIPMENT_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SHIPMENT_HEADER_ID
,      LINE_NUM
,      CATEGORY_ID
,      QUANTITY_SHIPPED
,      QUANTITY_RECEIVED
,      UNIT_OF_MEASURE
,      ITEM_DESCRIPTION
,      ITEM_ID
,      ITEM_REVISION
,      VENDOR_ITEM_NUM
,      VENDOR_LOT_NUM
,      UOM_CONVERSION_RATE
,      SHIPMENT_LINE_STATUS_CODE
,      SOURCE_DOCUMENT_CODE
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      ROUTING_HEADER_ID
,      PACKING_SLIP
,      FROM_ORGANIZATION_ID
,      DELIVER_TO_PERSON_ID
,      EMPLOYEE_ID
,      DESTINATION_TYPE_CODE
,      TO_ORGANIZATION_ID
,      TO_SUBINVENTORY
,      LOCATOR_ID
,      DELIVER_TO_LOCATION_ID
,      CHARGE_ACCOUNT_ID
,      TRANSPORTATION_ACCOUNT_ID
,      SHIPMENT_UNIT_PRICE
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REASON_ID
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DESTINATION_CONTEXT
,      PRIMARY_UNIT_OF_MEASURE
,      EXCESS_TRANSPORT_REASON
,      EXCESS_TRANSPORT_RESPONSIBLE
,      EXCESS_TRANSPORT_AUTH_NUM
,      ASN_LINE_FLAG
,      ORIGINAL_ASN_PARENT_LINE_ID
,      ORIGINAL_ASN_LINE_FLAG
,      VENDOR_CUM_SHIPPED_QUANTITY
,      NOTICE_UNIT_PRICE
,      TAX_NAME
,      TAX_AMOUNT
,      INVOICE_STATUS_CODE
,      CUM_COMPARISON_FLAG
,      CONTAINER_NUM
,      TRUCK_NUM
,      BAR_CODE_LABEL
,      TRANSFER_PERCENTAGE
,      MRC_SHIPMENT_UNIT_PRICE
,      MRC_TRANSFER_COST
,      MRC_TRANSPORTATION_COST
,      MRC_NOTICE_UNIT_PRICE
,      SHIP_TO_LOCATION_ID
,      COUNTRY_OF_ORIGIN_CODE
,      OE_ORDER_HEADER_ID
,      OE_ORDER_LINE_ID
,      CUSTOMER_ITEM_NUM
,      COST_GROUP_ID
,      SECONDARY_QUANTITY_SHIPPED
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
,      MMT_TRANSACTION_ID
,      ASN_LPN_ID
,      AMOUNT
,      AMOUNT_RECEIVED
,      JOB_ID
,      TIMECARD_ID
,      TIMECARD_OVN
,      OSA_FLAG
,      REQUESTED_AMOUNT
,      MATERIAL_STORED_AMOUNT
,      APPROVAL_STATUS
,      AMOUNT_SHIPPED
,      LCM_SHIPMENT_LINE_ID
,      UNIT_LANDED_COST
FROM PO.RCV_SHIPMENT_LINES;

Dependencies

[top of page]

PO.RCV_SHIPMENT_LINES does not reference any database object

PO.RCV_SHIPMENT_LINES is referenced by following:

SchemaPO
ViewRCV_SHIPMENT_LINES#