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.IGC_CC_SLA_BFLOW_PRIOR_V

Object Details

Object Name:	IGC_CC_SLA_BFLOW_PRIOR_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View created to be used in Payables to identify by SLA as prior entry created by CC

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CC_LINE	CHAR	(1)		Constant 'Y'
IGC_APPLICATION_ID	NUMBER			Aplication id 8407
CC_ENTITY_CODE	CHAR	(12)		Entity 'CC_CONTRACTS'
CC_DIST_TYPE	CHAR	(2)		Distribution type 'CC'
CC_DIST_ID	NUMBER			Account line defining column
CC_DOC_ID	NUMBER			Document identifier defining column
PO_DISTRIBUTION_ID	NUMBER		Yes	Document distribution unique identifier
CC_NUM	VARCHAR2	(20)	Yes	Document number
CC_VERSION_NUM	NUMBER		Yes	Document version number
CC_HEADER_ID	NUMBER		Yes	Document identifier defining column

Query Text

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


SELECT CC_LINE
,      IGC_APPLICATION_ID
,      CC_ENTITY_CODE
,      CC_DIST_TYPE
,      CC_DIST_ID
,      CC_DOC_ID
,      PO_DISTRIBUTION_ID
,      CC_NUM
,      CC_VERSION_NUM
,      CC_HEADER_ID
FROM APPS.IGC_CC_SLA_BFLOW_PRIOR_V;

Dependencies

[top of page]

APPS.IGC_CC_SLA_BFLOW_PRIOR_V references the following:

APPS: IGC_CC_DET_PF; IGC_CC_HEADERS_ALL; PO_DISTRIBUTIONS_ALL; PO_LINES_ALL; PO_LINE_TYPES

APPS.IGC_CC_SLA_BFLOW_PRIOR_V is referenced by following:

APPS: AP_EXTRACT_INVOICE_DTLS_BC_V