VIEW: APPS.PO_PRICE_ADJS_ARCHIVE_XML

Source

View Text - Preformatted

SELECT adj.price_adjustment_id, TO_CHAR(adj.creation_date,'DD-MON-YYYY HH24:MI:SS') creation_date, adj.created_by, TO_CHAR(adj.last_update_date,'DD-MON-YYYY HH24:MI:SS') last_update_date, adj.last_updated_by, adj.last_update_login, adj.program_application_id, adj.program_id, TO_CHAR(adj.program_update_date,'DD-MON-YYYY HH24:MI:SS') program_update_date, adj.request_id, adj.po_header_id, adj.automatic_flag, adj.po_line_id, adj.adj_line_num, adj.context, adj.attribute1, adj.attribute2, adj.attribute3, adj.attribute4, adj.attribute5, adj.attribute6, adj.attribute7, adj.attribute8, adj.attribute9, adj.attribute10, adj.attribute11, adj.attribute12, adj.attribute13, adj.attribute14, adj.attribute15, adj.orig_sys_discount_ref, adj.change_sequence, adj.list_header_id, adj.list_type_code, adj.list_line_id, qlh.description, adj.list_line_type_code, flv.meaning, adj.modified_from, adj.modified_to, adj.update_allowed, adj.change_reason_code, adj.change_reason_text, adj.updated_flag, adj.applied_flag, adj.operand, adj.arithmetic_operator, adj.cost_id, adj.tax_code, adj.tax_exempt_flag, adj.tax_exempt_number, adj.tax_exempt_reason_code, adj.parent_adjustment_id, adj.invoiced_flag, adj.estimated_flag, adj.inc_in_sales_performance, TO_CHAR(ABS(adj.adjusted_amount),pgt.format_mask) adjusted_amount, adj.pricing_phase_id, adj.charge_type_code, adj.charge_subtype_code, adj.range_break_quantity, adj.accrual_conversion_rate, adj.pricing_group_sequence, adj.accrual_flag, adj.list_line_no, adj.source_system_code, adj.benefit_qty, adj.benefit_uom_code, adj.print_on_invoice_flag, TO_CHAR(adj.expiration_date,'DD-MON-YYYY HH24:MI:SS') expiration_date, adj.rebate_transaction_type_code, adj.rebate_transaction_reference, adj.rebate_payment_system_code, TO_CHAR(adj.redeemed_date,'DD-MON-YYYY HH24:MI:SS') redeemed_date, adj.redeemed_flag, adj.modifier_level_code, adj.price_break_type_code, adj.substitution_attribute, adj.proration_type_code, adj.include_on_returns_flag, adj.credit_or_charge_flag, adj.ac_context, adj.ac_attribute1, adj.ac_attribute2, adj.ac_attribute3, adj.ac_attribute4, adj.ac_attribute5, adj.ac_attribute6, adj.ac_attribute7, adj.ac_attribute8, adj.ac_attribute9, adj.ac_attribute10, adj.ac_attribute11, adj.ac_attribute12, adj.ac_attribute13, adj.ac_attribute14, adj.ac_attribute15, adj.operand_per_pqty, adj.adjusted_amount_per_pqty, adj.interco_invoiced_flag, adj.invoiced_amount, adj.retrobill_request_id, adj.tax_rate_id, adj.latest_external_flag, adj.revision_num FROM po_price_adjustments_archive adj, qp_list_headers qlh, fnd_lookup_values flv, fnd_application app, po_communication_gt pgt WHERE flv.language = USERENV('LANG') AND app.application_short_name = 'QP' AND flv.view_application_id = app.application_id AND flv.security_group_id = fnd_global.LOOKUP_SECURITY_GROUP(flv.lookup_type,flv.view_application_id) AND flv.lookup_type = 'LIST_LINE_TYPE_CODE' AND flv.lookup_code = adj.list_line_type_code AND adj.list_header_id = qlh.list_header_id

View Text - HTML Formatted

