FND Design Data [Home] [Help]

View: JG_PO_REQ_TAX_LINES_SUMMARY_V

Product: JG - Regional Localizations
Description:
Implementation/DBA Data: ViewAPPS.JG_PO_REQ_TAX_LINES_SUMMARY_V
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
, PRVS.PROVINCE
, PRVS.ZIP
, NULL
, NULL
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PRL.ITEM_ID
, MSI.SEGMENT1
, PRL.QUANTITY
, PRD.REQ_LINE_QUANTITY
, 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.*/
, ATC.TAX_ID
, NULL
, PRL.TAX_USER_OVERRIDE_FLAG
, ATC.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
, NULL
, 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
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, PO_VENDORS PRV
, PO_VENDOR_SITES PRVS
, 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 PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.ORG_ID = NVL(MSI.ORGANIZATION_ID
, FSP.ORG_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 = ATG.TAX_GROUP_ID
AND ATG.TAX_GROUP_TYPE = 'AP'
AND ATG.TAX_CODE_ID = ATC.TAX_ID
AND ATG.START_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 ATC.START_DATE <= PRH.LAST_UPDATE_DATE
AND NVL(ATC.INACTIVE_DATE
, PRH.LAST_UPDATE_DATE ) >= PRH.LAST_UPDATE_DATE
AND NVL(ATC.ENABLED_FLAG
, 'Y') = 'Y' 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
, PRVS.PROVINCE
, PRVS.ZIP
, NULL
, NULL
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PRL.ITEM_ID
, MSI.SEGMENT1
, PRL.QUANTITY
, PRD.REQ_LINE_QUANTITY
, 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
, NULL
, 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
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, PO_VENDORS PRV
, PO_VENDOR_SITES PRVS
, 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 PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND FSP.ORG_ID = NVL(MSI.ORGANIZATION_ID
, FSP.ORG_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'

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