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

Object Details

Object Name:	PMIBV_FORMULA_COST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIBV_FORMULA_COST_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Costing Information for product by formula

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FORMULA_NO	VARCHAR2	(32)	Yes	Alphanumeric formula name or number.
FORMULA_VERSION	NUMBER		Yes	Formula version.
FORMULA_TYPE	NUMBER	(5)	Yes	0=std formula; 1=packaged item formula (these are not currently used).
FORMULE_TYPE_MEANING	VARCHAR2	(80)		0=std formula; 1=packaged item formula (these are not currently used).
SCALE_TYPE	NUMBER	(5)	Yes	Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled.
FORMULA_DESC1	VARCHAR2	(70)	Yes	Formula description.
FORMULA_DESC2	VARCHAR2	(70)		Formula comment.
FORMULA_CLASS	VARCHAR2	(8)		Formula class. No programatic support (fm_form_cls).
FORMULA_CONTROL_CLASS	VARCHAR2	(8)		Not currently used. (fn_fmct_cls).
FORMULA_ID	NUMBER	(10)	Yes	Surrogate for formula_no + formula_vers.
FORMULA_EFECTIVITY_ID	NUMBER	(15)		Surrogate key for this effectivity row.
ORGANIZATION_CODE	VARCHAR2	(4)		The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.
EFFECTIVITY_ITEM_ID	NUMBER	(15)		Surrogate key for the item which is produced by the formula.
EFECTIVITY_ROUTING_ID	NUMBER	(15)		Surrogate key for the routing/routing version to be used, if any.
EFFECTIVITY_FORMULA_ID	NUMBER	(10)		Surrogate key for the formula /formula version to be used.
EFFECTIVITY_CUST_ID	NUMBER			Surrogate key for the customer for which this effectivity is used, if any.
EFFECTIVITY_FORMULA_USE	VARCHAR2	(30)		The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS.
EFF_FORMULA_USE_MEANING	VARCHAR2	(80)		The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS.
EFFECTIVITY_END_DATE	DATE			The end date of the effectivity.
EFFECTIVITY_START_DATE	DATE			The start date of the effectivity.
MIN_OUTPUT_QTY_PRIMARY_UOM	NUMBER			The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item.
MAX_OUTPUT_QTY_PRIMARY_UOM	NUMBER			The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item.
MIN_OUTPUT_QTY_EFF_UOM	NUMBER			The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column.
MAX_OUTPUT_QTY_EFF_UOM	NUMBER			The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column.
PRODUCT_QTY	NUMBER			Standard batch size for this rec.
PRODUCT_UOM	VARCHAR2	(4)		UOM for min_qty and max_qty.
EFFECTIVITY_PREFERENCE	NUMBER	(15)		Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column.
PRODUCT_ITEM_NO	VARCHAR2	(32)		Name of the item.
PRODUCT_DESC1	VARCHAR2	(70)		Short description of the item that is displayed during the item look up.
PRODUCT_DESC2	VARCHAR2	(70)		Short description of the item that is not displayed during the item look up.
PRODUCT_PRIMARY_UOM	VARCHAR2	(4)		Uom of the item by which the inventory balances are maintained.
PRODUCT_SECONDARY_UOM	VARCHAR2	(4)		Second UOM for in which inventory balances are maintained, for dual UOM items.
CUSTOMER_NO	VARCHAR2	(4000)		Unique identifier of a customer.
CUSTOMER_NAME	VARCHAR2	(40)		Customer name
ROUTING_ID	NUMBER	(10)		Routing Id.
ROUTING_NO	VARCHAR2	(32)		Routing name.
ROUTING_VERSION	NUMBER	(5)		Routing version.
ROUTING_DESCRIPTION	VARCHAR2	(40)		Routing description.
ROUTING_CLASS	VARCHAR2	(4)		User defined class for routings.
ROUTING_QTY	NUMBER			Used in ratio with formula and batch qty to scale individual step requirements.
ROUTING_ITEM_UOM	VARCHAR2	(4)		Uom of routing qty.
COST_LEVEL	NUMBER	(5)		Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process.
COMPONENT_COST	NUMBER			Component cost
BURDEN_INDICATOR	NUMBER	(5)		Indicates if costs came from burdens 0=No 1=Yes
ROLLOVER_INDICATOR	NUMBER	(5)		Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated.
COSTING_TOTAL_QTY	NUMBER			Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs.
COSTCALC_ORIG	NUMBER	(5)		Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process
RMCALC_TYPE	NUMBER	(5)		Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI
ROLLUP_REF_NO	NUMBER	(10)		Reference number of the Cost Rollup process that calculated this cost
COMPONENT_COST_ID	NUMBER	(10)		Surrogate ID for the Cost Component
WHSE_CODE	VARCHAR2	(4)		Warehouse for which the cost is specified
WHSE_NAME	VARCHAR2	(40)		Name of the warehouse.
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar for which the cost is specified
CALENDAR_DESCRIPTION	VARCHAR2	(40)		Costing Calendar description
PERIOD_CODE	VARCHAR2	(4)		Costing Period for which the cost is specified
PERIOD_DESCRIPTION	VARCHAR2	(40)		Costing Period Description
COST_MTHD_CODE	VARCHAR2	(4)		Cost Method for which the cost is specified
COST_CMPNTCLS_ID	NUMBER	(10)		Surrogate for component class
COST_ANALYSIS_CODE	VARCHAR2	(4)		Analysis code
COST_CMPNTCLS_CODE	VARCHAR2	(16)	Yes	Cost component class
COST_CMPNTCLS_DESC	VARCHAR2	(40)	Yes	Cost component class description
SORT_SEQUENCE	NUMBER	(10)	Yes	Sequence the component costs are sorted by on Cost details screen
USAGE_IND	NUMBER	(5)	Yes	Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment
PRIMARY_COMPONENT_CLASS_ID	NUMBER	(10)	Yes	Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class.
PRODUCT_COST_IND	NUMBER	(5)	Yes	This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost.
UPDATE_COST_IND	NUMBER	(5)	Yes	This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area.
CMPNT_GROUP	VARCHAR2	(8)		Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group
PPV_IND	NUMBER	(5)	Yes	Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations.
LEDGER_STD_QTY	NUMBER			Effectivity standard quantity converted to an item inventory uom.
LEDGER_FORM_PROD_UOM	VARCHAR2	(4)		UOM of the product within the formula
LEDGER_ROUTING_QTY	NUMBER			Routing quantity converted to product inventory uom
LEDGER_PRODUCT_QTY	NUMBER			Product qty converted to product inventory uom
LEDGER_COST_ALLOC	NUMBER	(10)		Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost
LEDGER_LINE_TYPE	NUMBER	(10)		Type of line 1=ingredient, -1=byproduct
LEDGER_LINE_TYPE_MEANING	VARCHAR2	(80)		Type of line 1=ingredient, -1=byproduct
LEDGER_ITEM_QTY	NUMBER			Ingredient/byproduct quantity converted to inventory uom
LEDGER_ITEM_FMQTY	NUMBER			Ingredient/byproduct quantity at formula uom
LEDGER_ITEM_FMQTY_UM	VARCHAR2	(4)		Ingredient/byproduct formula uom
LEDGER_COMPONENT_COST	NUMBER			Ingredient/byproduct Component cost
LEDGER_RESOURCE_COUNT	NUMBER			Resource count from the operation details
LEDGER_RESOURCE_USAGE	NUMBER			Resource usage from the operation details
LEDGER_NOMINAL_COST	NUMBER			Nominal cost for the resource at usage uom
LEDGER_USAGE_UOM	VARCHAR2	(4)		Standard resource uom
LEDGER_RUDTL_ID	NUMBER	(10)		Surrogate for this row
LEDGER_ITEM_ID	NUMBER	(10)		Surrogate for the ingedient/byproduct
LEDGER_WHSE_CODE	VARCHAR2	(4)		Warehouse code
LEDGER_RESOURCES	VARCHAR2	(16)		Resource
LEDGER_ITEM_NUMBER	VARCHAR2	(32)	Yes	Name of the item.
LEDGER_ITEM_DESCRIPTION	VARCHAR2	(70)	Yes	Short description of the item that is displayed during the item look up.
LEDGER_ITEM_UOM	VARCHAR2	(4)	Yes	Uom of the item by which the inventory balances are maintained.
LEDGER_ITEM_UOM2	VARCHAR2	(4)		Second UOM for in which inventory balances are maintained, for dual UOM items.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column

