VIEW: APPS.AP_INVOICE_LINES_INTERFACE_V

Source

View Text - Preformatted

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.USSGL_TRANSACTION_CODE , 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 , PH.SEGMENT1 , PL.LINE_NUM , 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, AAG1.NAME PAY_AWT_GROUP_NAME FROM AP_INVOICE_LINES_INTERFACE AILI , AP_INVOICES_INTERFACE AII, AP_AWT_GROUPS AAG , AP_AWT_GROUPS AAG1, AP_LOOKUP_CODES ALC , AP_DISTRIBUTION_SETS ADS , HR_ORGANIZATION_UNITS HOU , HR_LOCATIONS HL , PA_PROJECTS_ALL PP , PA_TASKS PT , 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.TAX_CODE_ID = ATC.TAX_ID (+) AND AILI.PAY_AWT_GROUP_ID=AAG1.GROUP_ID(+)

View Text - HTML Formatted

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.USSGL_TRANSACTION_CODE
, 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
, PH.SEGMENT1
, PL.LINE_NUM
, 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
, AAG1.NAME PAY_AWT_GROUP_NAME
FROM AP_INVOICE_LINES_INTERFACE AILI
, AP_INVOICES_INTERFACE AII
, AP_AWT_GROUPS AAG
, AP_AWT_GROUPS AAG1
, AP_LOOKUP_CODES ALC
, AP_DISTRIBUTION_SETS ADS
, HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, PA_PROJECTS_ALL PP
, PA_TASKS PT
, 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.TAX_CODE_ID = ATC.TAX_ID (+)
AND AILI.PAY_AWT_GROUP_ID=AAG1.GROUP_ID(+)