FND Design Data [Home] [Help]

View: AR_GTA_TRX_LINES_V

Product: AR - Receivables
Description: Detail information for GTA invoice and VAT invoice
Implementation/DBA Data: ViewAPPS.AR_GTA_TRX_LINES_V
View Text

SELECT JGTL.ROWID
, JGTL.ORG_ID
, JGTL.GTA_TRX_HEADER_ID
, JGTL.GTA_TRX_LINE_ID
, JGTL.LINE_NUMBER
, JGTL.ITEM_NUMBER
, JGTL.ITEM_DESCRIPTION
, JGTL.ITEM_MODEL
, JGTL.ITEM_TAX_DENOMINATION
, JGTL.TAX_RATE
, JGTL.UOM
, JGTL.QUANTITY
, JGTL.UNIT_PRICE
, JGTL.AMOUNT
, JGTL.ORIGINAL_CURRENCY_AMOUNT
, JGTL.ENABLED_FLAG
, JGTL.CREATION_DATE
, JGTL.CREATED_BY
, JGTL.LAST_UPDATE_DATE
, JGTL.LAST_UPDATED_BY
, JGTL.LAST_UPDATE_LOGIN
, JGTL.REQUEST_ID
, JGTL.PROGRAM_APPLICATION_ID
, JGTL.PROGRAM_ID
, JGTL.PROGRAM_UPDATE_DATE
, JGTL.ATTRIBUTE_CATEGORY
, JGTL.ATTRIBUTE1
, JGTL.ATTRIBUTE2
, JGTL.ATTRIBUTE3
, JGTL.ATTRIBUTE4
, JGTL.ATTRIBUTE5
, JGTL.ATTRIBUTE6
, JGTL.ATTRIBUTE7
, JGTL.ATTRIBUTE8
, JGTL.ATTRIBUTE9
, JGTL.ATTRIBUTE10
, JGTL.ATTRIBUTE11
, JGTL.ATTRIBUTE12
, JGTL.ATTRIBUTE13
, JGTL.ATTRIBUTE14
, JGTL.ATTRIBUTE15
, JGTL.DISCOUNT_AMOUNT
, JGTL.DISCOUNT_TAX_AMOUNT
, JGTL.DISCOUNT_RATE
FROM AR_GTA_TRX_LINES_ALL JGTL
FROM AR_GTA_TRX_LINES_ALL JGTL

Columns

Name
ROW_ID
ORG_ID
GTA_TRX_HEADER_ID
GTA_TRX_LINE_ID
LINE_NUMBER
ITEM
DESCRIPTION
MODEL
TAX_CODE
TAX_RATE
UOM
QUANTITY
UNIT_PRICE
AMOUNT
ORIGINAL_CURRENCY_AMOUNT
ENABLED_FLAG
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
DISCOUNT_AMOUNT
DISCOUNT_TAX_AMOUNT
DISCOUNT_RATE