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]

TABLE: GME.GME_GANTT_DOCUMENT_FILTER

Object Details

Object Name:	GME_GANTT_DOCUMENT_FILTER
Object Type:	TABLE
Owner:	GME
FND Design Data:	GME.GME_GANTT_DOCUMENT_FILTER
Subobject Name:
Status:	VALID

Filter for the GME Gantt Chart informaiton

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER	(15)	Yes	The user for which the filter criteria are defined
ORGN_CODE	VARCHAR2	(4)		The organization for the which the filter criteria are defined
FROM_DATE	DATE		Yes	The date from which the product documents (batches/FPOs) are retrieved (the document start date must be greater or equal to this date)
TO_DATE	DATE			Production documents that start after this date are ignored
RESOURCE_CONSUMED	VARCHAR2	(16)	Yes	Resource code to be used in the selection
RESOURCE_IND	NUMBER	(5)	Yes	Indicates the types of resources to be selected 0=Primary Resource1=Secondary Resources2=Auxiliary resource3=Primary and Secondary Resource4=Primary and Auxiliary Resource5=Secondary and Auxiliary Resource6=All Resources
DOCUMENT_NO	VARCHAR2	(32)		Document number to be selected
DOCUMENT_TYPE	NUMBER	(5)	Yes	Indicate the document type to be selected1=Batch2=FPO3=Batch and FPO
PRODUCT_YIELDED	VARCHAR2	(32)	Yes	Product Number to be used in the selection
INGREDIENT_CONSUMED	VARCHAR2	(32)	Yes	Ingredient number to be used in the selection
BATCH_STATUS	NUMBER	(5)	Yes	Indicate the statuses of the batch to be selected0=Pending1=WIP2=Certified3=Pending and WIP4=Pending and Certiied5=WIP and Certified6=All statuses
FROM_DOC_NO	VARCHAR2	(32)		Filter criteria
ORGANIZATION_ID	NUMBER			To identify the organization (Plant /Lab)
TO_DOC_NO	VARCHAR2	(32)		Filter criteria

Query Text

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


SELECT USER_ID
,      ORGN_CODE
,      FROM_DATE
,      TO_DATE
,      RESOURCE_CONSUMED
,      RESOURCE_IND
,      DOCUMENT_NO
,      DOCUMENT_TYPE
,      PRODUCT_YIELDED
,      INGREDIENT_CONSUMED
,      BATCH_STATUS
,      FROM_DOC_NO
,      ORGANIZATION_ID
,      TO_DOC_NO
FROM GME.GME_GANTT_DOCUMENT_FILTER;

Dependencies

[top of page]

GME.GME_GANTT_DOCUMENT_FILTER does not reference any database object

GME.GME_GANTT_DOCUMENT_FILTER is referenced by following:

APPS: GME_GANTT_DOCUMENT_FILTER