VIEW: APPS.JAI_REPOEXT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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