1. Tables and Views for Sales and Fusion Service
  2. ZCA_BI_CODE_ASSIGNMENTS_V

ZCA_BI_CODE_ASSIGNMENTS_V

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

CODE_ASSIGNMENT_ID

OWNER_TABLE_ID

CLASS_CATEGORY

CLASS_CODE

PROFILE_OPTION_NAME

PROFILE_OPTION_VALUE

LEVEL_NAME

OWNER_TABLE_NAME

PRIMARY_FLAG

STATUS

Query

SQL_Statement

SELECT

CodeAssignment.CODE_ASSIGNMENT_ID,

CodeAssignment.OWNER_TABLE_ID,

CodeAssignment.CLASS_CATEGORY,

CodeAssignment.CLASS_CODE,

ProfileOption.PROFILE_OPTION_NAME,

ProfileOptionValue.PROFILE_OPTION_VALUE,

ProfileOptionValue.LEVEL_NAME,

CodeAssignment.OWNER_TABLE_NAME,

CodeAssignment.PRIMARY_FLAG ,

CodeAssignment.STATUS

FROM

HZ_CODE_ASSIGNMENTS CodeAssignment,

FND_PROFILE_OPTION_VALUES ProfileOptionValue,

FND_PROFILE_OPTIONS_B ProfileOption

where

CodeAssignment.CLASS_CATEGORY = ProfileOptionValue.PROFILE_OPTION_VALUE AND

ProfileOptionValue.APPLICATION_ID = ProfileOption.APPLICATION_ID AND

ProfileOptionValue.PROFILE_OPTION_ID = ProfileOption.PROFILE_OPTION_ID AND

('HZ_PARTIES') = CodeAssignment.OWNER_TABLE_NAME AND

('Y') = CodeAssignment.PRIMARY_FLAG AND

('A') = CodeAssignment.STATUS AND

('SITE') = ProfileOptionValue.LEVEL_NAME AND

TRUNC(SYSDATE) BETWEEN CodeAssignment.START_DATE_ACTIVE AND CodeAssignment.END_DATE_ACTIVE