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


VIEW: APPS.PO_RFQ_LINE_LOCATIONS_PRINT

Object Details
Object Name: PO_RFQ_LINE_LOCATIONS_PRINT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_RFQ_LINE_LOCATIONS_PRINT
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SHIPMENT_NUM NUMBER

Shipment line number
SHIPMENT_TYPE VARCHAR2 (25) Yes Type of the shipment
QUANTITY_ORDERED NUMBER

Quantity ordered
PRICE_OVERRIDE NUMBER

Order shipment price or break price for blanket purchase orders, RFQs and quotations
LEAD_TIME NUMBER

Lead time for the price break
LEAD_TIME_UNIT VARCHAR2 (25)
Unit of measure for the lead time
DISCOUNT NUMBER

Price break discount
START_DATE DATE

Effective date of the price break
END_DATE DATE

Expiration date of the price break
SHIP_VIA VARCHAR2 (25)
Type of carrier
FOB VARCHAR2 (80)
Type of free-on-board terms for the shipment
FREIGHT_TERMS VARCHAR2 (80)
Type of freight terms for the shipment
PAYMENT_TERMS VARCHAR2 (50)
Payment terms
TAXABLE_FLAG VARCHAR2 (1)
Indicates whether the shipment is taxable or not
SHIP_ADDRESS_LINE1 VARCHAR2 (240)
Line one of shipment address
SHIP_ADDRESS_LINE2 VARCHAR2 (240)
Line two of shipment address
SHIP_ADDRESS_LINE3 VARCHAR2 (240)
Line three of shipment address
SHIP_CITY VARCHAR2 (30)
Address city
SHIP_STATE_PROVINCE VARCHAR2 (120)
Address state or province
SHIP_POSTAL_CODE VARCHAR2 (30)
Address postal code
SHIP_COUNTRY VARCHAR2 (60)
Address country
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
PO_HEADER_ID NUMBER
Yes Document header unique identifier
PO_LINE_ID NUMBER
Yes Document line unique identifier
LINE_LOCATION_ID NUMBER
Yes Document shipment schedule unique identifier
SHIP_TO_LOCATION_ID NUMBER

Unique identifier for the ship-to location
NEED_BY_DATE DATE

ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT SHIPMENT_NUM
,      SHIPMENT_TYPE
,      QUANTITY_ORDERED
,      PRICE_OVERRIDE
,      LEAD_TIME
,      LEAD_TIME_UNIT
,      DISCOUNT
,      START_DATE
,      END_DATE
,      SHIP_VIA
,      FOB
,      FREIGHT_TERMS
,      PAYMENT_TERMS
,      TAXABLE_FLAG
,      SHIP_ADDRESS_LINE1
,      SHIP_ADDRESS_LINE2
,      SHIP_ADDRESS_LINE3
,      SHIP_CITY
,      SHIP_STATE_PROVINCE
,      SHIP_POSTAL_CODE
,      SHIP_COUNTRY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      NEED_BY_DATE
,      ORG_ID
FROM APPS.PO_RFQ_LINE_LOCATIONS_PRINT;

Dependencies

[top of page]

APPS.PO_RFQ_LINE_LOCATIONS_PRINT references the following:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymORG_FREIGHT
SynonymPO_HEADERS_ALL
SynonymPO_LINE_LOCATIONS
ViewPO_LOOKUP_CODES

APPS.PO_RFQ_LINE_LOCATIONS_PRINT is not referenced by any database object