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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AP.AP_SELF_ASSESSED_TAX_DIST_ALL#

Object Details

Object Name:	AP_SELF_ASSESSED_TAX_DIST_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)	Yes
ACCOUNTING_DATE	DATE		Yes
ACCRUAL_POSTED_FLAG	VARCHAR2	(1)	Yes
ASSETS_ADDITION_FLAG	VARCHAR2	(1)	Yes
ASSETS_TRACKING_FLAG	VARCHAR2	(1)	Yes
CASH_POSTED_FLAG	VARCHAR2	(1)	Yes
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes
DIST_CODE_COMBINATION_ID	NUMBER	(15)	Yes
INVOICE_ID	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
SELF_ASSESSED_FLAG	VARCHAR2	(1)	Yes
AMOUNT	NUMBER
BASE_AMOUNT	NUMBER
BATCH_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
DESCRIPTION	VARCHAR2	(240)
FINAL_MATCH_FLAG	VARCHAR2	(1)
INCOME_TAX_REGION	VARCHAR2	(10)
LAST_UPDATE_LOGIN	NUMBER	(15)
MATCH_STATUS_FLAG	VARCHAR2	(1)
POSTED_FLAG	VARCHAR2	(1)
PO_DISTRIBUTION_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
QUANTITY_INVOICED	NUMBER
REQUEST_ID	NUMBER	(15)
REVERSAL_FLAG	VARCHAR2	(1)
TYPE_1099	VARCHAR2	(10)
UNIT_PRICE	NUMBER
ENCUMBERED_FLAG	VARCHAR2	(1)
STAT_AMOUNT	NUMBER
EXPENDITURE_ITEM_DATE	DATE
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)
EXPENDITURE_TYPE	VARCHAR2	(30)
PARENT_INVOICE_ID	NUMBER	(15)
PA_ADDITION_FLAG	VARCHAR2	(1)
PA_QUANTITY	NUMBER	(22)
PREPAY_AMOUNT_REMAINING	NUMBER
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)
QUANTITY_VARIANCE	NUMBER
BASE_QUANTITY_VARIANCE	NUMBER
PACKET_ID	NUMBER	(15)
AWT_FLAG	VARCHAR2	(1)
AWT_GROUP_ID	NUMBER	(15)
AWT_TAX_RATE_ID	NUMBER	(15)
AWT_GROSS_AMOUNT	NUMBER
AWT_INVOICE_ID	NUMBER	(15)
AWT_ORIGIN_GROUP_ID	NUMBER	(15)
REFERENCE_1	VARCHAR2	(30)
REFERENCE_2	VARCHAR2	(30)
AWT_INVOICE_PAYMENT_ID	NUMBER	(15)
RECEIPT_VERIFIED_FLAG	VARCHAR2	(1)
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)
RECEIPT_MISSING_FLAG	VARCHAR2	(1)
JUSTIFICATION	VARCHAR2	(240)
EXPENSE_GROUP	VARCHAR2	(80)
START_EXPENSE_DATE	DATE
END_EXPENSE_DATE	DATE
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
RECEIPT_CONVERSION_RATE	NUMBER
RECEIPT_CURRENCY_AMOUNT	NUMBER
DAILY_AMOUNT	NUMBER
WEB_PARAMETER_ID	NUMBER
ADJUSTMENT_REASON	VARCHAR2	(240)
AWARD_ID	NUMBER	(15)
DIST_MATCH_TYPE	VARCHAR2	(25)
RCV_TRANSACTION_ID	NUMBER	(15)
PARENT_REVERSAL_ID	NUMBER	(15)
TAX_RECOVERABLE_FLAG	VARCHAR2	(1)
TAX_CODE_ID	NUMBER	(15)
MERCHANT_DOCUMENT_NUMBER	VARCHAR2	(80)
MERCHANT_NAME	VARCHAR2	(80)
MERCHANT_REFERENCE	VARCHAR2	(240)
MERCHANT_TAX_REG_NUMBER	VARCHAR2	(80)
MERCHANT_TAXPAYER_ID	VARCHAR2	(80)
COUNTRY_OF_SUPPLY	VARCHAR2	(5)
MATCHED_UOM_LOOKUP_CODE	VARCHAR2	(25)
GMS_BURDENABLE_RAW_COST	NUMBER	(22)
ACCOUNTING_EVENT_ID	NUMBER	(15)
PREPAY_DISTRIBUTION_ID	NUMBER	(15)
CREDIT_CARD_TRX_ID	NUMBER	(15)
UPGRADE_POSTED_AMT	NUMBER
UPGRADE_BASE_POSTED_AMT	NUMBER
INVENTORY_TRANSFER_STATUS	VARCHAR2	(1)
COMPANY_PREPAID_INVOICE_ID	NUMBER	(15)
CC_REVERSAL_FLAG	VARCHAR2	(1)
AWT_WITHHELD_AMT	NUMBER
PA_CMT_XFACE_FLAG	VARCHAR2	(1)
CANCELLATION_FLAG	VARCHAR2	(1)
INVOICE_LINE_NUMBER	NUMBER
ROUNDING_AMT	NUMBER
CHARGE_APPLICABLE_TO_DIST_ID	NUMBER	(15)
CORRECTED_INVOICE_DIST_ID	NUMBER	(15)
CORRECTED_QUANTITY	NUMBER
RELATED_ID	NUMBER	(15)
ASSET_BOOK_TYPE_CODE	VARCHAR2	(15)
ASSET_CATEGORY_ID	NUMBER	(15)
DISTRIBUTION_CLASS	VARCHAR2	(30)
INTENDED_USE	VARCHAR2	(30)
DETAIL_TAX_DIST_ID	NUMBER
REC_NREC_RATE	NUMBER
RECOVERY_RATE_ID	NUMBER
RECOVERY_RATE_NAME	VARCHAR2	(150)
RECOVERY_TYPE_CODE	VARCHAR2	(30)
WITHHOLDING_TAX_CODE_ID	NUMBER	(15)
TAX_ALREADY_DISTRIBUTED_FLAG	VARCHAR2	(1)
SUMMARY_TAX_LINE_ID	NUMBER
TAXABLE_AMOUNT	NUMBER
TAXABLE_BASE_AMOUNT	NUMBER
PREPAY_TAX_DIFF_AMOUNT	NUMBER
EXTRA_PO_ERV	NUMBER
SELF_ASSESSED_TAX_LIAB_CCID	NUMBER	(15)
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
PROJECT_ACCOUNTING_CONTEXT	VARCHAR2	(30)
RCV_CHARGE_ADDITION_FLAG	VARCHAR2	(1)
BC_EVENT_ID	NUMBER	(15)
AMOUNT_VARIANCE	NUMBER
BASE_AMOUNT_VARIANCE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_DISTRIBUTION_ID
,      ORG_ID
,      ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      ASSETS_ADDITION_FLAG
,      ASSETS_TRACKING_FLAG
,      CASH_POSTED_FLAG
,      DISTRIBUTION_LINE_NUMBER
,      DIST_CODE_COMBINATION_ID
,      INVOICE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LINE_TYPE_LOOKUP_CODE
,      PERIOD_NAME
,      SET_OF_BOOKS_ID
,      SELF_ASSESSED_FLAG
,      AMOUNT
,      BASE_AMOUNT
,      BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      FINAL_MATCH_FLAG
,      INCOME_TAX_REGION
,      LAST_UPDATE_LOGIN
,      MATCH_STATUS_FLAG
,      POSTED_FLAG
,      PO_DISTRIBUTION_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUANTITY_INVOICED
,      REQUEST_ID
,      REVERSAL_FLAG
,      TYPE_1099
,      UNIT_PRICE
,      ENCUMBERED_FLAG
,      STAT_AMOUNT
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      PARENT_INVOICE_ID
,      PA_ADDITION_FLAG
,      PA_QUANTITY
,      PREPAY_AMOUNT_REMAINING
,      PROJECT_ID
,      TASK_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      QUANTITY_VARIANCE
,      BASE_QUANTITY_VARIANCE
,      PACKET_ID
,      AWT_FLAG
,      AWT_GROUP_ID
,      AWT_TAX_RATE_ID
,      AWT_GROSS_AMOUNT
,      AWT_INVOICE_ID
,      AWT_ORIGIN_GROUP_ID
,      REFERENCE_1
,      REFERENCE_2
,      AWT_INVOICE_PAYMENT_ID
,      RECEIPT_VERIFIED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      RECEIPT_MISSING_FLAG
,      JUSTIFICATION
,      EXPENSE_GROUP
,      START_EXPENSE_DATE
,      END_EXPENSE_DATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      RECEIPT_CURRENCY_AMOUNT
,      DAILY_AMOUNT
,      WEB_PARAMETER_ID
,      ADJUSTMENT_REASON
,      AWARD_ID
,      DIST_MATCH_TYPE
,      RCV_TRANSACTION_ID
,      PARENT_REVERSAL_ID
,      TAX_RECOVERABLE_FLAG
,      TAX_CODE_ID
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_NAME
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      MATCHED_UOM_LOOKUP_CODE
,      GMS_BURDENABLE_RAW_COST
,      ACCOUNTING_EVENT_ID
,      PREPAY_DISTRIBUTION_ID
,      CREDIT_CARD_TRX_ID
,      UPGRADE_POSTED_AMT
,      UPGRADE_BASE_POSTED_AMT
,      INVENTORY_TRANSFER_STATUS
,      COMPANY_PREPAID_INVOICE_ID
,      CC_REVERSAL_FLAG
,      AWT_WITHHELD_AMT
,      PA_CMT_XFACE_FLAG
,      CANCELLATION_FLAG
,      INVOICE_LINE_NUMBER
,      ROUNDING_AMT
,      CHARGE_APPLICABLE_TO_DIST_ID
,      CORRECTED_INVOICE_DIST_ID
,      CORRECTED_QUANTITY
,      RELATED_ID
,      ASSET_BOOK_TYPE_CODE
,      ASSET_CATEGORY_ID
,      DISTRIBUTION_CLASS
,      INTENDED_USE
,      DETAIL_TAX_DIST_ID
,      REC_NREC_RATE
,      RECOVERY_RATE_ID
,      RECOVERY_RATE_NAME
,      RECOVERY_TYPE_CODE
,      WITHHOLDING_TAX_CODE_ID
,      TAX_ALREADY_DISTRIBUTED_FLAG
,      SUMMARY_TAX_LINE_ID
,      TAXABLE_AMOUNT
,      TAXABLE_BASE_AMOUNT
,      PREPAY_TAX_DIFF_AMOUNT
,      EXTRA_PO_ERV
,      SELF_ASSESSED_TAX_LIAB_CCID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      PROJECT_ACCOUNTING_CONTEXT
,      RCV_CHARGE_ADDITION_FLAG
,      BC_EVENT_ID
,      AMOUNT_VARIANCE
,      BASE_AMOUNT_VARIANCE
FROM AP.AP_SELF_ASSESSED_TAX_DIST_ALL#;

Dependencies

[top of page]

AP.AP_SELF_ASSESSED_TAX_DIST_ALL# references the following:

AP: AP_SELF_ASSESSED_TAX_DIST_ALL

AP.AP_SELF_ASSESSED_TAX_DIST_ALL# is referenced by following:

APPS: AP_SELF_ASSESSED_TAX_DIST; AP_SELF_ASSESSED_TAX_DIST_ALL