PJF_SOV_LINES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

SOV_LINE_ID SOV_VERSION_ID LINE_NUMBER LINE_STATUS_CODE CHANGE_INDICATOR_CODE LINE_TYPE_CODE INVENTORY_ITEM_ID ITEM_ORGANIZATION_ID UOM_CODE QUANTITY UNIT_PRICE AMOUNT PRIOR_AMOUNT ATTRIBUTE_CATEGORY ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LANGUAGE LINE_DESCRIPTION SOURCE_LANG

Query

SQL_Statement

select SLB.SOV_LINE_ID, SLB.SOV_VERSION_ID, SLB.LINE_NUMBER, SLB.LINE_STATUS_CODE, SLB.CHANGE_INDICATOR_CODE, SLB.LINE_TYPE_CODE, SLB.INVENTORY_ITEM_ID, SLB.ITEM_ORGANIZATION_ID, SLB.UOM_CODE, SLB.QUANTITY, SLB.UNIT_PRICE, SLB.AMOUNT, SLB.PRIOR_AMOUNT, SLB.ATTRIBUTE_CATEGORY, SLB.ATTRIBUTE_NUMBER1, SLB.ATTRIBUTE_NUMBER2, SLB.ATTRIBUTE_NUMBER3, SLB.ATTRIBUTE_NUMBER4, SLB.ATTRIBUTE_NUMBER5, SLB.ATTRIBUTE_NUMBER6, SLB.ATTRIBUTE_NUMBER7, SLB.ATTRIBUTE_NUMBER8, SLB.ATTRIBUTE_NUMBER9, SLB.ATTRIBUTE_NUMBER10, SLB.ATTRIBUTE_CHAR1, SLB.ATTRIBUTE_CHAR2, SLB.ATTRIBUTE_CHAR3, SLB.ATTRIBUTE_CHAR4, SLB.ATTRIBUTE_CHAR5, SLB.ATTRIBUTE_CHAR6, SLB.ATTRIBUTE_CHAR7, SLB.ATTRIBUTE_CHAR8, SLB.ATTRIBUTE_CHAR9, SLB.ATTRIBUTE_CHAR10, SLB.ATTRIBUTE_DATE1, SLB.ATTRIBUTE_DATE2, SLB.ATTRIBUTE_DATE3, SLB.ATTRIBUTE_DATE4, SLB.ATTRIBUTE_DATE5, SLB.OBJECT_VERSION_NUMBER, SLB.CREATED_BY, SLB.CREATION_DATE, SLB.LAST_UPDATED_BY, SLB.LAST_UPDATE_DATE, SLB.LAST_UPDATE_LOGIN, SLTL.LANGUAGE, SLTL.LINE_DESCRIPTION, SLTL.SOURCE_LANG from pjf_sov_lines_b SLB, pjf_sov_lines_tl SLTL where SLB.SOV_LINE_ID = SLTL.SOV_LINE_ID and SLTL.LANGUAGE = userenv('LANG')