AR_MEMO_LINES_ALL_VL

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

ROW_ID LINE_TYPE EFFECTIVE_START_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATED_BY CREATION_DATE TAX_CODE UOM_CODE UNIT_STD_PRICE INVOICING_RULE_ID ACCOUNTING_RULE_ID EFFECTIVE_END_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 LAST_UPDATE_LOGIN MEMO_LINE_ID MEMO_LINE_SEQ_ID OBJECT_VERSION_NUMBER NAME DESCRIPTION SET_ID TAX_PRODUCT_CATEGORY GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.LINE_TYPE, B.EFFECTIVE_START_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATED_BY, B.CREATION_DATE, B.TAX_CODE, B.UOM_CODE, B.UNIT_STD_PRICE, B.INVOICING_RULE_ID, B.ACCOUNTING_RULE_ID, B.EFFECTIVE_END_DATE, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.GLOBAL_ATTRIBUTE_CATEGORY, B.GLOBAL_ATTRIBUTE1, B.GLOBAL_ATTRIBUTE2, B.GLOBAL_ATTRIBUTE3, B.GLOBAL_ATTRIBUTE4, B.GLOBAL_ATTRIBUTE5, B.GLOBAL_ATTRIBUTE6, B.GLOBAL_ATTRIBUTE7, B.GLOBAL_ATTRIBUTE8, B.GLOBAL_ATTRIBUTE9, B.GLOBAL_ATTRIBUTE10, B.GLOBAL_ATTRIBUTE11, B.GLOBAL_ATTRIBUTE12, B.GLOBAL_ATTRIBUTE13, B.GLOBAL_ATTRIBUTE14, B.GLOBAL_ATTRIBUTE15, B.GLOBAL_ATTRIBUTE16, B.GLOBAL_ATTRIBUTE17, B.GLOBAL_ATTRIBUTE18, B.GLOBAL_ATTRIBUTE19, B.GLOBAL_ATTRIBUTE20, B.LAST_UPDATE_LOGIN, B.MEMO_LINE_ID, B.MEMO_LINE_SEQ_ID, B.OBJECT_VERSION_NUMBER, T.NAME, T.DESCRIPTION, B.SET_ID, B.TAX_PRODUCT_CATEGORY, B.GLOBAL_ATTRIBUTE_NUMBER1, B.GLOBAL_ATTRIBUTE_NUMBER2, B.GLOBAL_ATTRIBUTE_NUMBER3, B.GLOBAL_ATTRIBUTE_NUMBER4, B.GLOBAL_ATTRIBUTE_NUMBER5, B.GLOBAL_ATTRIBUTE_DATE1, B.GLOBAL_ATTRIBUTE_DATE2, B.GLOBAL_ATTRIBUTE_DATE3, B.GLOBAL_ATTRIBUTE_DATE4, B.GLOBAL_ATTRIBUTE_DATE5 from AR_MEMO_LINES_ALL_TL T, AR_MEMO_LINES_ALL_B B WHERE B.MEMO_LINE_ID = T.MEMO_LINE_ID and B.SET_ID = T.SET_ID and T.LANGUAGE = userenv('LANG')