[Home] [Help] [Dependency Information]

VIEW: APPS.JG_AP_TAX_LINES_SUMMARY_V

Object Details

Object Name:	JG_AP_TAX_LINES_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JG.JG_AP_TAX_LINES_SUMMARY_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT TRX_HEADER_ID
,      TRX_LINE_ID
,      TRX_SHIPMENT_ID
,      TRX_DISTRIBUTION_ID
,      TAX_LINE_NUMBER
,      SET_OF_BOOKS_ID
,      REQUEST_ID
,      TRX_NUMBER
,      PREVIOUS_TRX_HEADER_ID
,      TRX_DATE
,      TRX_CURRENCY_CODE
,      EXCHANGE_RATE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      SHIP_FROM_SUPPLIER_ID
,      SHIP_FROM_SUPPLIER_NUMBER
,      SHIP_FROM_SUPPLIER_NAME
,      SHIP_FROM_SITE_USE_ID
,      SHIP_FROM_COUNTRY
,      SHIP_FROM_STATE
,      SHIP_FROM_COUNTY
,      SHIP_FROM_CITY
,      SHIP_FROM_PROVINCE
,      SHIP_FROM_POSTAL_CODE
,      SHIP_FROM_IN_CITY_LIMITS_FLAG
,      SHIP_FROM_GEOCODE
,      LINE_NUMBER
,      TRX_LINE_TYPE
,      INVENTORY_ITEM_ID
,      PART_NUMBER
,      QUANTITY
,      QUANTITY_ORDERED
,      UNIT_PRICE
,      PRICE_OVERRIDE
,      TAXABLE_FLAG
,      CODE_COMBINATION_ID
,      FOB_CODE
,      PREVIOUS_TRX_LINE_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_WAREHOUSE_ID
,      SHIP_TO_COUNTRY
,      SHIP_TO_STATE
,      SHIP_TO_COUNTY
,      SHIP_TO_CITY
,      SHIP_TO_PROVINCE
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_IN_CITY_LIMITS_FLAG
,      SHIP_TO_GEOCODE
,      POO_ADDRESS_CODE
,      POA_ADDRESS_CODE
,      TAX_CODE_ID
,      TAX_CODE
,      TAX_USER_OVERRIDE_FLAG
,      TAX_RATE
,      TOTAL_TAX_AMOUNT
,      RECOVERABLE_TAX
,      NONRECOVERABLE_TAX
,      LOCATION_QUALIFIER
,      COMPOUNDING_PRECEDENCE
,      TAX_EXEMPTION_ID
,      TAX_EXCEPTION_ID
,      VENDOR_CONTROL_EXEMPTIONS
,      TAX_RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_NUMERIC_ATTRIBUTE1
,      GLOBAL_NUMERIC_ATTRIBUTE2
,      GLOBAL_NUMERIC_ATTRIBUTE3
,      GLOBAL_NUMERIC_ATTRIBUTE4
,      GLOBAL_NUMERIC_ATTRIBUTE5
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      COMPANY_CODE
,      DIVISION_CODE
,      AUDIT_FLAG
,      TAX_HEADER_LEVEL_FLAG
,      TAX_ROUNDING_RULE
,      TAX_TYPE
,      TAX_DESCRIPTION
,      ALLOW_TAX_CODE_OVERRIDE_FLAG
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ITEM_DATE
,      PA_QUANTITY
,      TAX_MINIMUM_ACCOUNTABLE_UNIT
,      TAX_PRECISION
,      AMOUNT_INCLUDES_TAX_FLAG
,      TAX_CALCULATED_FLAG
,      TAX_RECOVERABLE_FLAG
,      CURRENCY_UNIT_PRICE
,      ACCOUNT_GL_DATE
FROM APPS.JG_AP_TAX_LINES_SUMMARY_V;

Dependencies

[top of page]

APPS

AP_INVOICES

AP_INVOICE_DISTRIBUTIONS

AP_TAX_CODES

AP_TAX_ENGINE_PKG - show dependent code

AP_UTILITIES_PKG - show dependent code

AR_TAX_GROUP_CODES

FINANCIALS_SYSTEM_PARAMETERS

PO_VENDORS

PO_VENDOR_SITES

APPS.JG_AP_TAX_LINES_SUMMARY_V is not referenced by any database object