SUS_ACTIVITIES

Details

Schema: FUSION
Object owner: SUS
Object type: VIEW

Columns

Name
ACTIVITY_ID ACTIVITY_NUMBER DESCRIPTION COMMENTS SCOPE_CODE SCOPE SCOPE_CATEGORY_CODE SCOPE_CATEGORY ENTRY_TYPE_CODE ENTRY_TYPE SOURCE_TYPE_CODE SOURCE_TYPE EXTERNAL_REF_NUM ACTIVITY_DATE CONSUMPTION_START_DATE CONSUMPTION_END_DATE STATUS_CODE STATUS DATA_QUALITY_CODE DATA_QUALITY ORIGINAL_ACTIVITY_ID ORIGINAL_ACTIVITY_NUMBER LEGAL_ENTITY_ID LEGAL_ENTITY SUPPLIER_ID SUPPLIER_NAME COUNTRY_CODE COUNTRY INVOICE_ID INVOICE_NUMBER INVOICE_LINE_NUMBER INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID CALCULATION_OVERRIDE_CODE CALCULATION_OVERRIDE ESG_LEDGER_ID ESG_LEDGER_NAME POSTING_DATE PERIOD_ID PERIOD_NAME TOTAL_CO2E TOTAL_CO2E_UOM_CODE TOTAL_CO2E_UOM_V CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE CLASSIFICATION_CATEGORY_ID CLASSIFCATION_CATEGORY CLASSIFICATION_RULE_ID CLASSIFCATION_RULE_NAME ALERT_FLAG

Name

ACTIVITY_ID

ACTIVITY_NUMBER

DESCRIPTION

COMMENTS

SCOPE_CODE

SCOPE

SCOPE_CATEGORY_CODE

SCOPE_CATEGORY

ENTRY_TYPE_CODE

ENTRY_TYPE

SOURCE_TYPE_CODE

SOURCE_TYPE

EXTERNAL_REF_NUM

ACTIVITY_DATE

CONSUMPTION_START_DATE

CONSUMPTION_END_DATE

STATUS_CODE

STATUS

DATA_QUALITY_CODE

DATA_QUALITY

ORIGINAL_ACTIVITY_ID

ORIGINAL_ACTIVITY_NUMBER

LEGAL_ENTITY_ID

LEGAL_ENTITY

SUPPLIER_ID

SUPPLIER_NAME

COUNTRY_CODE

COUNTRY

INVOICE_ID

INVOICE_NUMBER

INVOICE_LINE_NUMBER

INVOICE_DISTRIBUTION_ID

INVOICE_DISTRIBUTION_NUMBER

INVENTORY_ITEM_ID

ORGANIZATION_ID

CALCULATION_OVERRIDE_CODE

CALCULATION_OVERRIDE

ESG_LEDGER_ID

ESG_LEDGER_NAME

POSTING_DATE

PERIOD_ID

PERIOD_NAME

TOTAL_CO2E

TOTAL_CO2E_UOM_CODE

TOTAL_CO2E_UOM_V

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

CLASSIFICATION_CATEGORY_ID

CLASSIFCATION_CATEGORY

CLASSIFICATION_RULE_ID

CLASSIFCATION_RULE_NAME

ALERT_FLAG

Query

