[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POFV_QUOTATION_SHIPMENTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PO.POFV_QUOTATION_SHIPMENTS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This shows scheduling information for a bid quotation line. Scheduling information includes information such as quantity and ship-to location.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SHIPMENT_ID | NUMBER | Yes | ||
| SHIPMENT_NUMBER | NUMBER | |||
| QUOTATION_LINE_ID | NUMBER | Yes | ||
| LINE_NUMBER | NUMBER | Yes | ||
| QUOTATION_ID | NUMBER | Yes | ||
| QUOTATION_DOCUMENT_NUMBER | VARCHAR2 | (20) | Yes | |
| OPERATING_UNIT_ID | NUMBER | |||
| OPERATING_UNIT_NAME | VARCHAR2 | (240) | Yes | |
| SHIPMENT_QUANTITY | NUMBER | |||
| ACTUAL_PRICE | NUMBER | |||
| NEED_BY_DATE | DATE | |||
| LATEST_ACCEPTABLE_DATE | DATE | |||
| _LA:APPROVED_FLAG | CHAR | (59) | ||
| _LA:FIRM_STATUS | CHAR | (69) | ||
| _LA:INVOICE_MATCHING | CHAR | (218) | ||
| QUANTITY_RECEIVED_TOLERANCE | NUMBER | |||
| _LA:QTY_RECEIVED_EXCEPTION | CHAR | (85) | ||
| _LA:TAXABLE_FLAG | CHAR | (58) | ||
| TAX_NAME | VARCHAR2 | (0) | ||
| _DF | CHAR | (27) | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| UOM_CLASS | VARCHAR2 | (10) | ||
| UOM_DESCRIPTION | VARCHAR2 | (50) | ||
| PAYMENT_TERMS_ID | NUMBER | |||
| PAYMENT_TERMS_NAME | VARCHAR2 | (50) | ||
| RFQ_ID | NUMBER | |||
| RFQ_DOCUMENT_NUMBER | VARCHAR2 | (20) | ||
| RFQ_LINE_ID | NUMBER | |||
| RFQ_LINE_NUMBER | NUMBER | |||
| RFQ_SHIPMENT_ID | NUMBER | |||
| RFQ_SHIPMENT_NUMBER | NUMBER | |||
| CREATED_DATE | DATE | |||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| LAST_UPDATED_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| VALUE_BASIS | VARCHAR2 | (25) | Value Basis | |
| MATCHING_BASIS | VARCHAR2 | (30) | Matching Basis | |
| PAYMENT_TYPE | VARCHAR2 | (30) | Payment Type | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| WORK_APPROVER_ID | NUMBER | Work Approver Id | ||
| BID_PAYMENT_ID | NUMBER | Bid Payment Id | ||
| QUANTITY_FINANCED | NUMBER | Quantity Financed | ||
| AMOUNT_FINANCED | NUMBER | Amount Financed | ||
| QUANTITY_RECOUPED | NUMBER | Quantity Recouped | ||
| AMOUNT_RECOUPED | NUMBER | Amount Recouped | ||
| RETAINAGE_WITHHELD_AMOUNT | NUMBER | Retainage Withheld Amount | ||
| RETAINAGE_RELEASED_AMOUNT | NUMBER | Retainage Released Amount | ||
| TAX_ATTRIBUTE_UPDATE_CODE | NUMBER | Yes | Tax Attribute Update Code | |
| OUTSOURCED_ASSEMBLY | VARCHAR2 | (15) | Outsourced Assembly | |
| ORIGINAL_SHIPMENT_ID | NUMBER | Original Shipment Id |
Cut, paste (and edit) the following text to query this object:
SELECT SHIPMENT_ID
, SHIPMENT_NUMBER
, QUOTATION_LINE_ID
, LINE_NUMBER
, QUOTATION_ID
, QUOTATION_DOCUMENT_NUMBER
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, SHIPMENT_QUANTITY
, ACTUAL_PRICE
, NEED_BY_DATE
, LATEST_ACCEPTABLE_DATE
, _LA:APPROVED_FLAG
, _LA:FIRM_STATUS
, _LA:INVOICE_MATCHING
, QUANTITY_RECEIVED_TOLERANCE
, _LA:QTY_RECEIVED_EXCEPTION
, _LA:TAXABLE_FLAG
, TAX_NAME
, _DF
, UNIT_OF_MEASURE
, UOM_CLASS
, UOM_DESCRIPTION
, PAYMENT_TERMS_ID
, PAYMENT_TERMS_NAME
, RFQ_ID
, RFQ_DOCUMENT_NUMBER
, RFQ_LINE_ID
, RFQ_LINE_NUMBER
, RFQ_SHIPMENT_ID
, RFQ_SHIPMENT_NUMBER
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
, VALUE_BASIS
, MATCHING_BASIS
, PAYMENT_TYPE
, DESCRIPTION
, WORK_APPROVER_ID
, BID_PAYMENT_ID
, QUANTITY_FINANCED
, AMOUNT_FINANCED
, QUANTITY_RECOUPED
, AMOUNT_RECOUPED
, RETAINAGE_WITHHELD_AMOUNT
, RETAINAGE_RELEASED_AMOUNT
, TAX_ATTRIBUTE_UPDATE_CODE
, OUTSOURCED_ASSEMBLY
, ORIGINAL_SHIPMENT_ID
FROM APPS.POFV_QUOTATION_SHIPMENTS;
APPS
AP_TERMS
HR_ALL_ORGANIZATION_UNITS
MTL_UNITS_OF_MEASURE
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
APPS.POFV_QUOTATION_SHIPMENTS is not referenced by any database object
|
|
|
|