FND Design Data [Home] [Help]

View: JG_PO_TAX_LINES_SUMMARY_V

Product: JG - Regional Localizations
Description:
Implementation/DBA Data: ViewAPPS.JG_PO_TAX_LINES_SUMMARY_V
View Text

SELECT POH.PO_HEADER_ID
, POL.PO_LINE_ID
, POLL.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, POH.REQUEST_ID
, POH.SEGMENT1
, NULL
, POH.LAST_UPDATE_DATE
, POH.CURRENCY_CODE
, POH.RATE
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.PRECISION
, POH.VENDOR_ID
, NULL
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, POVS.COUNTRY
, POVS.STATE
, POVS.COUNTY
, NULL
, NULL
, POVS.ZIP
, NULL
, NULL
, POL.LINE_NUM
, PLT.LINE_TYPE
, POL.ITEM_ID
, MSI.SEGMENT1
, POLL.QUANTITY
, POD.QUANTITY_ORDERED
, POL.UNIT_PRICE
, POLL.PRICE_OVERRIDE
, POLL.TAXABLE_FLAG
, POD.CODE_COMBINATION_ID
, POH.FOB_LOOKUP_CODE
, NULL
, POL.USSGL_TRANSACTION_CODE
, POL.GOVERNMENT_CONTEXT
, POLL.SHIP_TO_LOCATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID
, NULL
, HRL.COUNTRY
, NULL
, NULL
, HRL.TOWN_OR_CITY
, NULL
, HRL.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL /*GET TAX_ID
FROM AP_TAX_CODES FOR TAX GROUP.*/
, ATC.TAX_ID
, NULL
, POLL.TAX_USER_OVERRIDE_FLAG
, ATC.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL /*CHANGE THE VIEW TO GET RECOVERY RATE
FROM DOCUMENT FOR A TAX GROUP.*/
, POD.RECOVERY_RATE
, POD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, POVS.AP_TAX_ROUNDING_RULE
, ATC.TAX_TYPE
, ATC.DESCRIPTION
, NULL
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_TYPE
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PO_HEADERS POH
, PO_LINES POL
, PO_LINE_LOCATIONS POLL
, PO_DISTRIBUTIONS POD
, PO_VENDORS POV
, PO_VENDOR_SITES POVS
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HR_LOCATIONS HRL
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMETERS FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES ATC
, AR_TAX_GROUP_CODES ATG
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POL.PO_HEADER_ID = POLL.PO_HEADER_ID
AND POLL.PO_HEADER_ID = POD.PO_HEADER_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND POLL.PO_LINE_ID = POD.PO_LINE_ID
AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.ORG_ID = NVL(MSI.ORGANIZATION_ID
, FSP.ORG_ID)
AND POL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND POH.VENDOR_ID = POV.VENDOR_ID
AND POH.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID
AND POLL.SHIP_TO_LOCATION_ID = HRL.LOCATION_ID
AND POH.CURRENCY_CODE = FC.CURRENCY_CODE(+)
AND POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND NVL(POLL.CALCULATE_TAX_FLAG
, 'Y') != 'N'
AND POLL.TAX_CODE_ID = ATG.TAX_GROUP_ID
AND ATG.TAX_GROUP_TYPE = 'AP'
AND ATG.TAX_CODE_ID = ATC.TAX_ID
AND ATG.START_DATE <= POH.LAST_UPDATE_DATE
AND NVL(ATG.END_DATE
, POH.LAST_UPDATE_DATE) >= POH.LAST_UPDATE_DATE
AND NVL(ATG.ENABLED_FLAG
, 'Y') = 'Y'
AND ATC.START_DATE <= POH.LAST_UPDATE_DATE
AND NVL(ATC.INACTIVE_DATE
, POH.LAST_UPDATE_DATE) >=POH.LAST_UPDATE_DATE
AND NVL(ATC.ENABLED_FLAG
, 'Y') = 'Y' UNION /*FOR TRANSACTIONS WITH REGULAR TAX CODE (TAX_TYPE <> 'TAX_GROUP') */ SELECT POH.PO_HEADER_ID
, POL.PO_LINE_ID
, POLL.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, POH.REQUEST_ID
, POH.SEGMENT1
, NULL
, POH.LAST_UPDATE_DATE
, POH.CURRENCY_CODE
, POH.RATE
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.PRECISION
, POH.VENDOR_ID
, NULL
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, POVS.COUNTRY
, POVS.STATE
, POVS.COUNTY
, NULL
, NULL
, POVS.ZIP
, NULL
, NULL
, POL.LINE_NUM
, PLT.LINE_TYPE
, POL.ITEM_ID
, MSI.SEGMENT1
, POLL.QUANTITY
, POD.QUANTITY_ORDERED
, POL.UNIT_PRICE
, POLL.PRICE_OVERRIDE
, POLL.TAXABLE_FLAG
, POD.CODE_COMBINATION_ID
, POH.FOB_LOOKUP_CODE
, NULL
, POL.USSGL_TRANSACTION_CODE
, POL.GOVERNMENT_CONTEXT
, POLL.SHIP_TO_LOCATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID
, NULL
, HRL.COUNTRY
, NULL
, NULL
, HRL.TOWN_OR_CITY
, NULL
, HRL.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL /*USE THE TAX_CODE_ID ON THE DOCUMENT FOR REGULAR TAX CODE. */
, POLL.TAX_CODE_ID
, NULL
, POLL.TAX_USER_OVERRIDE_FLAG
, ATC.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL /*USE THE RECOVERY_RATE ON THE DOCUMENT FOR REGULAR TAX CODE.*/
, POD.RECOVERY_RATE
, POD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, POVS.AP_TAX_ROUNDING_RULE
, ATC.TAX_TYPE
, ATC.DESCRIPTION
, NULL
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_TYPE
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PO_HEADERS POH
, PO_LINES POL
, PO_LINE_LOCATIONS POLL
, PO_DISTRIBUTIONS POD
, PO_VENDORS POV
, PO_VENDOR_SITES POVS
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HR_LOCATIONS HRL
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMETERS FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES ATC
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POL.PO_HEADER_ID = POLL.PO_HEADER_ID
AND POLL.PO_HEADER_ID = POD.PO_HEADER_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND POLL.PO_LINE_ID = POD.PO_LINE_ID
AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.ORG_ID = NVL(MSI.ORGANIZATION_ID
, FSP.ORG_ID)
AND POL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND POH.VENDOR_ID = POV.VENDOR_ID
AND POH.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID
AND POLL.SHIP_TO_LOCATION_ID = HRL.LOCATION_ID
AND POH.CURRENCY_CODE = FC.CURRENCY_CODE(+)
AND POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND NVL(POLL.CALCULATE_TAX_FLAG
, 'Y') != 'N'
AND POLL.TAX_CODE_ID = ATC.TAX_ID(+)
AND ATC.TAX_TYPE <> 'TAX_GROUP'

Columns

Name
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