Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | This view will retreive all the service tax transactions based on the transaction source |
Implementation/DBA Data: | APPS.JAI_REPOEXT_V |
SELECT MIN(TRANSACTION_REPOSITORY_ID) TRANSACTION_REPOSITORY_ID
, TRANSACTION_SOURCE
, PARTY_NAME
, DOCUMENT_NUMBER
, DOCUMENT_DATE
, DOCUMENT_LINE_NUM
, DOCUMENT_LINE_ITEM
, DOCUMENT_LINE_DESC
, DOCUMENT_LINE_QTY
, DOCUMENT_LINE_UOM
, DOCUMENT_LINE_AMT
, NVL(DOCUMENT_CURRENCY_CODE
, 'INR') DOCUMENT_CURRENCY_CODE
, SERVICE_TYPE_CODE
, ORGANIZATION_NAME
, LOCATION_NAME
, ORGANIZATION_ID
, LOCATION_ID
, INVENTORY_ITEM_ID
, PARTY_ID
, DOCUMENT_ID
, DOCUMENT_LINE_ID
, MIN(TRANSACTION_REFERENCE_ID) TRANSACTION_REFERENCE_ID
, DECODE(DOCUMENT_LINE_ID
, NULL
, SUM(REPOSITORY_TAX_AMT)
, MAX(REPOSITORY_TAX_AMT)) REPOSITORY_TAX_AMT
, UPDATABLE_FLAG
, GL_DATE
, ST_INV_NUMBER
, SOURCE_TRX_TYPE
FROM JAI_TRX_REPO_EXTRACT_GT GROUP BY TRANSACTION_SOURCE
, PARTY_NAME
, DOCUMENT_NUMBER
, DOCUMENT_DATE
, DOCUMENT_LINE_NUM
, DOCUMENT_LINE_ITEM
, DOCUMENT_LINE_DESC
, DOCUMENT_LINE_QTY
, DOCUMENT_LINE_UOM
, DOCUMENT_LINE_AMT
, NVL(DOCUMENT_CURRENCY_CODE
, 'INR')
, SERVICE_TYPE_CODE
, ORGANIZATION_NAME
, LOCATION_NAME
, ORGANIZATION_ID
, LOCATION_ID
, INVENTORY_ITEM_ID
, PARTY_ID
, DOCUMENT_ID
, DOCUMENT_LINE_ID
, UPDATABLE_FLAG
, GL_DATE
, ST_INV_NUMBER
, SOURCE_TRX_TYPE