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_REQ_TAX_LINES_SUMMARY_V

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

View Text

SELECT PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_LINE_ID
, PRD.DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, PRH.REQUEST_ID
, PRH.SEGMENT1
, NULL
, PRH.LAST_UPDATE_DATE
, PRL.CURRENCY_CODE
, PRL.RATE
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.PRECISION
, PRL.VENDOR_ID
, NULL
, PRV.VENDOR_NAME
, PRL.VENDOR_SITE_ID
, PRVS.COUNTRY
, PRVS.STATE
, PRVS.COUNTY
, PRVS.CITY
, NULL
, PRVS.ZIP
, NULL
, NULL
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PRL.ITEM_ID
, MSI.SEGMENT1
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRL.AMOUNT
, PRL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRD.REQ_LINE_AMOUNT
, PRD.REQ_LINE_QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, PRL.UNIT_PRICE)
, NULL
, NULL
, PRD.CODE_COMBINATION_ID
, NULL
, NULL
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.DELIVER_TO_LOCATION_ID
, PRL.DESTINATION_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
, PRL.TAX_USER_OVERRIDE_FLAG
, ATC2.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL /*CHANGE TO GET RECOVERY_RATE
FROM DOCUMENT FOR A TAX GROUP.*/
, PRD.RECOVERY_RATE
, PRD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(PRVS.AUTO_TAX_CALC_FLAG
, 'N')
, PRVS.AP_TAX_ROUNDING_RULE
, ATC2.TAX_TYPE
, ATC2.DESCRIPTION
, NULL
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_TYPE
, PRD.EXPENDITURE_ORGANIZATION_ID
, PRD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRL.CURRENCY_UNIT_PRICE
, PRL.ORG_ID
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
, PO_VENDORS PRV
, PO_VENDOR_SITES_ALL PRVS
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HR_LOCATIONS_ALL HRL
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES_ALL ATC1
, AP_TAX_CODES_ALL ATC2
, AR_TAX_GROUP_CODES_ALL ATG
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND FSP.ORG_ID = PRL.ORG_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND PRL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND PRL.VENDOR_ID = PRV.VENDOR_ID (+)
AND PRL.VENDOR_SITE_ID = PRVS.VENDOR_SITE_ID (+)
AND PRL.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID
AND PRL.CURRENCY_CODE = FC.CURRENCY_CODE(+)
AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRL.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
, PRH.LAST_UPDATE_DATE) <= PRH.LAST_UPDATE_DATE
AND NVL(ATG.END_DATE
, PRH.LAST_UPDATE_DATE) >= PRH.LAST_UPDATE_DATE
AND NVL(ATG.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(ATC2.START_DATE
, PRH.LAST_UPDATE_DATE) <= PRH.LAST_UPDATE_DATE
AND NVL(ATC2.INACTIVE_DATE
, PRH.LAST_UPDATE_DATE) >=PRH.LAST_UPDATE_DATE
AND NVL(ATC2.ENABLED_FLAG
, 'Y') = 'Y' /* BUG 3428139 START */
AND NVL(PRD.ENCUMBERED_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND PRL.LINE_LOCATION_ID IS NULL
AND ( NVL(PRH.TRANSFERRED_TO_OE_FLAG
, 'N') <> 'Y' OR NVL(PRL.SOURCE_TYPE_CODE
, 'VENDOR') <> 'INVENTORY' )
AND NVL(PRL.MODIFIED_BY_AGENT_FLAG
, 'N') <> 'Y' /* BUG 3428139 END */ UNION SELECT PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_LINE_ID
, PRD.DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, PRH.REQUEST_ID
, PRH.SEGMENT1
, NULL
, PRH.LAST_UPDATE_DATE
, PRL.CURRENCY_CODE
, PRL.RATE
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.PRECISION
, PRL.VENDOR_ID
, NULL
, PRV.VENDOR_NAME
, PRL.VENDOR_SITE_ID
, PRVS.COUNTRY
, PRVS.STATE
, PRVS.COUNTY
, PRVS.CITY
, NULL
, PRVS.ZIP
, NULL
, NULL
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PRL.ITEM_ID
, MSI.SEGMENT1
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRL.AMOUNT
, PRL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRD.REQ_LINE_AMOUNT
, PRD.REQ_LINE_QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, PRL.UNIT_PRICE)
, NULL
, NULL
, PRD.CODE_COMBINATION_ID
, NULL
, NULL
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.DELIVER_TO_LOCATION_ID
, PRL.DESTINATION_ORGANIZATION_ID
, NULL
, HZ.COUNTRY
, NULL
, NULL
, HZ.CITY
, NULL
, HZ.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL
, ATC2.TAX_ID
, NULL
, PRL.TAX_USER_OVERRIDE_FLAG
, ATC2.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRD.RECOVERY_RATE
, PRD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(PRVS.AUTO_TAX_CALC_FLAG
, 'N')
, PRVS.AP_TAX_ROUNDING_RULE
, ATC2.TAX_TYPE
, ATC2.DESCRIPTION
, NULL
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_TYPE
, PRD.EXPENDITURE_ORGANIZATION_ID
, PRD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRL.CURRENCY_UNIT_PRICE
, PRL.ORG_ID
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
, PO_VENDORS PRV
, PO_VENDOR_SITES_ALL PRVS
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HZ_LOCATIONS HZ
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES_ALL ATC1
, AP_TAX_CODES_ALL ATC2
, AR_TAX_GROUP_CODES_ALL ATG
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND FSP.ORG_ID = PRL.ORG_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND PRL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND PRL.VENDOR_ID = PRV.VENDOR_ID (+)
AND PRL.VENDOR_SITE_ID = PRVS.VENDOR_SITE_ID (+)
AND PRL.DELIVER_TO_LOCATION_ID = HZ.LOCATION_ID
AND PRL.CURRENCY_CODE = FC.CURRENCY_CODE(+)
AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRL.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
, PRH.LAST_UPDATE_DATE) <= PRH.LAST_UPDATE_DATE
AND NVL(ATG.END_DATE
, PRH.LAST_UPDATE_DATE) >= PRH.LAST_UPDATE_DATE
AND NVL(ATG.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(ATC2.START_DATE
, PRH.LAST_UPDATE_DATE) <= PRH.LAST_UPDATE_DATE
AND NVL(ATC2.INACTIVE_DATE
, PRH.LAST_UPDATE_DATE) >=PRH.LAST_UPDATE_DATE
AND NVL(ATC2.ENABLED_FLAG
, 'Y') = 'Y' /* BUG 3428139 START */
AND NVL(PRD.ENCUMBERED_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND PRL.LINE_LOCATION_ID IS NULL
AND ( NVL(PRH.TRANSFERRED_TO_OE_FLAG
, 'N') <> 'Y' OR NVL(PRL.SOURCE_TYPE_CODE
, 'VENDOR') <> 'INVENTORY' )
AND NVL(PRL.MODIFIED_BY_AGENT_FLAG
, 'N') <> 'Y' /* BUG 3428139 END */ UNION /*FOR TRANSACTIONS WITH REGULAR TAX CODE. */ SELECT PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_LINE_ID
, PRD.DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, PRH.REQUEST_ID
, PRH.SEGMENT1
, NULL
, PRH.LAST_UPDATE_DATE
, PRL.CURRENCY_CODE
, PRL.RATE
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.PRECISION
, PRL.VENDOR_ID
, NULL
, PRV.VENDOR_NAME
, PRL.VENDOR_SITE_ID
, PRVS.COUNTRY
, PRVS.STATE
, PRVS.COUNTY
, PRVS.CITY
, NULL
, PRVS.ZIP
, NULL
, NULL
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PRL.ITEM_ID
, MSI.SEGMENT1
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRL.AMOUNT
, PRL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRD.REQ_LINE_AMOUNT
, PRD.REQ_LINE_QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, PRL.UNIT_PRICE)
, NULL
, NULL
, PRD.CODE_COMBINATION_ID
, NULL
, NULL
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.DELIVER_TO_LOCATION_ID
, PRL.DESTINATION_ORGANIZATION_ID
, NULL
, HRL.COUNTRY
, NULL
, NULL
, HRL.TOWN_OR_CITY
, NULL
, HRL.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL /*GET TAX_CODE_ID
FROM DOCUMENT FOR REGULAR TAX CODE.*/
, PRL.TAX_CODE_ID
, NULL
, PRL.TAX_USER_OVERRIDE_FLAG
, ATC.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL /*GET RECOVERY_RATE
FROM DOCUMENT FOR REGULAR TAX CODE. */
, PRD.RECOVERY_RATE
, PRD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(PRVS.AUTO_TAX_CALC_FLAG
, 'N')
, PRVS.AP_TAX_ROUNDING_RULE
, ATC.TAX_TYPE
, ATC.DESCRIPTION
, NULL
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_TYPE
, PRD.EXPENDITURE_ORGANIZATION_ID
, PRD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRL.CURRENCY_UNIT_PRICE
, PRL.ORG_ID
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
, PO_VENDORS PRV
, PO_VENDOR_SITES_ALL PRVS
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HR_LOCATIONS_ALL HRL
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES_ALL ATC
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND FSP.ORG_ID = PRL.ORG_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND PRL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND PRL.VENDOR_ID = PRV.VENDOR_ID (+)
AND PRL.VENDOR_SITE_ID = PRVS.VENDOR_SITE_ID (+)
AND PRL.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID
AND PRL.CURRENCY_CODE = FC.CURRENCY_CODE (+)
AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRL.TAX_CODE_ID = ATC.TAX_ID(+)
AND ATC.TAX_TYPE <> 'TAX_GROUP' /* BUG 3428139 START */
AND NVL(PRD.ENCUMBERED_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND PRL.LINE_LOCATION_ID IS NULL
AND ( NVL(PRH.TRANSFERRED_TO_OE_FLAG
, 'N') <> 'Y' OR NVL(PRL.SOURCE_TYPE_CODE
, 'VENDOR') <> 'INVENTORY' )
AND NVL(PRL.MODIFIED_BY_AGENT_FLAG
, 'N') <> 'Y' /* BUG 3428139 END */ UNION /*FOR TRANSACTIONS WITH REGULAR TAX CODE. */ SELECT PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_LINE_ID
, PRD.DISTRIBUTION_ID
, NULL
, FSP.SET_OF_BOOKS_ID
, PRH.REQUEST_ID
, PRH.SEGMENT1
, NULL
, PRH.LAST_UPDATE_DATE
, PRL.CURRENCY_CODE
, PRL.RATE
, FC.MINIMUM_ACCOUNTABLE_UNIT
, FC.PRECISION
, PRL.VENDOR_ID
, NULL
, PRV.VENDOR_NAME
, PRL.VENDOR_SITE_ID
, PRVS.COUNTRY
, PRVS.STATE
, PRVS.COUNTY
, PRVS.CITY
, NULL
, PRVS.ZIP
, NULL
, NULL
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PRL.ITEM_ID
, MSI.SEGMENT1
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRL.AMOUNT
, PRL.QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, PRD.REQ_LINE_AMOUNT
, PRD.REQ_LINE_QUANTITY)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 1
, PRL.UNIT_PRICE)
, NULL
, NULL
, PRD.CODE_COMBINATION_ID
, NULL
, NULL
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.DELIVER_TO_LOCATION_ID
, PRL.DESTINATION_ORGANIZATION_ID
, NULL
, HZ.COUNTRY
, NULL
, NULL
, HZ.CITY
, NULL
, HZ.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL
, PRL.TAX_CODE_ID
, NULL
, PRL.TAX_USER_OVERRIDE_FLAG
, ATC.TAX_RATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRD.RECOVERY_RATE
, PRD.TAX_RECOVERY_OVERRIDE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(PRVS.AUTO_TAX_CALC_FLAG
, 'N')
, PRVS.AP_TAX_ROUNDING_RULE
, ATC.TAX_TYPE
, ATC.DESCRIPTION
, NULL
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_TYPE
, PRD.EXPENDITURE_ORGANIZATION_ID
, PRD.EXPENDITURE_ITEM_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRL.CURRENCY_UNIT_PRICE
, PRL.ORG_ID
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
, PO_VENDORS PRV
, PO_VENDOR_SITES_ALL PRVS
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, HZ_LOCATIONS HZ
, FND_CURRENCIES FC
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, MTL_CATEGORIES MC
, AP_TAX_CODES_ALL ATC
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND FSP.ORG_ID = PRL.ORG_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND PRL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND PRL.VENDOR_ID = PRV.VENDOR_ID (+)
AND PRL.VENDOR_SITE_ID = PRVS.VENDOR_SITE_ID (+)
AND PRL.DELIVER_TO_LOCATION_ID = HZ.LOCATION_ID
AND PRL.CURRENCY_CODE = FC.CURRENCY_CODE (+)
AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRL.TAX_CODE_ID = ATC.TAX_ID(+)
AND ATC.TAX_TYPE <> 'TAX_GROUP' /* BUG 3428139 START */
AND NVL(PRD.ENCUMBERED_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(PRL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND PRL.LINE_LOCATION_ID IS NULL
AND ( NVL(PRH.TRANSFERRED_TO_OE_FLAG
, 'N') <> 'Y' OR NVL(PRL.SOURCE_TYPE_CODE
, 'VENDOR') <> 'INVENTORY' )
AND NVL(PRL.MODIFIED_BY_AGENT_FLAG
, 'N') <> 'Y' /* 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
CURRENCY_UNIT_PRICE
ORG_ID