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_TAX_LINES_SUMMARY_V

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

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
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POLL.AMOUNT
, 'FIXED PRICE'
, POLL.AMOUNT
, POLL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POD.AMOUNT_ORDERED
, 'FIXED PRICE'
, POD.AMOUNT_ORDERED
, POD.QUANTITY_ORDERED)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, 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.*/
, ATC2.TAX_ID
, NULL
, POLL.TAX_USER_OVERRIDE_FLAG
, ATC2.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
, 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
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_ALL HRL
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMETERS FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES ATC1
, AP_TAX_CODES ATC2
, 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.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND NVL(ATC2.ORG_ID
, NVL(FSP.ORG_ID
, -99)) = NVL(FSP.ORG_ID
, -99)
AND NVL(ATC1.ORG_ID
, -99) = NVL(FSP.ORG_ID
, -99)
AND NVL(ATG.ORG_ID
, NVL(FSP.ORG_ID
, -99)) = NVL(FSP.ORG_ID
, -99)
AND POL.CATEGORY_ID = MC.CATEGORY_ID(+) /* BUG 4019786 START */
AND POH.VENDOR_ID = POV.VENDOR_ID(+)
AND POH.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID(+) /* BUG 4019786 END */
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
, POH.LAST_UPDATE_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 NVL(ATC2.START_DATE
, POH.LAST_UPDATE_DATE) <= POH.LAST_UPDATE_DATE
AND NVL(ATC2.INACTIVE_DATE
, POH.LAST_UPDATE_DATE) >=POH.LAST_UPDATE_DATE
AND NVL(ATC2.ENABLED_FLAG
, 'Y') = 'Y' /* 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 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
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POLL.AMOUNT
, 'FIXED PRICE'
, POLL.AMOUNT
, POLL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POD.AMOUNT_ORDERED
, 'FIXED PRICE'
, POD.AMOUNT_ORDERED
, POD.QUANTITY_ORDERED)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, 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
, HZ.COUNTRY
, NULL
, NULL
, HZ.CITY
, NULL
, HZ.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
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
, HZ_LOCATIONS HZ
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMETERS FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES ATC1
, AP_TAX_CODES ATC2
, 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.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND NVL(ATC1.ORG_ID
, -99) = NVL(FSP.ORG_ID
, -99)
AND NVL(ATC2.ORG_ID
, NVL(FSP.ORG_ID
, -99)) = NVL(FSP.ORG_ID
, -99)
AND NVL(ATG.ORG_ID
, NVL(FSP.ORG_ID
, -99)) = NVL(FSP.ORG_ID
, -99)
AND POL.CATEGORY_ID = MC.CATEGORY_ID(+) /* BUG 4019786 START */
AND POH.VENDOR_ID = POV.VENDOR_ID(+)
AND POH.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID(+) /* BUG 4019786 END */
AND POLL.SHIP_TO_LOCATION_ID = HZ.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
, POH.LAST_UPDATE_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 NVL(ATC2.START_DATE
, POH.LAST_UPDATE_DATE) <= POH.LAST_UPDATE_DATE
AND NVL(ATC2.INACTIVE_DATE
, POH.LAST_UPDATE_DATE) >=POH.LAST_UPDATE_DATE
AND NVL(ATC2.ENABLED_FLAG
, 'Y') = 'Y' /* 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 /*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
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POLL.AMOUNT
, 'FIXED PRICE'
, POLL.AMOUNT
, POLL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POD.AMOUNT_ORDERED
, 'FIXED PRICE'
, POD.AMOUNT_ORDERED
, POD.QUANTITY_ORDERED)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, 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
, 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
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_ALL 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.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND NVL(ATC.ORG_ID
, -99) = NVL(FSP.ORG_ID
, -99)
AND POL.CATEGORY_ID = MC.CATEGORY_ID(+) /* BUG 4019786 START */
AND POH.VENDOR_ID = POV.VENDOR_ID(+)
AND POH.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID(+) /* BUG 4019786 END */
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 */ 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
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POLL.AMOUNT
, 'FIXED PRICE'
, POLL.AMOUNT
, POLL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, POD.AMOUNT_ORDERED
, 'FIXED PRICE'
, POD.AMOUNT_ORDERED
, POD.QUANTITY_ORDERED)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, 1
, 'FIXED PRICE'
, 1
, 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
, HZ.COUNTRY
, NULL
, NULL
, HZ.CITY
, NULL
, HZ.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL
, POLL.TAX_CODE_ID
, NULL
, POLL.TAX_USER_OVERRIDE_FLAG
, ATC.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
, 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
, HZ_LOCATIONS HZ
, 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.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND NVL(ATC.ORG_ID
, -99) = NVL(FSP.ORG_ID
, -99)
AND POL.CATEGORY_ID = MC.CATEGORY_ID(+) /* BUG 4019786 START */
AND POH.VENDOR_ID = POV.VENDOR_ID(+)
AND POH.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID(+) /* BUG 4019786 END */
AND POLL.SHIP_TO_LOCATION_ID = HZ.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