Query Text

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


SELECT FORMULA_NO
,      FORMULA_VERSION
,      FORMULA_TYPE
,      FORMULE_TYPE_MEANING
,      SCALE_TYPE
,      FORMULA_DESC1
,      FORMULA_DESC2
,      FORMULA_CLASS
,      FORMULA_CONTROL_CLASS
,      FORMULA_ID
,      FORMULA_EFECTIVITY_ID
,      ORGANIZATION_CODE
,      EFFECTIVITY_ITEM_ID
,      EFECTIVITY_ROUTING_ID
,      EFFECTIVITY_FORMULA_ID
,      EFFECTIVITY_CUST_ID
,      EFFECTIVITY_FORMULA_USE
,      EFF_FORMULA_USE_MEANING
,      EFFECTIVITY_END_DATE
,      EFFECTIVITY_START_DATE
,      MIN_OUTPUT_QTY_PRIMARY_UOM
,      MAX_OUTPUT_QTY_PRIMARY_UOM
,      MIN_OUTPUT_QTY_EFF_UOM
,      MAX_OUTPUT_QTY_EFF_UOM
,      PRODUCT_QTY
,      PRODUCT_UOM
,      EFFECTIVITY_PREFERENCE
,      PRODUCT_ITEM_NO
,      PRODUCT_DESC1
,      PRODUCT_DESC2
,      PRODUCT_PRIMARY_UOM
,      PRODUCT_SECONDARY_UOM
,      CUSTOMER_NO
,      CUSTOMER_NAME
,      ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERSION
,      ROUTING_DESCRIPTION
,      ROUTING_CLASS
,      ROUTING_QTY
,      ROUTING_ITEM_UOM
,      COST_LEVEL
,      COMPONENT_COST
,      BURDEN_INDICATOR
,      ROLLOVER_INDICATOR
,      COSTING_TOTAL_QTY
,      COSTCALC_ORIG
,      RMCALC_TYPE
,      ROLLUP_REF_NO
,      COMPONENT_COST_ID
,      WHSE_CODE
,      WHSE_NAME
,      CALENDAR_CODE
,      CALENDAR_DESCRIPTION
,      PERIOD_CODE
,      PERIOD_DESCRIPTION
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      COST_CMPNTCLS_CODE
,      COST_CMPNTCLS_DESC
,      SORT_SEQUENCE
,      USAGE_IND
,      PRIMARY_COMPONENT_CLASS_ID
,      PRODUCT_COST_IND
,      UPDATE_COST_IND
,      CMPNT_GROUP
,      PPV_IND
,      LEDGER_STD_QTY
,      LEDGER_FORM_PROD_UOM
,      LEDGER_ROUTING_QTY
,      LEDGER_PRODUCT_QTY
,      LEDGER_COST_ALLOC
,      LEDGER_LINE_TYPE
,      LEDGER_LINE_TYPE_MEANING
,      LEDGER_ITEM_QTY
,      LEDGER_ITEM_FMQTY
,      LEDGER_ITEM_FMQTY_UM
,      LEDGER_COMPONENT_COST
,      LEDGER_RESOURCE_COUNT
,      LEDGER_RESOURCE_USAGE
,      LEDGER_NOMINAL_COST
,      LEDGER_USAGE_UOM
,      LEDGER_RUDTL_ID
,      LEDGER_ITEM_ID
,      LEDGER_WHSE_CODE
,      LEDGER_RESOURCES
,      LEDGER_ITEM_NUMBER
,      LEDGER_ITEM_DESCRIPTION
,      LEDGER_ITEM_UOM
,      LEDGER_ITEM_UOM2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PMIBV_FORMULA_COST_V;

Dependencies

[top of page]

APPS.PMIBV_FORMULA_COST_V references the following:

APPS: CM_CLDR_DTL; CM_CLDR_HDR; CM_CMPT_DTL; CM_CMPT_MST; CM_SCST_LED; FM_FORM_EFF; FM_FORM_MST; FM_ROUT_HDR; FND_PROFILE - show dependent code; IC_ITEM_MST; IC_WHSE_MST; OP_CUST_MST; PMI_COST_ANALZ_PACK - show dependent code; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMIBV_FORMULA_COST_V is not referenced by any database object