1. Tables and Views for SCM
  2. SUS_ACTIVITY_CLASSIFICATIONS_V

SUS_ACTIVITY_CLASSIFICATIONS_V

Details

  • Schema: FUSION

  • Object owner: SUS

  • Object type: VIEW

Columns

Name

ACTIVITY_ID

DESCRIPTION

COMMENTS

SUPPLIER_ID

INVENTORY_ITEM_ID

ORGANIZATION_CODE

INVOICE_DISTRIBUTION_ID

RULE_ID

CREATION_DATE

LAST_UPDATE_DATE

POSTING_DATE

ESG_LEDGER_ID

ESG_LEDGER_NAME

LEGAL_ENTITY_ID

CURRENT_CATEGORY_ID

ORIGINAL_CATEGORY_ID

Query

SQL_Statement

SELECT A.ACTIVITY_ID,

A.DESCRIPTION,

A.COMMENTS,

A.SUPPLIER_ID,

A.INVENTORY_ITEM_ID,

FND_PROFILE.VALUE('ORA_SUS_ITEM_VALIDATION_ORG_CODE') AS ORGANIZATION_CODE,

A.INVOICE_DISTRIBUTION_ID,

DECODE(A.CLASSIFICATION_CATEGORY_ID, E.CATEGORY_ID, A.CLASSIFICATION_RULE_ID, NULL) AS RULE_ID,

A.CREATION_DATE,

A.LAST_UPDATE_DATE,

A.POSTING_DATE,

A.ESG_LEDGER_ID,

(SELECT LEDGER_NAME FROM FUSION.SUS_LEDGERS WHERE LEDGER_ID = ESG_LEDGER_ID) AS ESG_LEDGER_NAME,

A.LEGAL_ENTITY_ID,

E.CATEGORY_ID AS CURRENT_CATEGORY_ID,

A.CLASSIFICATION_CATEGORY_ID AS ORIGINAL_CATEGORY_ID

FROM FUSION.SUS_ACTIVITIES A,

FUSION.SUS_EMISSION_FACTOR_MAPS E

WHERE A.STATUS_CODE = 'ORA_SUS_STATUS_POSTED'

AND E.ACTIVITY_TYPE_CODE = A.ACTIVITY_TYPE_CODE

AND NVL(E.EFM_ATTRIBUTE1, '@@@') = NVL(A.EFM_ATTRIBUTE1, '@@@')

AND NVL(E.EFM_ATTRIBUTE2, '@@@') = NVL(A.EFM_ATTRIBUTE2, '@@@')

AND NVL(E.EFM_ATTRIBUTE3, '@@@') = NVL(A.EFM_ATTRIBUTE3, '@@@')

AND NVL(E.EFM_ATTRIBUTE4, '@@@') = NVL(A.EFM_ATTRIBUTE4, '@@@')

AND NVL(E.EFM_ATTRIBUTE5, '@@@') = NVL(A.EFM_ATTRIBUTE5, '@@@')

AND NVL(E.EFM_ATTRIBUTE6, '@@@') = NVL(A.EFM_ATTRIBUTE6, '@@@')

AND NVL(E.EFM_ATTRIBUTE7, '@@@') = NVL(A.EFM_ATTRIBUTE7, '@@@')

AND NVL(E.EFM_ATTRIBUTE8, '@@@') = NVL(A.EFM_ATTRIBUTE8, '@@@')

AND NVL(E.EFM_ATTRIBUTE9, '@@@') = NVL(A.EFM_ATTRIBUTE9, '@@@')

AND NVL(E.EFM_ATTRIBUTE10, '@@@') = NVL(A.EFM_ATTRIBUTE10, '@@@')

AND NVL(E.EFM_ATTRIBUTE11, '@@@') = NVL(A.EFM_ATTRIBUTE11, '@@@')

AND NVL(E.EFM_ATTRIBUTE12, '@@@') = NVL(A.EFM_ATTRIBUTE12, '@@@')

AND NVL(E.EFM_ATTRIBUTE13, '@@@') = NVL(A.EFM_ATTRIBUTE13, '@@@')

AND NVL(E.EFM_ATTRIBUTE14, '@@@') = NVL(A.EFM_ATTRIBUTE14, '@@@')

AND NVL(E.EFM_ATTRIBUTE15, '@@@') = NVL(A.EFM_ATTRIBUTE15, '@@@')

AND NVL(E.EFM_ATTRIBUTE16, '@@@') = NVL(A.EFM_ATTRIBUTE16, '@@@')

AND NVL(E.EFM_ATTRIBUTE17, '@@@') = NVL(A.EFM_ATTRIBUTE17, '@@@')

AND NVL(E.EFM_ATTRIBUTE18, '@@@') = NVL(A.EFM_ATTRIBUTE18, '@@@')

AND NVL(E.EFM_ATTRIBUTE19, '@@@') = NVL(A.EFM_ATTRIBUTE19, '@@@')

AND NVL(E.EFM_ATTRIBUTE20, '@@@') = NVL(A.EFM_ATTRIBUTE20, '@@@')

AND NVL(E.EFM_ATTRIBUTE_NUMBER1, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER1, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER2, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER2, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER3, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER3, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER4, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER4, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER5, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER5, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER6, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER6, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER7, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER7, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER8, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER8, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER9, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER9, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_NUMBER10, -9999999999999) = NVL(A.EFM_ATTRIBUTE_NUMBER10, -9999999999999)

AND NVL(E.EFM_ATTRIBUTE_DATE1, TO_DATE('1-1-1970','dd-mm-yyyy')) = NVL(A.EFM_ATTRIBUTE_DATE1, TO_DATE('1-1-1970','dd-mm-yyyy'))

AND NVL(E.EFM_ATTRIBUTE_DATE2, TO_DATE('1-1-1970','dd-mm-yyyy')) = NVL(A.EFM_ATTRIBUTE_DATE2, TO_DATE('1-1-1970','dd-mm-yyyy'))

AND NVL(E.EFM_ATTRIBUTE_DATE3, TO_DATE('1-1-1970','dd-mm-yyyy')) = NVL(A.EFM_ATTRIBUTE_DATE3, TO_DATE('1-1-1970','dd-mm-yyyy'))

AND NVL(E.EFM_ATTRIBUTE_DATE4, TO_DATE('1-1-1970','dd-mm-yyyy')) = NVL(A.EFM_ATTRIBUTE_DATE4, TO_DATE('1-1-1970','dd-mm-yyyy'))

AND NVL(E.EFM_ATTRIBUTE_DATE5, TO_DATE('1-1-1970','dd-mm-yyyy')) = NVL(A.EFM_ATTRIBUTE_DATE5, TO_DATE('1-1-1970','dd-mm-yyyy'))

AND E.CATEGORY_VISIBILITY = 'Y'

AND A.INVOICE_DISTRIBUTION_ID IS NOT NULL

AND A.SOURCE_TYPE_CODE = 'ORA_SUS_SOURCE_INVOICE'