SQL_Statement
SELECT SA.ACTIVITY_ID, SA.ACTIVITY_NUMBER, SA.DESCRIPTION, SA.COMMENTS, SA.SCOPE_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_SCOPES' and lookup_code = sa.scope_code) as SCOPE, SA.SCOPE_CATEGORY_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_SCOPE_CATEGORIES' and lookup_code = sa.SCOPE_CATEGORY_CODE) as SCOPE_CATEGORY, SA.ENTRY_TYPE_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_ENTRY_TYPE' and lookup_code = sa.ENTRY_TYPE_CODE) as ENTRY_TYPE, SA.SOURCE_TYPE_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_SOURCE_TYPE' and lookup_code = sa.SOURCE_TYPE_CODE) as SOURCE_TYPE, SA.EXTERNAL_REF_NUM, SA.ACTIVITY_DATE, SA.CONSUMPTION_START_DATE, SA.CONSUMPTION_END_DATE, SA.STATUS_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_ACT_STATUS' and lookup_code = sa.STATUS_CODE) as STATUS, SA.DATA_QUALITY_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_DATA_QUALITY' and lookup_code = sa.DATA_QUALITY_CODE) as DATA_QUALITY, SA.ORIGINAL_ACTIVITY_ID, (select activity_number from sus_activities where activity_id = sa.ORIGINAL_ACTIVITY_ID) as original_activity_number, SA.LEGAL_ENTITY_ID, (select name from xle_entity_profiles xle where xle.legal_entity_id = sa.legal_entity_id) as LEGAL_ENTITY, SA.SUPPLIER_ID, (select hp.party_name from hz_parties hp, poz_suppliers ps where ps.party_id = hp.party_id and ps.vendor_id = sa.supplier_id) as SUPPLIER_NAME, SA.COUNTRY_CODE, (select territory_short_name from fnd_territories_vl where territory_code = SA.COUNTRY_CODE ) as COUNTRY, SA.INVOICE_ID, (select INVOICE_NUM from ap_invoices_all where invoice_id = sa.invoice_id) as INVOICE_NUMBER, SA.INVOICE_LINE_NUMBER, SA.INVOICE_DISTRIBUTION_ID, (select distribution_line_number from ap_invoice_distributions_all where invoice_distribution_id = SA.INVOICE_DISTRIBUTION_ID) as INVOICE_DISTRIBUTION_NUMBER, SA.INVENTORY_ITEM_ID, (select ORGANIZATION_ID from inv_org_parameters where upper(organization_code) = upper(fnd_profile.value('ORA_SUS_ITEM_VALIDATION_ORG_CODE'))) as organization_id, SA.CALCULATION_OVERRIDE_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_CAL_MODE' and lookup_code = sa.CALCULATION_OVERRIDE_CODE) as CALCULATION_OVERRIDE, SA.ESG_LEDGER_ID, (select ledger_name from sus_ledgers where ledger_id = sa.esg_ledger_id) as esg_ledger_name, SA.POSTING_DATE, SA.PERIOD_ID, (select sp.period_name from sus_period_statuses sp where sp.period_id = sa.period_id) as period_name, SA.TOTAL_CO2E, SA.TOTAL_CO2E_UOM as TOTAL_CO2E_UOM_code, (select unit_of_measure from inv_units_of_measure_vl where uom_code = SA.TOTAL_CO2E_UOM) as TOTAL_CO2E_UOM_V, SA.CREATED_BY, SA.CREATION_DATE, SA.LAST_UPDATED_BY, SA.LAST_UPDATE_DATE, SA.CLASSIFICATION_CATEGORY_ID, (select concat_segments from poi_taxonomy_data where taxonomy_id = 60 and category_id = SA.CLASSIFICATION_CATEGORY_ID) as CLASSIFCATION_CATEGORY, SA.CLASSIFICATION_RULE_ID, (select rule_name from poi_rules_vl where entity_id = 2 and rule_id = SA.CLASSIFICATION_RULE_ID) as CLASSIFCATION_RULE_NAME, (select 'Y' from sus_act_validation_messages v where v.activity_id = sa.activity_id and rownum < 2) as ALERT_FLAG FROM SUS_ACTIVITIES SA

SQL_Statement

SELECT SA.ACTIVITY_ID,

SA.ACTIVITY_NUMBER,

SA.DESCRIPTION,

SA.COMMENTS,

SA.SCOPE_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_SCOPES' and lookup_code = sa.scope_code) as SCOPE,

SA.SCOPE_CATEGORY_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_SCOPE_CATEGORIES' and lookup_code = sa.SCOPE_CATEGORY_CODE) as SCOPE_CATEGORY,

