View: AP_INVOICE_LINES_INTERFACE_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_INVOICE_LINES_INTERFACE_V

View Text

SELECT AILI.ROWID
, AILI.ACCOUNTING_DATE
, AILI.AMOUNT
, AILI.ASSETS_TRACKING_FLAG
, AILI.PRICE_CORRECTION_FLAG
, AILI.ATTRIBUTE1
, AILI.ATTRIBUTE10
, AILI.ATTRIBUTE11
, AILI.ATTRIBUTE12
, AILI.ATTRIBUTE13
, AILI.ATTRIBUTE14
, AILI.ATTRIBUTE15
, AILI.ATTRIBUTE2
, AILI.ATTRIBUTE3
, AILI.ATTRIBUTE4
, AILI.ATTRIBUTE5
, AILI.ATTRIBUTE6
, AILI.ATTRIBUTE7
, AILI.ATTRIBUTE8
, AILI.ATTRIBUTE9
, AILI.ATTRIBUTE_CATEGORY
, AILI.GLOBAL_ATTRIBUTE10
, AILI.GLOBAL_ATTRIBUTE11
, AILI.GLOBAL_ATTRIBUTE12
, AILI.GLOBAL_ATTRIBUTE13
, AILI.GLOBAL_ATTRIBUTE14
, AILI.GLOBAL_ATTRIBUTE15
, AILI.GLOBAL_ATTRIBUTE16
, AILI.GLOBAL_ATTRIBUTE17
, AILI.GLOBAL_ATTRIBUTE18
, AILI.GLOBAL_ATTRIBUTE19
, AILI.GLOBAL_ATTRIBUTE20
, AILI.GLOBAL_ATTRIBUTE1
, AILI.GLOBAL_ATTRIBUTE2
, AILI.GLOBAL_ATTRIBUTE3
, AILI.GLOBAL_ATTRIBUTE4
, AILI.GLOBAL_ATTRIBUTE5
, AILI.GLOBAL_ATTRIBUTE6
, AILI.GLOBAL_ATTRIBUTE7
, AILI.GLOBAL_ATTRIBUTE8
, AILI.GLOBAL_ATTRIBUTE9
, AILI.GLOBAL_ATTRIBUTE_CATEGORY
, AILI.AWT_GROUP_ID
, AILI.CREATED_BY
, AILI.CREATION_DATE
, AILI.DESCRIPTION
, AILI.LINE_NUMBER
, AILI.DIST_CODE_COMBINATION_ID
, AILI.DIST_CODE_CONCATENATED
, AILI.DISTRIBUTION_SET_ID
, AILI.EXPENDITURE_ITEM_DATE
, AILI.EXPENDITURE_ORGANIZATION_ID
, AILI.EXPENDITURE_TYPE
, AILI.FINAL_MATCH_FLAG
, AILI.INVOICE_ID
, AILI.INVOICE_LINE_ID
, AILI.AMOUNT_INCLUDES_TAX_FLAG
, AILI.PRORATE_ACROSS_FLAG
, AILI.LAST_UPDATED_BY
, AILI.LAST_UPDATE_DATE
, AILI.LAST_UPDATE_LOGIN
, AILI.LINE_TYPE_LOOKUP_CODE
, AILI.LINE_GROUP_NUMBER
, AILI.PA_ADDITION_FLAG
, AILI.PA_QUANTITY
, AILI.PO_DISTRIBUTION_ID
, AILI.PO_LINE_LOCATION_ID
, AILI.PO_RELEASE_ID
, AILI.PO_LINE_ID
, AILI.INVENTORY_ITEM_ID
, AILI.PO_HEADER_ID
, AILI.PROJECT_ACCOUNTING_CONTEXT
, AILI.PROJECT_ID
, AILI.QUANTITY_INVOICED
, AILI.STAT_AMOUNT
, AILI.TASK_ID
, AILI.TYPE_1099
, AILI.UNIT_PRICE
, AILI.TAX_CODE
, AILI.UNIT_OF_MEAS_LOOKUP_CODE
, AILI.INCOME_TAX_REGION
, AILI.ACCOUNT_SEGMENT
, AILI.BALANCING_SEGMENT
, AILI.COST_CENTER_SEGMENT
, ADS.DISTRIBUTION_SET_NAME
, ALC.DISPLAYED_FIELD
, AAG.NAME
, PP.SEGMENT1
, PT.TASK_NUMBER
, HOU.NAME
, NVL(PH.CLM_DOCUMENT_NUMBER
, PH.SEGMENT1) /*9481666 - CLM*/
, NVL(PL.LINE_NUM_DISPLAY
, TO_CHAR(PL.LINE_NUM)) /*9481666 - CLM*/
, PL.ITEM_DESCRIPTION
, PLL.SHIPMENT_NUM
, HL.LOCATION_CODE
, PR.RELEASE_NUM
, PD.DISTRIBUTION_NUM
, PL.UNIT_MEAS_LOOKUP_CODE
, AILI.ORG_ID
, AILI.TAX_RECOVERY_RATE
, AILI.TAX_RECOVERY_OVERRIDE_FLAG
, AILI.TAX_RECOVERABLE_FLAG
, AILI.TAX_CODE_OVERRIDE_FLAG
, AILI.TAX_CODE_ID
, ATC.NAME
, AILI.RECEIPT_NUMBER
, AILI.RECEIPT_LINE_NUMBER
, AILI.RCV_TRANSACTION_ID
, AILI.MATCH_OPTION
, AILI.AWARD_ID
, AILI.PRICE_CORRECT_INV_NUM
, AILI.PRICE_CORRECT_INV_LINE_NUM
, AILI.SERIAL_NUMBER
, AILI.MANUFACTURER
, AILI.MODEL_NUMBER
, AILI.WARRANTY_NUMBER
, AILI.ASSET_BOOK_TYPE_CODE
, AILI.ASSET_CATEGORY_ID
, AILI.DEFERRED_ACCTG_FLAG
, AILI.DEF_ACCTG_START_DATE
, AILI.DEF_ACCTG_END_DATE
, AILI.DEF_ACCTG_NUMBER_OF_PERIODS
, AILI.DEF_ACCTG_PERIOD_TYPE
, AILI.REQUESTER_FIRST_NAME
, AILI.REQUESTER_LAST_NAME
, AILI.REQUESTER_EMPLOYEE_NUM
, AILI.REQUESTER_ID
, AILI.CONTROL_AMOUNT
, AILI.ASSESSABLE_VALUE
, AILI.DEFAULT_DIST_CCID
, AILI.PRIMARY_INTENDED_USE
, AILI.SHIP_TO_LOCATION_ID
, AILI.PRODUCT_TYPE
, AILI.PRODUCT_CATEGORY
, AILI.PRODUCT_FISC_CLASSIFICATION
, AILI.USER_DEFINED_FISC_CLASS
, AILI.TRX_BUSINESS_CATEGORY
, AILI.TAX_REGIME_CODE
, AILI.TAX
, AILI.TAX_JURISDICTION_CODE
, AILI.TAX_STATUS_CODE
, AILI.TAX_RATE_ID
, AILI.TAX_RATE_CODE
, AILI.TAX_RATE
, AILI.INCL_IN_TAXABLE_LINE_FLAG
, AILI.PURCHASING_CATEGORY
, AILI.PURCHASING_CATEGORY_ID
, AILI.COST_FACTOR_ID
, AILI.COST_FACTOR_NAME
, AILI.TAX_CLASSIFICATION_CODE
, AILI.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID /*BUG 7439828*/
, AAG1.NAME PAY_AWT_GROUP_NAME /*BUG 7439828*/ FROM AP_INVOICE_LINES_INTERFACE AILI
, AP_INVOICES_INTERFACE AII
, AP_AWT_GROUPS AAG
, AP_AWT_GROUPS AAG1
, /*BUG 7439828*/ AP_LOOKUP_CODES ALC
, AP_DISTRIBUTION_SETS ADS
, HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, PA_PROJECTS_ALL PP
, PA_TASKS_EXPEND_V PT
, /*BUG 16391730*/ PO_DISTRIBUTIONS PD
, PO_HEADERS PH
, PO_LINES PL
, PO_RELEASES PR
, PO_LINE_LOCATIONS PLL
, AP_TAX_CODES ATC WHERE AILI.INVOICE_ID = AII.INVOICE_ID AND ALC.LOOKUP_TYPE (+) = 'INVOICE LINE TYPE' AND ALC.LOOKUP_CODE (+) = AILI.LINE_TYPE_LOOKUP_CODE AND AILI.DISTRIBUTION_SET_ID = ADS.DISTRIBUTION_SET_ID (+) AND AILI.PROJECT_ID = PP.PROJECT_ID (+) AND AILI.TASK_ID = PT.TASK_ID(+) AND AILI.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+) AND AILI.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID (+) AND AILI.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID (+) AND AILI.PO_RELEASE_ID = PR.PO_RELEASE_ID (+) AND AILI.PO_LINE_ID = PL.PO_LINE_ID (+) AND AILI.PO_HEADER_ID = PH.PO_HEADER_ID (+) AND PLL.SHIP_TO_LOCATION_ID = HL.LOCATION_ID (+) AND AILI.AWT_GROUP_ID = AAG.GROUP_ID (+) AND AILI.PAY_AWT_GROUP_ID = AAG1.GROUP_ID (+) /*BUG 7439828*/ AND AILI.TAX_CODE_ID = ATC.TAX_ID (+)

Columns