VIEW: APPS.AP_ALLOCATED_LINES_V

Source

View Text - Preformatted

SELECT arl.invoice_id, arl.to_invoice_line_number, ail.line_number, ail.line_type_lookup_code chrg_type_lookup_code, alc.displayed_field chrg_type, ail.description, ail.amount chrg_line_amount, arl.percentage allocated_percentage, arl.amount, arl.created_by, arl.creation_date, arl.last_updated_by, arl.last_update_date, arl.last_update_login FROM ap_invoice_lines ail, ap_allocation_rule_lines arl, ap_lookup_codes alc WHERE ail.invoice_id = arl.invoice_id AND ail.line_number = arl.chrg_invoice_line_number AND ail.line_type_lookup_code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX') AND alc.lookup_type = 'INVOICE LINE TYPE' AND ail.line_type_lookup_code = alc.lookup_code UNION SELECT arl.invoice_id, arl.to_invoice_line_number, ail.line_number, ail.line_type_lookup_code chrg_type_lookup_code, alc.displayed_field chrg_type, ail.description, ail.amount chrg_line_amount, arl.percentage allocated_percentage, arl.amount, arl.created_by, arl.creation_date, arl.last_updated_by, arl.last_update_date, arl.last_update_login FROM ap_invoice_lines ail, ap_allocation_rule_lines_gt arl, ap_lookup_codes alc WHERE ail.invoice_id = arl.invoice_id AND ail.line_number = arl.chrg_invoice_line_number AND ail.line_type_lookup_code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX') AND alc.lookup_type = 'INVOICE LINE TYPE' AND ail.line_type_lookup_code = alc.lookup_code

View Text - HTML Formatted

SELECT ARL.INVOICE_ID
, ARL.TO_INVOICE_LINE_NUMBER
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE CHRG_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD CHRG_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT CHRG_LINE_AMOUNT
, ARL.PERCENTAGE ALLOCATED_PERCENTAGE
, ARL.AMOUNT
, ARL.CREATED_BY
, ARL.CREATION_DATE
, ARL.LAST_UPDATED_BY
, ARL.LAST_UPDATE_DATE
, ARL.LAST_UPDATE_LOGIN
FROM AP_INVOICE_LINES AIL
, AP_ALLOCATION_RULE_LINES ARL
, AP_LOOKUP_CODES ALC
WHERE AIL.INVOICE_ID = ARL.INVOICE_ID
AND AIL.LINE_NUMBER = ARL.CHRG_INVOICE_LINE_NUMBER
AND AIL.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT'
, 'MISCELLANEOUS'
, 'TAX')
AND ALC.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND AIL.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE UNION SELECT ARL.INVOICE_ID
, ARL.TO_INVOICE_LINE_NUMBER
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE CHRG_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD CHRG_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT CHRG_LINE_AMOUNT
, ARL.PERCENTAGE ALLOCATED_PERCENTAGE
, ARL.AMOUNT
, ARL.CREATED_BY
, ARL.CREATION_DATE
, ARL.LAST_UPDATED_BY
, ARL.LAST_UPDATE_DATE
, ARL.LAST_UPDATE_LOGIN
FROM AP_INVOICE_LINES AIL
, AP_ALLOCATION_RULE_LINES_GT ARL
, AP_LOOKUP_CODES ALC
WHERE AIL.INVOICE_ID = ARL.INVOICE_ID
AND AIL.LINE_NUMBER = ARL.CHRG_INVOICE_LINE_NUMBER
AND AIL.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT'
, 'MISCELLANEOUS'
, 'TAX')
AND ALC.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND AIL.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE