View: OE_PRN_ORDER_HEADERS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_PRN_ORDER_HEADERS_V

View Text

SELECT H.HEADER_ID
, H.ORG_ID
, H.ORDER_NUMBER
, H.VERSION_NUMBER
, H.SOURCE_DOCUMENT_TYPE_ID
, H.SOURCE_DOCUMENT_ID
, H.ORDER_SOURCE_ID
, H.ORIG_SYS_DOCUMENT_REF
, H.ORDERED_DATE
, H.REQUEST_DATE
, H.TAX_EXEMPT_NUMBER
, H.CUST_PO_NUMBER
, H.SHIPPING_METHOD_CODE
, H.SOLD_TO_ORG_ID
, H.SHIP_TO_ORG_ID
, H.INVOICE_TO_ORG_ID
, H.DELIVER_TO_ORG_ID
, H.SOLD_TO_CONTACT_ID
, H.SHIP_TO_CONTACT_ID
, H.INVOICE_TO_CONTACT_ID
, H.DELIVER_TO_CONTACT_ID
, H.SALESREP_ID
, H.SOLD_FROM_ORG_ID
, H.SHIP_FROM_ORG_ID
, H.SHIPPING_INSTRUCTIONS
, H.PACKING_INSTRUCTIONS
, CURR.NAME TRANSACTIONAL_CURR_NAME
, TO_CHAR(OE_TOTALS_GRP.GET_ORDER_TOTAL(H.HEADER_ID
, NULL
, 'ALL')
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(H.TRANSACTIONAL_CURR_CODE
, 30)) ORDER_TOTAL
, TO_CHAR(OE_TOTALS_GRP.GET_ORDER_TOTAL(H.HEADER_ID
, NULL
, 'LINES')
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(H.TRANSACTIONAL_CURR_CODE
, 30)) LINES_TOTAL
, TO_CHAR(OE_TOTALS_GRP.GET_ORDER_TOTAL(H.HEADER_ID
, NULL
, 'CHARGES')
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(H.TRANSACTIONAL_CURR_CODE
, 30)) CHARGES_TOTAL
, TO_CHAR(OE_TOTALS_GRP.GET_ORDER_TOTAL(H.HEADER_ID
, NULL
, 'TAXES')
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(H.TRANSACTIONAL_CURR_CODE
, 30)) TAXES_TOTAL
, AGREE.NAME AGREEMENT_NAME
, AGREE.REVISION AGREEMENT_VERSION
, H.BLANKET_NUMBER
, BLANKET.VERSION_NUMBER BLANKET_VERSION_NUMBER
, INVRULE.NAME INVOICING_RULE_NAME
, TERM.NAME PAYMENT_TERMS
FROM OE_ORDER_HEADERS_ALL H
, RA_TERMS_TL TERM
, OE_TRANSACTION_TYPES_ALL OT
, OE_AGREEMENTS_TL AGREE
, OE_BLANKET_HEADERS_ALL BLANKET
, RA_RULES INVRULE
, FND_CURRENCIES_TL CURR
WHERE H.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID
AND OT.TRANSACTION_TYPE_CODE = 'ORDER'
AND H.AGREEMENT_ID = AGREE.AGREEMENT_ID(+)
AND AGREE.LANGUAGE(+) = USERENV('LANG')
AND H.BLANKET_NUMBER = BLANKET.ORDER_NUMBER(+)
AND H.INVOICING_RULE_ID = INVRULE.RULE_ID(+)
AND H.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND TERM.LANGUAGE(+) = USERENV('LANG')
AND H.TRANSACTIONAL_CURR_CODE = CURR.CURRENCY_CODE(+)
AND CURR.LANGUAGE(+) = USERENV('LANG')

Columns