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.

APPS.PMI_COST_ANALZ_PACK dependencies on GME_MATERIAL_DETAILS

Line 254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,

250:
251: FUNCTION gmca_variance(
252: batch_id_vi IN gme_batch_header.batch_id%TYPE,
253: formula_id_vi IN fm_form_mst.formula_id%TYPE,
254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,

Line 256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,

252: batch_id_vi IN gme_batch_header.batch_id%TYPE,
253: formula_id_vi IN fm_form_mst.formula_id%TYPE,
254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,

Line 257: item_um_vi IN gme_material_details.item_um%TYPE,

253: formula_id_vi IN fm_form_mst.formula_id%TYPE,
254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,

Line 258: line_type_vi IN gme_material_details.line_type%TYPE,

254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,

Line 259: line_no_vi IN gme_material_details.line_no%TYPE,

255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,

Line 264: item_id_vi IN gme_material_details.item_id%TYPE,

260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,
265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
266: actual_qty_vi IN gme_material_details.actual_qty%TYPE
267: )
268: RETURN NUMBER

Line 265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,

261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,
265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
266: actual_qty_vi IN gme_material_details.actual_qty%TYPE
267: )
268: RETURN NUMBER
269: IS

Line 266: actual_qty_vi IN gme_material_details.actual_qty%TYPE

262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,
265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
266: actual_qty_vi IN gme_material_details.actual_qty%TYPE
267: )
268: RETURN NUMBER
269: IS
270: /* Declare and Initialize variables */

Line 274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;

270: /* Declare and Initialize variables */
271: primary_product_v ic_item_mst.item_id%TYPE := 0;
272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;
273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;
278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;

Line 277: batch_item_id_v gme_material_details.item_id%TYPE := 0;

273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;
278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;
279: batch_item_qty_v gme_material_details.actual_qty%TYPE := 0;
280: scale_factor_v NUMBER := 1; /* Primary Scaling Factor */
281: scaling_error_v NUMBER := 0;

Line 278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;

274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;
278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;
279: batch_item_qty_v gme_material_details.actual_qty%TYPE := 0;
280: scale_factor_v NUMBER := 1; /* Primary Scaling Factor */
281: scaling_error_v NUMBER := 0;
282: variance_v NUMBER := 0;

Line 279: batch_item_qty_v gme_material_details.actual_qty%TYPE := 0;

275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;
278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;
279: batch_item_qty_v gme_material_details.actual_qty%TYPE := 0;
280: scale_factor_v NUMBER := 1; /* Primary Scaling Factor */
281: scaling_error_v NUMBER := 0;
282: variance_v NUMBER := 0;
283:

Line 362: FROM gme_material_details

358: pm_qty_v :=plan_qty_vi;
359: pm_qty_um_v:= item_um_vi;
360: ELSE
361: SELECT plan_qty,item_um into pm_qty_v,pm_qty_um_v
362: FROM gme_material_details
363: WHERE batch_id = batch_id_vi
364: AND line_type =1
365: AND item_id = primary_product_v;
366: END IF;