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


VIEW: PO.RCV_SHIPMENT_LINES#

Object Details
Object Name: RCV_SHIPMENT_LINES#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SHIPMENT_LINE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

SHIPMENT_HEADER_ID NUMBER
Yes
LINE_NUM NUMBER
Yes
CATEGORY_ID NUMBER

QUANTITY_SHIPPED NUMBER

QUANTITY_RECEIVED NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_ID NUMBER

ITEM_REVISION VARCHAR2 (3)
VENDOR_ITEM_NUM VARCHAR2 (25)
VENDOR_LOT_NUM VARCHAR2 (30)
UOM_CONVERSION_RATE NUMBER

SHIPMENT_LINE_STATUS_CODE VARCHAR2 (25)
SOURCE_DOCUMENT_CODE VARCHAR2 (25)
PO_HEADER_ID NUMBER

PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

REQUISITION_LINE_ID NUMBER

REQ_DISTRIBUTION_ID NUMBER

ROUTING_HEADER_ID NUMBER

PACKING_SLIP VARCHAR2 (25)
FROM_ORGANIZATION_ID NUMBER

DELIVER_TO_PERSON_ID NUMBER (9)
EMPLOYEE_ID NUMBER (9)
DESTINATION_TYPE_CODE VARCHAR2 (25)
TO_ORGANIZATION_ID NUMBER

TO_SUBINVENTORY VARCHAR2 (10)
LOCATOR_ID NUMBER

DELIVER_TO_LOCATION_ID NUMBER

CHARGE_ACCOUNT_ID NUMBER

TRANSPORTATION_ACCOUNT_ID NUMBER

SHIPMENT_UNIT_PRICE NUMBER

TRANSFER_COST NUMBER

TRANSPORTATION_COST NUMBER

COMMENTS VARCHAR2 (4000)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REASON_ID NUMBER

USSGL_TRANSACTION_CODE VARCHAR2 (30)
GOVERNMENT_CONTEXT VARCHAR2 (30)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DESTINATION_CONTEXT VARCHAR2 (30)
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
EXCESS_TRANSPORT_REASON VARCHAR2 (25)
EXCESS_TRANSPORT_RESPONSIBLE VARCHAR2 (25)
EXCESS_TRANSPORT_AUTH_NUM VARCHAR2 (30)
ASN_LINE_FLAG VARCHAR2 (1)
ORIGINAL_ASN_PARENT_LINE_ID VARCHAR2 (1)
ORIGINAL_ASN_LINE_FLAG VARCHAR2 (1)
VENDOR_CUM_SHIPPED_QUANTITY NUMBER

NOTICE_UNIT_PRICE NUMBER

TAX_NAME VARCHAR2 (50)
TAX_AMOUNT NUMBER

INVOICE_STATUS_CODE VARCHAR2 (25)
CUM_COMPARISON_FLAG VARCHAR2 (1)
CONTAINER_NUM VARCHAR2 (35)
TRUCK_NUM VARCHAR2 (35)
BAR_CODE_LABEL VARCHAR2 (35)
TRANSFER_PERCENTAGE NUMBER

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

COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
OE_ORDER_HEADER_ID NUMBER

OE_ORDER_LINE_ID NUMBER

CUSTOMER_ITEM_NUM VARCHAR2 (50)
COST_GROUP_ID NUMBER

SECONDARY_QUANTITY_SHIPPED NUMBER

SECONDARY_QUANTITY_RECEIVED NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
MMT_TRANSACTION_ID NUMBER

ASN_LPN_ID NUMBER

AMOUNT NUMBER

AMOUNT_RECEIVED NUMBER

JOB_ID NUMBER

TIMECARD_ID NUMBER

TIMECARD_OVN NUMBER

OSA_FLAG VARCHAR2 (1)
REQUESTED_AMOUNT NUMBER

MATERIAL_STORED_AMOUNT NUMBER

APPROVAL_STATUS VARCHAR2 (25)
AMOUNT_SHIPPED NUMBER

LCM_SHIPMENT_LINE_ID NUMBER

UNIT_LANDED_COST NUMBER

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# references the following:

SchemaPO
TableRCV_SHIPMENT_LINES
PO.RCV_SHIPMENT_LINES# is referenced by following:

SchemaAPPS
TriggerJAI_RCV_RSL_ARIUD_T1
SynonymRCV_SHIPMENT_LINES