VIEW: APPS.OE_ACCRUALS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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