eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OE_ACCRUALS_V

Product:	ONT - Order Management
Description:	This view shows accrued price adjustments in Order Management System.
Implementation/DBA Data:	APPS.OE_ACCRUALS_V

View Text

SELECT PA.PRICE_ADJUSTMENT_ID
, PA.HEADER_ID
, PA.LINE_ID
, STO.CUSTOMER_ID
, STO.CUSTOMER_NUMBER
, STO.NAME
, PA.LIST_HEADER_ID
, PA.LIST_LINE_ID
, PA.LIST_LINE_NO
, PA.SOURCE_SYSTEM_CODE
, PA.ARITHMETIC_OPERATOR
, PA.OPERAND
, DECODE(OL.LINE_CATEGORY_CODE
, 'RETURN'
, (-1) * PA.BENEFIT_QTY
, PA.BENEFIT_QTY)
, PA.BENEFIT_UOM_CODE
, DECODE(OL.LINE_CATEGORY_CODE
, 'RETURN'
, (-1) * PA.ADJUSTED_AMOUNT
, PA.ADJUSTED_AMOUNT) * NVL(OL.ORDERED_QUANTITY
, 1)
, PA.PRINT_ON_INVOICE_FLAG
, PA.EXPIRATION_DATE
, PA.REBATE_TRANSACTION_TYPE_CODE
, PA.REBATE_TRANSACTION_REFERENCE
, PA.REBATE_PAYMENT_SYSTEM_CODE
, PA.REDEEMED_DATE
, PA.REDEEMED_FLAG
, OH.ORG_ID
FROM OE_PRICE_ADJUSTMENTS PA
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS OH
, OE_SOLD_TO_ORGS_V STO
WHERE PA.HEADER_ID = OH.HEADER_ID
AND PA.LINE_ID = OL.LINE_ID (+)
AND STO.ORGANIZATION_ID = OH.SOLD_TO_ORG_ID
AND PA.ACCRUAL_FLAG = 'Y'
AND PA.APPLIED_FLAG = 'Y'
AND PA.LIST_LINE_TYPE_CODE NOT IN ('CIE'
, 'PBH') UNION SELECT PA.PRICE_ADJUSTMENT_ID
, PA.HEADER_ID
, PA.LINE_ID
, STO.CUSTOMER_ID
, STO.CUSTOMER_NUMBER
, STO.NAME
, PA.LIST_HEADER_ID
, PA.LIST_LINE_ID
, PA.LIST_LINE_NO
, PA.SOURCE_SYSTEM_CODE
, PA.ARITHMETIC_OPERATOR
, PA.OPERAND
, DECODE(OL.LINE_CATEGORY_CODE
, 'RETURN'
, (-1)* PA.BENEFIT_QTY
, PA.BENEFIT_QTY)
, PA.BENEFIT_UOM_CODE
, DECODE(OL.LINE_CATEGORY_CODE
, 'RETURN'
, (-1)* PA.ADJUSTED_AMOUNT
, PA.ADJUSTED_AMOUNT) * NVL(OL.ORDERED_QUANTITY
, 1)
, PA.PRINT_ON_INVOICE_FLAG
, PA.EXPIRATION_DATE
, PA.REBATE_TRANSACTION_TYPE_CODE
, PA.REBATE_TRANSACTION_REFERENCE
, PA.REBATE_PAYMENT_SYSTEM_CODE
, PA.REDEEMED_DATE
, PA.REDEEMED_FLAG
, OH.ORG_ID
FROM OE_PRICE_ADJUSTMENTS PA
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS OH
, OE_SOLD_TO_ORGS_V STO
, OE_PRICE_ADJ_ASSOCS PAA
, OE_PRICE_ADJUSTMENTS PAP
WHERE PA.HEADER_ID = OH.HEADER_ID
AND PA.LINE_ID = OL.LINE_ID
AND STO.ORGANIZATION_ID = OH.SOLD_TO_ORG_ID
AND PA.ACCRUAL_FLAG = 'Y'
AND PA.PRICE_ADJUSTMENT_ID = PAA.RLTD_PRICE_ADJ_ID
AND PAP.PRICE_ADJUSTMENT_ID = PAA.PRICE_ADJUSTMENT_ID
AND PAP.LIST_LINE_TYPE_CODE = 'PBH'
AND PAP.APPLIED_FLAG = 'Y'
AND NVL(PA.RANGE_BREAK_QUANTITY
, 0) <> 0

Columns

Name
PRICE_ADJUSTMENT_ID
ORDER_HEADER_ID
ORDER_LINE_ID
CUSTOMER_ID
CUSTOMER_NUMBER
CUSTOMER_NAME
LIST_HEADER_ID
LIST_LINE_ID
LIST_LINE_NO
SOURCE_SYSTEM_CODE
ARITHMETIC_OPERATOR
OPERAND
BENEFIT_QTY
BENEFIT_UOM_CODE
ADJUSTED_AMOUNT
PRINT_ON_INVOICE_FLAG
EXPIRATION_DATE
REBATE_TRANSACTION_TYPE_CODE
REBATE_TRANSACTION_REFERENCE
REBATE_PAYMENT_SYSTEM_CODE
REDEEMED_DATE
REDEEMED_FLAG
ORG_ID