indexes, Table Structure

RCV_SHIPMENT_LINES: Columns, Indexes & Few Tricks

Mohit Saxena

RCV_SHIPMENT_LINES is the table used by Oracle Fusion to store the line level shipment details like Item Number, Quantity Shipped, Quantity Received etc. This table is child table of RCV_SHIPMENT_HEADERS Table. Both of the tables are connected by column SHIPMENT_HEADER_ID. An important point to remember is that data in this table does not mean physical receiving, rather it gives you the plan of receiving. Physical receiving data is stored in RCV_TRANSACTIONS table which is the child table of RCV_SHIPMENT_LINES table.

In case you are looking for query to fetch you receiving transaction details, click here.

In this post we’ll have a look at the table structure of RCV_SHIPMENT_LINES table. By querying this table, you can primarily find out following details:
1. Shipment Line Number
2. Shipped Quantity
3. Received Quantity
4. Delivered Quantity
5. Returned Quantity
6. Quantity Accepted
7. Quantity Rejected
8. Item Description
9. PO Number
10. PO Line Number

So let’s see how the table is defined in Oracle Fusion:

RCV_SHIPMENT_LINES: Column Details

COLUMN_NAMEDATA_TYPENULLABLE
 SHIPMENT_LINE_IDNUMBERN 
 LAST_UPDATE_DATETIMESTAMP(6)N 
 LAST_UPDATED_BYVARCHAR2(256)N 
 CREATION_DATETIMESTAMP(6)N 
 CREATED_BYVARCHAR2(256)N 
 LAST_UPDATE_LOGINVARCHAR2(128)Y 
 SHIPMENT_HEADER_IDNUMBERN 
 LINE_NUMNUMBERN 
 CATEGORY_IDNUMBERY 
 QUANTITY_SHIPPEDNUMBERY 
 QUANTITY_RECEIVEDNUMBERY 
 QUANTITY_DELIVEREDNUMBERY 
 QUANTITY_RETURNEDNUMBERY 
 QUANTITY_ACCEPTEDNUMBERY 
 QUANTITY_REJECTEDNUMBERY 
 UOM_CODEVARCHAR2(12)Y 
 ITEM_DESCRIPTIONVARCHAR2(960)Y 
 ITEM_IDNUMBERY 
 ITEM_REVISIONVARCHAR2(72)Y 
 VENDOR_ITEM_NUMVARCHAR2(1200)Y 
 VENDOR_LOT_NUMVARCHAR2(120)Y 
 UOM_CONVERSION_RATENUMBERY 
 SHIPMENT_LINE_STATUS_CODEVARCHAR2(100)Y 
 SOURCE_DOCUMENT_CODEVARCHAR2(100)Y 
 PO_HEADER_IDNUMBERY 
 PO_LINE_IDNUMBERY 
 PO_LINE_LOCATION_IDNUMBERY 
 PO_DISTRIBUTION_IDNUMBERY 
 REQUISITION_LINE_IDNUMBERY 
 REQ_DISTRIBUTION_IDNUMBERY 
 ROUTING_HEADER_IDNUMBERY 
 PACKING_SLIPVARCHAR2(100)Y 
 FROM_ORGANIZATION_IDNUMBERY 
 DELIVER_TO_PERSON_IDNUMBERY 
 EMPLOYEE_IDNUMBERY 
 DESTINATION_TYPE_CODEVARCHAR2(100)Y 
 TO_ORGANIZATION_IDNUMBERY 
 TO_SUBINVENTORYVARCHAR2(40)Y 
 LOCATOR_IDNUMBERY 
 DELIVER_TO_LOCATION_IDNUMBERY 
 SHIPMENT_UNIT_PRICENUMBERY 
 TRANSFER_COSTNUMBERY 
 TRANSPORTATION_COSTNUMBERY 
 COMMENTSVARCHAR2(4000)Y 
 ATTRIBUTE_CATEGORYVARCHAR2(120)Y 
 ATTRIBUTE1 –  ATTRIBUTE20VARCHAR2(600)Y 
 ATTRIBUTE_NUMBER1 –  ATTRIBUTE_NUMBER10NUMBERY 
 ATTRIBUTE_DATE1 – ATTRIBUTE_DATE5DATEY 
 ATTRIBUTE_TIMESTAMP1 – ATTRIBUTE_TIMESTAMP5TIMESTAMP(6)Y 
 REASON_IDNUMBERY 
 GOVERNMENT_CONTEXTVARCHAR2(120)Y 
 REQUEST_IDNUMBERY 
 DESTINATION_CONTEXTVARCHAR2(120)Y 
 PRIMARY_UOM_CODEVARCHAR2(12)Y 
 EXCESS_TRANSPORT_REASONVARCHAR2(100)Y 
 EXCESS_TRANSPORT_RESPONSIBLEVARCHAR2(100)Y 
 EXCESS_TRANSPORT_AUTH_NUMVARCHAR2(120)Y 
 ASN_LINE_FLAGVARCHAR2(4)Y 
 ORIGINAL_ASN_PARENT_LINE_IDVARCHAR2(4)Y 
 ORIGINAL_ASN_LINE_FLAGVARCHAR2(4)Y 
 VENDOR_CUM_SHIPPED_QUANTITYNUMBERY 
 NOTICE_UNIT_PRICENUMBERY 
 TAX_NAMEVARCHAR2(60)Y 
 TAX_AMOUNTNUMBERY 
 INVOICE_STATUS_CODEVARCHAR2(100)Y 
 CUM_COMPARISON_FLAGVARCHAR2(4)Y 
 CONTAINER_NUMVARCHAR2(140)Y 
 TRUCK_NUMVARCHAR2(140)Y 
 BAR_CODE_LABELVARCHAR2(140)Y 
 TRANSFER_PERCENTAGENUMBERY 
 SHIP_TO_LOCATION_IDNUMBERY 
 COUNTRY_OF_ORIGIN_CODEVARCHAR2(8)Y 
 CUSTOMER_ITEM_NUMVARCHAR2(200)Y 
 SECONDARY_QUANTITY_SHIPPEDNUMBERY 
 SECONDARY_QUANTITY_RECEIVEDNUMBERY 
 SECONDARY_UOM_CODEVARCHAR2(12)Y 
 QC_GRADEVARCHAR2(600)Y 
 MMT_TRANSACTION_IDNUMBERY 
 ASN_LPN_IDNUMBERY 
 AMOUNTNUMBERY 
 AMOUNT_RECEIVEDNUMBERY 
 JOB_IDNUMBERY 
 TIMECARD_IDNUMBERY 
 TIMECARD_OVNNUMBERY 
 OSA_FLAGVARCHAR2(4)Y 
 REQUESTED_AMOUNTNUMBERY 
 MATERIAL_STORED_AMOUNTNUMBERY 
 APPROVAL_STATUSVARCHAR2(100)Y 
 AMOUNT_SHIPPEDNUMBERY 
 JOB_DEFINITION_NAMEVARCHAR2(400)Y 
 JOB_DEFINITION_PACKAGEVARCHAR2(3600)Y 
 OBJECT_VERSION_NUMBERNUMBERN 
 RECEIPT_ADVICE_LINE_NUMBERVARCHAR2(320)Y 
 RA_DOCUMENT_LINE_NUMBERVARCHAR2(320)Y 
 RA_DOO_HEADER_NUMBERVARCHAR2(320)Y 
 RA_DOO_LINE_NUMBERVARCHAR2(320)Y 
 RA_DOO_FULFILLMENT_LINE_NUMBERVARCHAR2(320)Y 
 RA_DOC_SCHEDULE_NUMBERVARCHAR2(320)Y 
 RA_DOC_LINE_CREATION_DATEDATEY 
 RA_DOC_LINE_LAST_UPDATE_DATEDATEY 
 RA_EXPECTED_RECEIPT_DATEDATEY 
 RA_DAYS_EARLY_RECEIPT_ALLOWEDNUMBERY 
 RA_DAYS_LATE_RECEIPT_ALLOWEDNUMBERY 
 RA_RECEIPT_DAYS_EXCEPTION_CODEVARCHAR2(100)Y 
 RA_ENFORCE_SHIP_TO_LOC_CODEVARCHAR2(100)Y 
 RA_ALLOW_SUBSTITUTE_RECEIPTVARCHAR2(4)Y 
 RA_QTY_RCV_TOLERANCENUMBERY 
 RA_QTY_RCV_EXCEPTION_CODEVARCHAR2(100)Y 
 RA_NOTE_TO_RECEIVERVARCHAR2(1920)Y 
 RECEIPT_ADVICE_HEADER_IDNUMBERY 
 RECEIPT_ADVICE_LINE_IDNUMBERY 
 RA_ORIG_DOO_HEADER_NUMBERVARCHAR2(320)Y 
 RA_ORIG_DOO_LINE_NUMBERVARCHAR2(320)Y 
 RA_ORIG_OC_HEADER_NUMBERVARCHAR2(320)Y 
 RA_ORIG_OC_LINE_NUMBERVARCHAR2(320)Y 
 RA_ORIG_DOO_FULFIL_LINE_NUMVARCHAR2(320)Y 
 CUSTOMER_IDNUMBERY 
 CUSTOMER_SITE_IDNUMBERY 
 RA_QUANTITY_EXPECTEDNUMBERY 
 RA_SECONDARY_QUANTITY_EXPECTEDNUMBERY 
 RA_UNIT_PRICENUMBERY 
 SP_QUANTITYNUMBERY 
 SP_UOM_CODEVARCHAR2(12)Y 
 SP_GROUP_IDNUMBERY 
 RA_LAST_ACTION_CODEVARCHAR2(100)Y 
 RA_MESSAGE_NUMBERNUMBERY 
 INTERFACE_TRANSACTION_IDNUMBERY 
 TRANSFER_ORDER_HEADER_IDNUMBERY 
 TRANSFER_ORDER_LINE_IDNUMBERY 
 CONSIGNED_FLAGVARCHAR2(4)Y 
 CONSUMED_QUANTITYNUMBERY 
 EXTERNAL_SYS_INTF_STATUSVARCHAR2(100)Y 
 FIRST_PTY_REG_IDNUMBERY 
 THIRD_PTY_REG_IDNUMBERY 
 DEFAULT_TAXATION_COUNTRYVARCHAR2(8)Y 
 DOCUMENT_FISCAL_CLASSIFICATIONVARCHAR2(960)Y 
 TRX_BUSINESS_CATEGORYVARCHAR2(960)Y 
 TAX_INVOICE_NUMBERVARCHAR2(600)Y 
 TAX_INVOICE_DATEDATEY 
 SHIP_FROM_LOCATION_IDNUMBERY 
 USER_DEFINED_FISC_CLASSVARCHAR2(120)Y 
 TAX_CLASSIFICATION_CODEVARCHAR2(200)Y 
 INTENDED_USEVARCHAR2(960)Y 
 INTENDED_USE_CLASSIF_IDNUMBERY 
 PRODUCT_TYPEVARCHAR2(960)Y 
 PRODUCT_CATEGORYVARCHAR2(960)Y 
 ASSESSABLE_VALUENUMBERY 
 FINAL_DISCHARGE_LOCATION_IDNUMBERY 
 PRODUCT_FISC_CLASS_IDNUMBERY 
 ORIG_TO_INV_SHIP_TXN_IDNUMBERY 
 CUSTOMER_ITEM_IDNUMBERY 
 BACK_TO_BACK_FLAGVARCHAR2(4)Y 
 PROJECT_IDNUMBERY 
 TASK_IDNUMBERY 
 INV_STRIPING_CATEGORYVARCHAR2(160)Y 
 INV_RESERVED_ATTRIBUTE1VARCHAR2(600)Y 
 INV_RESERVED_ATTRIBUTE2VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE1VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE2VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE3VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE4VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE5VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE6VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE7VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE8VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE9VARCHAR2(600)Y 
 INV_USER_DEF_ATTRIBUTE10VARCHAR2(600)Y 
 EWAY_BILL_NUMBERNUMBERY 
 EWAY_BILL_DATEDATEY 
 EXT_SYS_GROUP_IDNUMBERY 
 DS_LINE_INTERFACED_TO_OMVARCHAR2(4)Y 
