View: JAI_RCV_CLAIM_MODVAT_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RCV_CLAIM_MODVAT_V

View Text

SELECT RL.ROWID ROW_ID
, RSH.RECEIPT_NUM
, RC.TRANSACTION_ID
, RT.TRANSACTION_TYPE
, RT.DESTINATION_TYPE_CODE
, RL.SHIPMENT_LINE_ID
, RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_DATE
, TRUNC(RT.CREATION_DATE)
, NVL(RC.VENDOR_CHANGED_FLAG
, 'N')
, DECODE(NVL(RC.VENDOR_CHANGED_FLAG
, 'N')
, 'N'
, RT.VENDOR_ID
, RC.VENDOR_ID) VENDOR_ID
, DECODE(NVL(RC.VENDOR_CHANGED_FLAG
, 'N')
, 'N'
, RT.VENDOR_SITE_ID
, RC.VENDOR_SITE_ID) VENDOR_SITE_ID
, RT.LOCATION_ID
, RT.QUANTITY
, NVL( (SELECT NVL(MANUFACTURING
, 'N')||NVL(TRADING
, 'N')
FROM JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID = RT.ORGANIZATION_ID
AND LOCATION_ID = (NVL(NVL2(RT.SUBINVENTORY
, ( SELECT LOCATION_ID
FROM JAI_INV_SUBINV_DTLS
WHERE ORGANIZATION_ID = RT.ORGANIZATION_ID
AND SUB_INVENTORY_NAME = RT.SUBINVENTORY)
, DECODE(RT.LOCATION_ID
, 0
, 0
, (SELECT DECODE(INVENTORY_ORGANIZATION_ID
, RT.ORGANIZATION_ID
, RT.LOCATION_ID
, 0)
FROM HR_LOCATIONS
WHERE LOCATION_ID = RT.LOCATION_ID) ) )
, 0)) )
, 'NN') CATEGORY
, RL.EXCISE_INVOICE_NO ATTRIBUTE1
, RL.EXCISE_INVOICE_DATE ATTRIBUTE2
, RL.ONLINE_CLAIM_FLAG ATTRIBUTE3
, RT.CURRENCY_CONVERSION_RATE
, RSH.EXCISE_INVOICE_NO SHIP_ATTRIBUTE1
, RSH.EXCISE_INVOICE_DATE SHIP_ATTRIBUTE2
, RSH.ONLINE_CLAIM_FLAG SHIP_ATTRIBUTE3
, RSH.RECEIPT_SOURCE_CODE
, RSL.TO_ORGANIZATION_ID
, RSL.ITEM_ID
, MSI.MODVAT_FLAG ITEM_MODVAT_FLAG
, MSI.ITEM_CLASS
, RL.CLAIM_MODVAT_FLAG
, RC.CENVAT_AMOUNT
, RC.CENVAT_CLAIMED_AMT
, RC.CENVAT_CLAIMED_PTG
, RC.OTHER_CENVAT_AMT
, RC.OTHER_CENVAT_CLAIMED_AMT
, RC.CENVAT_AMT_FOR_2ND_CLAIM
, RC.OTHER_CENVAT_AMT_FOR_2ND_CLAIM
FROM RCV_TRANSACTIONS RT
, RCV_SHIPMENT_LINES RSL
, JAI_RCV_HEADERS RSH
, JAI_RCV_LINES RL
, JAI_INV_ITM_SETUPS MSI
, JAI_RCV_CENVAT_CLAIMS RC
WHERE RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND MSI.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = RSL.ITEM_ID
AND RC.TRANSACTION_ID = RT.TRANSACTION_ID
AND NVL(RC.CENVAT_AMOUNT
, 0) + NVL(OTHER_CENVAT_AMT
, 0) <> 0
AND RC.CENVAT_CLAIMED_PTG < 100
AND NVL(RC.UNCLAIM_CENVAT_FLAG
, 'N') ='N'
AND NVL(RC.NON_BONDED_DELIVERY_FLAG
, 'N') ='N'

Columns