eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.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 (+)

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.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 (+)