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.

[Home] [Help]

View: PO_REL_TAX_LINES_SUMMARY_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT POR.PO_RELEASE_ID
, NULL
, POLL.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, POR.REQUEST_ID
, NULL
, NULL
, POR.LAST_UPDATE_DATE
, POH.CURRENCY_CODE
, NULL
, 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
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, POLL.AMOUNT
, POLL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, POD.AMOUNT_ORDERED
, POD.QUANTITY_ORDERED)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, POLL.PRICE_OVERRIDE)
, POLL.TAXABLE_FLAG
, POD.CODE_COMBINATION_ID
, POLL.FOB_LOOKUP_CODE
, NULL
, POLL.USSGL_TRANSACTION_CODE
, POLL.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
, ATC2.TAX_ID
, NULL
, POLL.TAX_USER_OVERRIDE_FLAG
, ATC2.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, POD.RECOVERY_RATE
, POD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(POVS.AUTO_TAX_CALC_FLAG
, 'N')
, POVS.AP_TAX_ROUNDING_RULE
, ATC2.TAX_TYPE
, ATC2.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
, POR.ORG_ID
FROM PO_RELEASES POR
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_VENDOR_SITES_ALL POVS
, PO_HEADERS_ALL POH
, PO_VENDORS POV
, PO_LINE_LOCATIONS_ALL POLL
, PO_LINES_ALL POL
, PO_DISTRIBUTIONS_ALL POD
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HR_LOCATIONS_ALL HRL
, FND_CURRENCIES FC
, AP_TAX_CODES_ALL ATC1
, AP_TAX_CODES_ALL ATC2
, AR_TAX_GROUP_CODES_ALL ATG
WHERE POR.PO_RELEASE_ID = POLL.PO_RELEASE_ID
AND POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND POLL.PO_RELEASE_ID = POD.PO_RELEASE_ID
AND POLL.PO_LINE_ID = POD.PO_LINE_ID
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND POR.ORG_ID = FSP.ORG_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 = ATC1.TAX_ID
AND ATC1.TAX_TYPE = 'TAX_GROUP'
AND ATG.TAX_GROUP_ID(+) = ATC1.TAX_ID
AND ATG.TAX_CODE_ID = ATC2.TAX_ID(+)
AND NVL(ATG.TAX_GROUP_TYPE
, 'AP') = 'AP'
AND NVL(ATG.START_DATE
, POR.LAST_UPDATE_DATE) <= POR.LAST_UPDATE_DATE
AND NVL(ATG.END_DATE
, POR.LAST_UPDATE_DATE) >= POR.LAST_UPDATE_DATE
AND NVL(ATG.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(ATC2.START_DATE
, POR.LAST_UPDATE_DATE) <= POR.LAST_UPDATE_DATE
AND NVL(ATC2.INACTIVE_DATE
, POR.LAST_UPDATE_DATE) >=POR.LAST_UPDATE_DATE
AND NVL(ATC2.ENABLED_FLAG
, 'Y') = 'Y'
AND ATC2.ORG_ID = POR.ORG_ID
AND ATG.ORG_ID = POR.ORG_ID /* BUG 3428139 START */
AND NVL(POD.ENCUMBERED_FLAG
, 'N') <> 'Y'
AND NVL(POLL.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(POLL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED' /* BUG 3428139 END */ UNION ALL /* FOR TRANSACTIONS WITH A REGULAR TAX CODE (TAX_TYPE <> 'TAX_GROUP'). */ SELECT POR.PO_RELEASE_ID
, NULL
, POLL.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, POR.REQUEST_ID
, NULL
, NULL
, POR.LAST_UPDATE_DATE
, POH.CURRENCY_CODE
, NULL
, 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
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, POLL.AMOUNT
, POLL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, POD.AMOUNT_ORDERED
, POD.QUANTITY_ORDERED)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, POLL.PRICE_OVERRIDE)
, POLL.TAXABLE_FLAG
, POD.CODE_COMBINATION_ID
, POLL.FOB_LOOKUP_CODE
, NULL
, POLL.USSGL_TRANSACTION_CODE
, POLL.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_CODE_ID DIRECTLY
FROM DOCUMENT FOR REGULAR TAX CODE (TAX_TYPE <> 'TAX_GROUP'). */
, POLL.TAX_CODE_ID
, NULL
, POLL.TAX_USER_OVERRIDE_FLAG
, ATC.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL /*GET RECOVERY_RATE DIRECTLY
FROM DOCUMENT FOR REGULAR TAX CODE (TAX_TYPE <> '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
, NVL(POVS.AUTO_TAX_CALC_FLAG
, 'N')
, 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
, POR.ORG_ID
FROM PO_RELEASES POR
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_HEADERS_ALL POH
, PO_VENDOR_SITES_ALL POVS
, PO_VENDORS POV
, PO_LINE_LOCATIONS_ALL POLL
, PO_LINES_ALL POL
, PO_DISTRIBUTIONS_ALL POD
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HR_LOCATIONS_ALL HRL
, FND_CURRENCIES FC
, AP_TAX_CODES_ALL ATC
WHERE POR.PO_RELEASE_ID = POLL.PO_RELEASE_ID
AND POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND POLL.PO_RELEASE_ID = POD.PO_RELEASE_ID
AND POLL.PO_LINE_ID = POD.PO_LINE_ID
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND POR.ORG_ID = FSP.ORG_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' /* BUG 3428139 START */
AND NVL(POD.ENCUMBERED_FLAG
, 'N') <> 'Y'
AND NVL(POLL.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(POLL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED' /* BUG 3428139 END */

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
ORG_ID