SELECT ADJ.PRICE_ADJUSTMENT_ID
, TO_CHAR(ADJ.CREATION_DATE
, 'DD-MON-YYYY HH24:MI:SS') CREATION_DATE
, ADJ.CREATED_BY
, TO_CHAR(ADJ.LAST_UPDATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.LAST_UPDATE_LOGIN
, ADJ.PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID
, TO_CHAR(ADJ.PROGRAM_UPDATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') PROGRAM_UPDATE_DATE
, ADJ.REQUEST_ID
, ADJ.PO_HEADER_ID
, ADJ.AUTOMATIC_FLAG
, ADJ.PO_LINE_ID
, ADJ.ADJ_LINE_NUM
, ADJ.CONTEXT
, ADJ.ATTRIBUTE1
, ADJ.ATTRIBUTE2
, ADJ.ATTRIBUTE3
, ADJ.ATTRIBUTE4
, ADJ.ATTRIBUTE5
, ADJ.ATTRIBUTE6
, ADJ.ATTRIBUTE7
, ADJ.ATTRIBUTE8
, ADJ.ATTRIBUTE9
, ADJ.ATTRIBUTE10
, ADJ.ATTRIBUTE11
, ADJ.ATTRIBUTE12
, ADJ.ATTRIBUTE13
, ADJ.ATTRIBUTE14
, ADJ.ATTRIBUTE15
, ADJ.ORIG_SYS_DISCOUNT_REF
, ADJ.CHANGE_SEQUENCE
, ADJ.LIST_HEADER_ID
, ADJ.LIST_TYPE_CODE
, ADJ.LIST_LINE_ID
, QLH.DESCRIPTION
, ADJ.LIST_LINE_TYPE_CODE
, FLV.MEANING
, ADJ.MODIFIED_FROM
, ADJ.MODIFIED_TO
, ADJ.UPDATE_ALLOWED
, ADJ.CHANGE_REASON_CODE
, ADJ.CHANGE_REASON_TEXT
, ADJ.UPDATED_FLAG
, ADJ.APPLIED_FLAG
, ADJ.OPERAND
, ADJ.ARITHMETIC_OPERATOR
, ADJ.COST_ID
, ADJ.TAX_CODE
, ADJ.TAX_EXEMPT_FLAG
, ADJ.TAX_EXEMPT_NUMBER
, ADJ.TAX_EXEMPT_REASON_CODE
, ADJ.PARENT_ADJUSTMENT_ID
, ADJ.INVOICED_FLAG
, ADJ.ESTIMATED_FLAG
, ADJ.INC_IN_SALES_PERFORMANCE
, TO_CHAR(ABS(ADJ.ADJUSTED_AMOUNT)
, PGT.FORMAT_MASK) ADJUSTED_AMOUNT
, ADJ.PRICING_PHASE_ID
, ADJ.CHARGE_TYPE_CODE
, ADJ.CHARGE_SUBTYPE_CODE
, ADJ.RANGE_BREAK_QUANTITY
, ADJ.ACCRUAL_CONVERSION_RATE
, ADJ.PRICING_GROUP_SEQUENCE
, ADJ.ACCRUAL_FLAG
, ADJ.LIST_LINE_NO
, ADJ.SOURCE_SYSTEM_CODE
, ADJ.BENEFIT_QTY
, ADJ.BENEFIT_UOM_CODE
, ADJ.PRINT_ON_INVOICE_FLAG
, TO_CHAR(ADJ.EXPIRATION_DATE
, 'DD-MON-YYYY HH24:MI:SS') EXPIRATION_DATE
, ADJ.REBATE_TRANSACTION_TYPE_CODE
, ADJ.REBATE_TRANSACTION_REFERENCE
, ADJ.REBATE_PAYMENT_SYSTEM_CODE
, TO_CHAR(ADJ.REDEEMED_DATE
, 'DD-MON-YYYY HH24:MI:SS') REDEEMED_DATE
, ADJ.REDEEMED_FLAG
, ADJ.MODIFIER_LEVEL_CODE
, ADJ.PRICE_BREAK_TYPE_CODE
, ADJ.SUBSTITUTION_ATTRIBUTE
, ADJ.PRORATION_TYPE_CODE
, ADJ.INCLUDE_ON_RETURNS_FLAG
, ADJ.CREDIT_OR_CHARGE_FLAG
, ADJ.AC_CONTEXT
, ADJ.AC_ATTRIBUTE1
, ADJ.AC_ATTRIBUTE2
, ADJ.AC_ATTRIBUTE3
, ADJ.AC_ATTRIBUTE4
, ADJ.AC_ATTRIBUTE5
, ADJ.AC_ATTRIBUTE6
, ADJ.AC_ATTRIBUTE7
, ADJ.AC_ATTRIBUTE8
, ADJ.AC_ATTRIBUTE9
, ADJ.AC_ATTRIBUTE10
, ADJ.AC_ATTRIBUTE11
, ADJ.AC_ATTRIBUTE12
, ADJ.AC_ATTRIBUTE13
, ADJ.AC_ATTRIBUTE14
, ADJ.AC_ATTRIBUTE15
, ADJ.OPERAND_PER_PQTY
, ADJ.ADJUSTED_AMOUNT_PER_PQTY
, ADJ.INTERCO_INVOICED_FLAG
, ADJ.INVOICED_AMOUNT
, ADJ.RETROBILL_REQUEST_ID
, ADJ.TAX_RATE_ID
, ADJ.LATEST_EXTERNAL_FLAG
, ADJ.REVISION_NUM
FROM PO_PRICE_ADJUSTMENTS_ARCHIVE ADJ
, QP_LIST_HEADERS QLH
, FND_LOOKUP_VALUES FLV
, FND_APPLICATION APP
, PO_COMMUNICATION_GT PGT
WHERE FLV.LANGUAGE = USERENV('LANG')
AND APP.APPLICATION_SHORT_NAME = 'QP'
AND FLV.VIEW_APPLICATION_ID = APP.APPLICATION_ID
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID)
AND FLV.LOOKUP_TYPE = 'LIST_LINE_TYPE_CODE'
AND FLV.LOOKUP_CODE = ADJ.LIST_LINE_TYPE_CODE
AND ADJ.LIST_HEADER_ID = QLH.LIST_HEADER_ID