SA.ENTRY_TYPE_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_ENTRY_TYPE' and lookup_code = sa.ENTRY_TYPE_CODE) as ENTRY_TYPE,

SA.SOURCE_TYPE_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_SOURCE_TYPE' and lookup_code = sa.SOURCE_TYPE_CODE) as SOURCE_TYPE,

SA.EXTERNAL_REF_NUM,

SA.ACTIVITY_DATE,

SA.CONSUMPTION_START_DATE,

SA.CONSUMPTION_END_DATE,

SA.STATUS_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_ACT_STATUS' and lookup_code = sa.STATUS_CODE) as STATUS,

SA.DATA_QUALITY_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_DATA_QUALITY' and lookup_code = sa.DATA_QUALITY_CODE) as DATA_QUALITY,

SA.ORIGINAL_ACTIVITY_ID,

(select activity_number from sus_activities where activity_id = sa.ORIGINAL_ACTIVITY_ID) as original_activity_number,

SA.LEGAL_ENTITY_ID,

(select name from xle_entity_profiles xle where xle.legal_entity_id = sa.legal_entity_id) as LEGAL_ENTITY,

SA.SUPPLIER_ID,

(select hp.party_name from hz_parties hp, poz_suppliers ps where ps.party_id = hp.party_id and ps.vendor_id = sa.supplier_id) as SUPPLIER_NAME,

SA.COUNTRY_CODE,

(select territory_short_name from fnd_territories_vl where territory_code = SA.COUNTRY_CODE ) as COUNTRY,

SA.INVOICE_ID,

(select INVOICE_NUM from ap_invoices_all where invoice_id = sa.invoice_id) as INVOICE_NUMBER,

SA.INVOICE_LINE_NUMBER,

SA.INVOICE_DISTRIBUTION_ID,

(select distribution_line_number from ap_invoice_distributions_all where invoice_distribution_id = SA.INVOICE_DISTRIBUTION_ID) as INVOICE_DISTRIBUTION_NUMBER,

SA.INVENTORY_ITEM_ID,

(select ORGANIZATION_ID from inv_org_parameters where upper(organization_code) = upper(fnd_profile.value('ORA_SUS_ITEM_VALIDATION_ORG_CODE'))) as organization_id,

SA.CALCULATION_OVERRIDE_CODE,

(select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_CAL_MODE' and lookup_code = sa.CALCULATION_OVERRIDE_CODE) as CALCULATION_OVERRIDE,

SA.ESG_LEDGER_ID,

(select ledger_name from sus_ledgers where ledger_id = sa.esg_ledger_id) as esg_ledger_name,

SA.POSTING_DATE,

SA.PERIOD_ID,

(select sp.period_name from sus_period_statuses sp where sp.period_id = sa.period_id) as period_name,

SA.TOTAL_CO2E,

SA.TOTAL_CO2E_UOM as TOTAL_CO2E_UOM_code,

(select unit_of_measure from inv_units_of_measure_vl where uom_code = SA.TOTAL_CO2E_UOM) as TOTAL_CO2E_UOM_V,

SA.CREATED_BY,

SA.CREATION_DATE,

SA.LAST_UPDATED_BY,

SA.LAST_UPDATE_DATE,

SA.CLASSIFICATION_CATEGORY_ID,

(select concat_segments from poi_taxonomy_data where taxonomy_id = 60 and category_id = SA.CLASSIFICATION_CATEGORY_ID) as CLASSIFCATION_CATEGORY,

SA.CLASSIFICATION_RULE_ID,

(select rule_name from poi_rules_vl where entity_id = 2 and rule_id = SA.CLASSIFICATION_RULE_ID) as CLASSIFCATION_RULE_NAME,

(select 'Y' from sus_act_validation_messages v where v.activity_id = sa.activity_id and rownum < 2) as ALERT_FLAG

FROM SUS_ACTIVITIES SA