RCV_SHIPMENT_LINES: Column Details

Indexes

INDEX_NAMEINDEX_TYPEUNIQUENESSCOLUMN_NAME
 RCV_SHIPMENT_LINES_N1NORMALNONUNIQUEITEM_ID
 RCV_SHIPMENT_LINES_N1NORMALNONUNIQUETO_ORGANIZATION_ID
 RCV_SHIPMENT_LINES_N1NORMALNONUNIQUEFROM_ORGANIZATION_ID
 RCV_SHIPMENT_LINES_N11NORMALNONUNIQUEASN_LPN_ID
 RCV_SHIPMENT_LINES_N12NORMALNONUNIQUETRANSFER_ORDER_HEADER_ID
 RCV_SHIPMENT_LINES_N13NORMALNONUNIQUESHIPMENT_LINE_STATUS_CODE
 RCV_SHIPMENT_LINES_N13NORMALNONUNIQUESOURCE_DOCUMENT_CODE
 RCV_SHIPMENT_LINES_N13NORMALNONUNIQUEASN_LINE_FLAG
 RCV_SHIPMENT_LINES_N14NORMALNONUNIQUETO_ORGANIZATION_ID
 RCV_SHIPMENT_LINES_N15NORMALNONUNIQUEEXT_SYS_GROUP_ID
 RCV_SHIPMENT_LINES_N16NORMALNONUNIQUEDS_LINE_INTERFACED_TO_OM
 RCV_SHIPMENT_LINES_N2NORMALNONUNIQUEPO_HEADER_ID
 RCV_SHIPMENT_LINES_N3NORMALNONUNIQUEPO_LINE_ID
 RCV_SHIPMENT_LINES_N4NORMALNONUNIQUEPO_LINE_LOCATION_ID
 RCV_SHIPMENT_LINES_N5NORMALNONUNIQUEEMPLOYEE_ID
 RCV_SHIPMENT_LINES_N6NORMALNONUNIQUEDELIVER_TO_PERSON_ID
 RCV_SHIPMENT_LINES_N7NORMALNONUNIQUECONTAINER_NUM
 RCV_SHIPMENT_LINES_N7NORMALNONUNIQUETO_ORGANIZATION_ID
 RCV_SHIPMENT_LINES_N7NORMALNONUNIQUESHIPMENT_HEADER_ID
 RCV_SHIPMENT_LINES_N8NORMALNONUNIQUEREQUISITION_LINE_ID
 RCV_SHIPMENT_LINES_N9NORMALNONUNIQUEPACKING_SLIP
 RCV_SHIPMENT_LINES_U1NORMALUNIQUESHIPMENT_LINE_ID
 RCV_SHIPMENT_LINES_U2NORMALUNIQUESHIPMENT_HEADER_ID
 RCV_SHIPMENT_LINES_U2NORMALUNIQUELINE_NUM
Index Details

Related Posts:

Receiving Transaction Query in Oracle Fusion
RCV_SHIPMENT_HEADERS: Columns & Indexes
Query To Get The Shipment Details In Oracle Fusion
Item Shipment History Query in Fusion

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

From: Mohit Saxena
Author of “Oracle Fusion: Unconventional Ways to Enhance the Performance of BI Reports“

How useful was this post?

Click on a star to rate it!

Average rating 3 / 5. Vote count: 2

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

3 thoughts on “RCV_SHIPMENT_LINES: Columns, Indexes & Few Tricks”

  1. Pingback: RCV_SHIPMENT_HEADERS: Columns & Indexes - Oracle Bytes
  2. Pingback: RCV_TRANSACTIONS: Columns, Indexes & Tricks - Oracle Bytes
  3. Pingback: Receiving Transaction Query in Oracle Fusion - Oracle Bytes

Comments are closed.