VIEW: APPS.OE_PRN_ORDER_HEADERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')