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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
PLANNING_PULL_SEQUENCE_ID	NUMBER		Yes	Pull sequence identifier of planning pull sequence
INVENTORY_ITEM_ID	NUMBER		Yes	Item Identifier
ITEM	VARCHAR2	(40)		Item concatenated segments
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
PLAN_POU	VARCHAR2	(4000)		Point of use of planning pull sequence
PLAN_SOURCE_SUBINVENTORY	VARCHAR2	(10)		Source subinventory for planning pull sequence
PLAN_POS_LOCATOR	VARCHAR2	(4000)		Source locator of planning pull sequence
PLAN_SOURCE_TYPE	NUMBER		Yes	Kanban source type of planning pull sequence
PLAN_SOURCE_ORGANIZATION_ID	NUMBER			Source organization identifier of planning pull sequence
PLAN_WIP_LINE_ID	NUMBER			Wip line identifier of planning pull sequence
PLAN_SUPPLIER_ID	NUMBER			Supplier identifier of planning pull sequence
PLAN_SUPPLIER_SITE_ID	NUMBER			Supplier site identifier of planning pull sequence
PLAN_CARDS	NUMBER			Number of Kanban cards for planning pull sequence
PLAN_SIZE	NUMBER			Kanban quantity for planning pull sequence
PROD_SOURCE_SUBINVENTORY	VARCHAR2	(10)		Source subinventory name of production pull sequence
PROD_POS_LOCATOR	VARCHAR2	(4000)		Source locator of production pull sequence
PROD_CARDS	NUMBER			Number of kanban cards for production pull sequence
PROD_SIZE	NUMBER			Kanban quantity for production pull sequence
PROD_SOURCE_TYPE	NUMBER		Yes	Kanban source type of production pull sequence
PROD_SOURCE_ORGANIZATION_ID	NUMBER			Source organization identifier of production pull sequence
PROD_WIP_LINE_ID	NUMBER			Wip line identifier of production pull sequence
PROD_SUPPLIER_ID	NUMBER			Supplier identifier of production pull sequence
PROD_SUPPLIER_SITE_ID	NUMBER			Supplier site identifier of production pull sequence

Query Text

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


SELECT ROW_ID
,      PLANNING_PULL_SEQUENCE_ID
,      INVENTORY_ITEM_ID
,      ITEM
,      ITEM_DESCRIPTION
,      PLAN_POU
,      PLAN_SOURCE_SUBINVENTORY
,      PLAN_POS_LOCATOR
,      PLAN_SOURCE_TYPE
,      PLAN_SOURCE_ORGANIZATION_ID
,      PLAN_WIP_LINE_ID
,      PLAN_SUPPLIER_ID
,      PLAN_SUPPLIER_SITE_ID
,      PLAN_CARDS
,      PLAN_SIZE
,      PROD_SOURCE_SUBINVENTORY
,      PROD_POS_LOCATOR
,      PROD_CARDS
,      PROD_SIZE
,      PROD_SOURCE_TYPE
,      PROD_SOURCE_ORGANIZATION_ID
,      PROD_WIP_LINE_ID
,      PROD_SUPPLIER_ID
,      PROD_SUPPLIER_SITE_ID
FROM APPS.FLM_KANBAN_CONFLICT_RES_V;

Dependencies

[top of page]

APPS.FLM_KANBAN_CONFLICT_RES_V references the following:

APPS: MRP_GET_LOCATION - show dependent code; MTL_KANBAN_PULL_SEQUENCES; MTL_SYSTEM_ITEMS_KFV

APPS.FLM_KANBAN_CONFLICT_RES_V is not referenced by any database object