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.GMD_LCF_FETCH_PKG dependencies on GMD_TECHNICAL_DATA_VL

Line 452: FROM gmd_technical_data_vl a, gmd_lcf_tech_data_gtmp b, gmd_lcf_details_gtmp c

448: AND b.line_id = c.line_id;
449:
450: CURSOR Cur_get_value (V_inventory_item_id NUMBER, V_tech_parm_id NUMBER) IS
451: SELECT a.num_data
452: FROM gmd_technical_data_vl a, gmd_lcf_tech_data_gtmp b, gmd_lcf_details_gtmp c
453: WHERE a.tech_parm_id = b.tech_parm_id
454: AND a.tech_parm_id = V_tech_parm_id
455: AND a.inventory_item_id = c.inventory_item_id
456: AND a.inventory_item_id = V_inventory_item_id

Line 548: FROM gmd_technical_data_vl a,

544: INSERT INTO GMD_LCF_TECH_DATA_GTMP
545: (LINE_ID,TECH_PARM_ID,TECH_PARM_NAME,VALUE,NUM_DATA,QCASSY_TYP_ID)
546: SELECT c.line_id,a.tech_parm_id,d.tech_parm_name,
547: a.num_data,a.num_data,d.qcassy_typ_id
548: FROM gmd_technical_data_vl a,
549: gmd_lcf_details_gtmp c, gmd_tech_parameters_b d
550: WHERE a.tech_parm_id = d.tech_parm_id
551: AND d.tech_parm_name = l_density_parameter
552: AND a.organization_id = V_orgn_id

Line 607: FROM gmd_technical_data_vl

603: ORDER BY b.concatenated_segments;
604:
605: CURSOR Cur_density (V_inv_item_id NUMBER,V_density_parameter VARCHAR2) IS
606: SELECT num_data
607: FROM gmd_technical_data_vl
608: WHERE organization_id = V_organization_id
609: AND inventory_item_id = V_inv_item_id
610: AND tech_parm_name = V_density_parameter;
611: