[Home] [Help] [Dependency Information]
Object Name: | JMF_SHIKYU_SPR_RPT_COM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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) |
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;
APPS.JMF_SHIKYU_SPR_RPT_COM_V is not referenced by any database object
|
|
|