[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_CO_S_PER_LT_PARM

Object Details

Object Name:	IGS_CO_S_PER_LT_PARM
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_CO_S_PER_LT_PARM
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

IGS_CO_S_PER_LT_PARM describes the parameter values relating to the system letter being produced for the person.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      PERSON_ID
,      CORRESPONDENCE_TYPE
,      LETTER_REFERENCE_NUMBER
,      SPL_SEQUENCE_NUMBER
,      LETTER_PARAMETER_TYPE
,      SEQUENCE_NUMBER
,      PARAMETER_VALUE
,      LETTER_REPEATING_GROUP_CD
,      SPLRG_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      LETTER_ORDER_NUMBER
,      ORG_ID
FROM APPS.IGS_CO_S_PER_LT_PARM;

Dependencies

[top of page]

APPS

IGS_CO_S_PER_LT_PARM_ALL

APPS

IGS_AD_GEN_011 - show dependent code

IGS_CO_GEN_002 - show dependent code