[Home] [Help] [Dependency Information]

VIEW: APPS.OE_PRN_ORDER_LINES_V

Object Details

Object Name:	OE_PRN_ORDER_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_PRN_ORDER_LINES_V
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

Query Text

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

SELECT LINE_ID
,      ORG_ID
,      HEADER_ID
,      LINE_TYPE_ID
,      LINE
,      LINE_NUMBER
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      REQUEST_DATE
,      PROMISE_DATE
,      SCHEDULE_ARRIVAL_DATE
,      SCHEDULE_SHIP_DATE
,      ORDER_QUANTITY_UOM
,      ORDERED_QUANTITY
,      TAX_EXEMPT_NUMBER
,      CUST_PO_NUMBER
,      SOLD_TO_ORG_ID
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      INTMED_SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_ID
,      INVENTORY_ITEM_ID
,      TAX_CODE
,      TAX_RATE
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      DISCOUNT
,      TAX_VALUE
,      ATO_LINE_ID
,      CONFIGURATION_ID
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      ITEM_TYPE_CODE
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      OPTION_FLAG
,      SALESREP_ID
,      ORDERED_ITEM_ID
,      ITEM_IDENTIFIER_TYPE
,      CONFIG_HEADER_ID
,      CONFIG_REV_NBR
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      INVOICED_QUANTITY
,      SERVICE_TXN_REASON_CODE
,      SERVICE_TXN_COMMENTS
,      SERVICE_DURATION
,      SERVICE_PERIOD
,      SERVICE_START_DATE
,      SERVICE_END_DATE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_NUMBER
,      SERVICE_REFERENCE_TYPE_CODE
,      SERVICE_REFERENCE_LINE_ID
,      SERVICE_REFERENCE_SYSTEM_ID
,      AGREEMENT_NAME
,      AGREEMENT_VERSION
,      BLANKET_NUMBER
,      BLANKET_LINE_NUMBER
,      BLANKET_VERSION_NUMBER
,      INVOICING_RULE_NAME
,      PAYMENT_TERMS
,      LINE_TOTAL
,      LINE_PRICE
,      LINE_CHARGES
,      LINE_TAXES
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      IB_OWNER
,      IB_INSTALLED_AT_LOCATION
,      IB_CURRENT_LOCATION
,      CHARGE_PERIODICITY_CODE
FROM APPS.OE_PRN_ORDER_LINES_V;

Dependencies

[top of page]

APPS

FND_CURRENCY - show dependent code

MTL_CROSS_REFERENCES

MTL_CUSTOMER_ITEMS

MTL_SYSTEM_ITEMS_KFV

MTL_SYSTEM_ITEMS_TL

MTL_UNITS_OF_MEASURE_TL

OE_AGREEMENTS_TL

OE_BLANKET_HEADERS_ALL

OE_OE_TOTALS_SUMMARY - show dependent code

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

OE_ORDER_MISC_PUB - show dependent code

OE_SYS_PARAMETERS - show dependent code

OE_TOTALS_GRP - show dependent code

OE_TRANSACTION_TYPES_ALL

RA_RULES

RA_TERMS_TL

APPS.OE_PRN_ORDER_LINES_V is not referenced by any database object