eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AS_CHANGED_ACCOUNTS

Object Details

Object Name:	AS_CHANGED_ACCOUNTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AS.AS_CHANGED_ACCOUNTS
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.

AS_CHANGED_ACCOUNTS is a view of AS_CHANGED_ACCOUNTS_ALL
partitioned by org_id for multi-org purpose.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_ID	NUMBER		Yes	Customer/prospect identifier
ADDRESS_ID	NUMBER			Account identifier
LEAD_ID	NUMBER			Lead identifier
SALES_LEAD_ID	NUMBER			Sales lead identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	DATE			Last date concurrent program updated record
CHANGE_TYPE	VARCHAR2	(30)		Type of change. Possible values are ACCOUNT or LEAD
INSERT_FLAG	VARCHAR2	(1)		Flag to indicate if the account or lead is newly created
DELETE_FLAG	VARCHAR2	(1)		Flag to indicate if the account or lead has just been deleted
PROCESSED_FLAG	VARCHAR2	(1)		Flag to indicate if this row has been processed by ASTATA
ORG_ID	NUMBER			Operating unit which performed this transaction
SEQUENCE	NUMBER			Sequence number to specify which child process of ASTATA does this row belong to.

Query Text

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


SELECT CUSTOMER_ID
,      ADDRESS_ID
,      LEAD_ID
,      SALES_LEAD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CHANGE_TYPE
,      INSERT_FLAG
,      DELETE_FLAG
,      PROCESSED_FLAG
,      ORG_ID
,      SEQUENCE
FROM APPS.AS_CHANGED_ACCOUNTS;

Dependencies

[top of page]

APPS.AS_CHANGED_ACCOUNTS references the following:

APPS: AS_CHANGED_ACCOUNTS_ALL

APPS.AS_CHANGED_ACCOUNTS is referenced by following:

APPS: AS_ATA_NEW_PUB - show dependent code