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

Object Details

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

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
SUBCONTRACT_PO_SHIPMENT_ID	NUMBER		Yes	Subcontract PO shipment id
SHIKYU_COMPONENT_ID	NUMBER		Yes	Inventory item ID of the Subcontracting component
ITEM_NUMBER	VARCHAR2	(4000)		Item number segment
DESCRIPTION	VARCHAR2	(240)		Item description
SHIKYU_COMPONENT_PRICE	NUMBER			Subcontracting component price
SUBCONTRACTING_COMPONENT	VARCHAR2	(80)		Replenishment type. Values: 'Pre-positioned' , 'Synchronized'
CURRENCY	VARCHAR2	(15)		Unique identifier for the currency corresponding to the SHIKYU component price. Should be the same as the currency of the subcontract Purchase Order.
REQUIRED_QUANTITY	NUMBER			Component required quantity
UOM	VARCHAR2	(3)		Unit Of Measure (UOM) of the Subcontracting component price.
UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	Unit of measure name
OEM_ORGANIZATION_ID	NUMBER		Yes	Organization ID of the Subcontracting Organization
OSA_ITEM_ID	NUMBER		Yes	Identifier of the Out Sourced Assembly item (OSA)

Query Text

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


SELECT SUBCONTRACT_PO_SHIPMENT_ID
,      SHIKYU_COMPONENT_ID
,      ITEM_NUMBER
,      DESCRIPTION
,      SHIKYU_COMPONENT_PRICE
,      SUBCONTRACTING_COMPONENT
,      CURRENCY
,      REQUIRED_QUANTITY
,      UOM
,      UNIT_OF_MEASURE
,      OEM_ORGANIZATION_ID
,      OSA_ITEM_ID
FROM APPS.JMF_SHIKYU_SPR_RPT_COM_V;

Dependencies

[top of page]

APPS.JMF_SHIKYU_SPR_RPT_COM_V references the following:

APPS: FND_LOOKUP_VALUES; JMF_SHIKYU_COMPONENTS; JMF_SHIKYU_RPT_UTIL - show dependent code; JMF_SUBCONTRACT_ORDERS; MTL_SYSTEM_ITEMS_B; MTL_UNITS_OF_MEASURE_TL; WIP_REQUIREMENT_OPERATIONS

APPS.JMF_SHIKYU_SPR_RPT_COM_V is not referenced by any database object