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_LCF_DETAILS_GTMP

Line 65: FROM gmd_lcf_details_gtmp d, gmd_lcf_tech_data_gtmp t

61: CURSOR Cur_get_line_ingred IS
62: SELECT NVL(SUM(weight), 0), NVL(SUM(weightpct), 0)
63: FROM
64: (SELECT qty_mass weight, qty_mass * value weightpct
65: FROM gmd_lcf_details_gtmp d, gmd_lcf_tech_data_gtmp t
66: WHERE d.line_id = t.line_id (+)
67: AND t.tech_parm_id (+) = V_parm_id
68: AND line_type = -1);
69:

Line 132: FROM gmd_lcf_details_gtmp d, gmd_lcf_tech_data_gtmp t

128: CURSOR Cur_get_line_ing IS
129: SELECT SUM(volume), SUM(volumepct)
130: FROM
131: (SELECT qty_vol volume, qty_vol * value volumepct
132: FROM gmd_lcf_details_gtmp d, gmd_lcf_tech_data_gtmp t
133: WHERE d.line_id = t.line_id (+)
134: AND t.tech_parm_id (+) = V_parm_id
135: AND line_type = -1);
136:

Line 222: FROM gmd_lcf_details_gtmp

218:
219: CURSOR Cur_line_qty IS
220: SELECT inventory_item_id, lot_number, qty,
221: detail_uom,primary_uom,secondary_uom
222: FROM gmd_lcf_details_gtmp
223: WHERE line_id = V_line_id;
224:
225: CURSOR Cur_line_item_number (V_inventory_item_id NUMBER)IS
226: SELECT concatenated_segments

Line 304: UPDATE gmd_lcf_details_gtmp

300: ELSE
301: l_primary_qty := l_rec.qty;
302: END IF;
303:
304: UPDATE gmd_lcf_details_gtmp
305: SET qty_mass = l_mass_qty,
306: mass_uom = V_mass_uom,
307: qty_vol = l_vol_qty,
308: vol_uom = V_vol_uom,

Line 347: FROM gmd_lcf_details_gtmp

343: V_vol_uom IN VARCHAR2,
344: X_return_status OUT NOCOPY VARCHAR2) IS
345: CURSOR Cur_get_lines IS
346: SELECT line_id
347: FROM gmd_lcf_details_gtmp
348: WHERE line_type <> 1;
349:
350: l_return_status VARCHAR2(1);
351: BEGIN

Line 446: FROM gmd_tech_parameters_b a, gmd_lcf_tech_data_gtmp b, gmd_lcf_details_gtmp c

442:
443: PROCEDURE load_tech_values (V_orgn_id IN NUMBER, V_formulation_spec_id IN NUMBER, V_date IN DATE) IS
444: CURSOR Cur_get_type IS
445: SELECT a.*, b.line_id, b.tech_parm_id tech, c.inventory_item_id
446: FROM gmd_tech_parameters_b a, gmd_lcf_tech_data_gtmp b, gmd_lcf_details_gtmp c
447: WHERE a.tech_parm_id = b.tech_parm_id
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

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 479: FROM gmd_technical_reqs b,gmd_lcf_details_gtmp c, gmd_tech_parameters_b d

475: IF (V_orgn_id IS NOT NULL) THEN
476: INSERT INTO GMD_LCF_TECH_DATA_GTMP
477: (LINE_ID,TECH_PARM_ID,TECH_PARM_NAME,QCASSY_TYP_ID)
478: SELECT c.line_id,b.tech_parm_id,d.tech_parm_name,d.qcassy_typ_id
479: FROM gmd_technical_reqs b,gmd_lcf_details_gtmp c, gmd_tech_parameters_b d
480: WHERE b.tech_parm_id = d.tech_parm_id
481: AND b.formulation_spec_id = V_formulation_spec_id;
482:
483: -- if tech params data type is not 12 then insert the values from item tech data tables

Line 488: FROM gmd_tech_parameters_b b, gmd_lcf_details_gtmp c,

484: -- at once no need to loop through.
485: INSERT INTO GMD_LCF_TECH_DATA_GTMP
486: (LINE_ID,TECH_PARM_ID,TECH_PARM_NAME,QCASSY_TYP_ID)
487: SELECT c.line_id,b.tech_parm_id,b.tech_parm_name,b.qcassy_typ_id
488: FROM gmd_tech_parameters_b b, gmd_lcf_details_gtmp c,
489: gmd_formulation_specs e
490: WHERE b.tech_parm_id = e.tech_parm_id
491: AND e.formulation_spec_id = V_formulation_spec_id;
492:

Line 549: gmd_lcf_details_gtmp c, gmd_tech_parameters_b d

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
553: AND a.inventory_item_id = c.inventory_item_id;

Line 654: INSERT INTO GMD_LCF_DETAILS_GTMP

650: X_return_status := FND_API.g_ret_sts_error;
651: gmd_api_grp.log_message('IC_API_UOM_CONVERSION_ERROR', 'ITEM_NO',l_simulation_rec.item,
652: 'FROM_UOM',l_simulation_rec.detail_uom,'TO_UOM',l_std_uom );
653: END IF;
654: INSERT INTO GMD_LCF_DETAILS_GTMP
655: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,
656: CONV_FACTOR,DESCRIPTION,DETAIL_UOM,PRIMARY_UOM,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
657: VALUES
658: (1,l_simulation_rec.line_id,l_simulation_rec.line_type,l_simulation_rec.line_no,0,

Line 695: INSERT INTO GMD_LCF_DETAILS_GTMP

691: X_return_status := FND_API.g_ret_sts_error;
692: gmd_api_grp.log_message('IC_API_UOM_CONVERSION_ERROR', 'ITEM_NO',l_formula_rec.concatenated_segments,
693: 'FROM_UOM',l_formula_rec.primary_uom_code,'TO_UOM',l_std_uom );
694: END IF;
695: INSERT INTO GMD_LCF_DETAILS_GTMP
696: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,
697: CONV_FACTOR,DESCRIPTION,DETAIL_UOM,PRIMARY_UOM,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
698: VALUES
699: (1,l_line_id,-1,l_formula_rec.line_no,0,l_formula_rec.inventory_item_id,l_formula_rec.concatenated_segments,

Line 735: INSERT INTO GMD_LCF_DETAILS_GTMP

731: gmd_api_grp.log_message('IC_API_UOM_CONVERSION_ERROR', 'ITEM_NO',l_comp_rec.concatenated_segments,
732: 'FROM_UOM',l_comp_rec.primary_uom_code,'TO_UOM',l_std_uom );
733: END IF;
734:
735: INSERT INTO GMD_LCF_DETAILS_GTMP
736: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,
737: CONV_FACTOR,DESCRIPTION,DETAIL_UOM,PRIMARY_UOM)
738: VALUES
739: (1,l_line_id,-1,l_line_no,0,l_comp_rec.inventory_item_id,l_comp_rec.concatenated_segments,

Line 850: FROM gmd_lcf_details_gtmp

846: V_qcassy_typ_id IN NUMBER,V_tech_parm_id IN NUMBER) IS
847:
848: CURSOR Cur_get_data IS
849: SELECT *
850: FROM gmd_lcf_details_gtmp
851: WHERE line_id = V_line_id;
852:
853: l_rec Cur_get_data%ROWTYPE;
854: l_return_status VARCHAR2(1);

Line 914: FROM gmd_lcf_details_gtmp

910: --Line id to be used to identify the specific line id number so that
911: --we can pass the value as 1 for that item and 0 to others.
912: CURSOR Cur_get_lineid IS
913: SELECT line_id, inventory_item_id, concatenated_segments, conv_factor
914: FROM gmd_lcf_details_gtmp
915: ORDER BY line_id;
916:
917: --Get the total count of material rows.
918: CURSOR Cur_get_line_count IS

Line 920: FROM gmd_lcf_details_gtmp;

916:
917: --Get the total count of material rows.
918: CURSOR Cur_get_line_count IS
919: SELECT COUNT(*)
920: FROM gmd_lcf_details_gtmp;
921:
922: --Get the technical parameter values for the paramter defined in the
923: --formulation specification screen as optimize function.
924: CURSOR Cur_get_optprm_value (V_tech_parm_id NUMBER, V_line_id NUMBER) IS

Line 934: FROM gmd_material_reqs a, gmd_lcf_details_gtmp b

930: --Get the material requirements defined for particular formulation specification.
931: CURSOR Cur_get_matl_req IS
932: SELECT a.inventory_item_id, a.min_qty, a.max_qty,
933: a.item_uom, a.range_type, b.concatenated_segments
934: FROM gmd_material_reqs a, gmd_lcf_details_gtmp b
935: WHERE (a.min_qty IS NOT NULL OR a.max_qty IS NOT NULL)
936: AND a.formulation_spec_id = V_formulation_spec_id
937: AND a.inventory_item_id = b.inventory_item_id
938: ORDER BY b.line_id;

Line 944: FROM gmd_lcf_details_gtmp

940: --Get the line id and other details for item id passed from
941: --the above requirement cursor
942: CURSOR Cur_get_matreq_line (V_inventory_item_id NUMBER) IS
943: SELECT line_id, concatenated_segments, conv_factor
944: FROM gmd_lcf_details_gtmp
945: WHERE inventory_item_id = V_inventory_item_id
946: ORDER BY line_id;
947:
948: --Get the compositional requirements defined for particular formulation specification.

Line 984: FROM gmd_lcf_details_gtmp

980:
981: --Get the lineid from details table to update the qty in categories dtl table.
982: CURSOR Cur_get_line_dtl (V_item VARCHAR2) IS
983: SELECT line_id, inventory_item_id, detail_uom, conv_factor
984: FROM gmd_lcf_details_gtmp
985: WHERE concatenated_segments = V_item;
986:
987: CURSOR Cur_get_conv_factor (V_line_id NUMBER) IS
988: SELECT conv_factor

Line 989: FROM gmd_lcf_details_gtmp

985: WHERE concatenated_segments = V_item;
986:
987: CURSOR Cur_get_conv_factor (V_line_id NUMBER) IS
988: SELECT conv_factor
989: FROM gmd_lcf_details_gtmp
990: WHERE line_id = V_line_id;
991:
992: l_new_qty NUMBER;
993: l_min_qty NUMBER;

Line 1305: UPDATE gmd_lcf_details_gtmp

1301:
1302: l_new_qty := l_solved_tab(i).qty;
1303:
1304: --Update quantities for the item returned from the uom routine.
1305: UPDATE gmd_lcf_details_gtmp
1306: SET qty = l_new_qty
1307: WHERE concatenated_segments = l_solved_tab(i).item;
1308: END LOOP;
1309:

Line 1312: FROM gmd_lcf_details_gtmp

1308: END LOOP;
1309:
1310: --Delete the items where qty is null
1311: DELETE
1312: FROM gmd_lcf_details_gtmp
1313: WHERE qty IS NULL OR qty = 0;
1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN

Line 1330: from gmd_lcf_details_gtmp;

1326:
1327: PROCEDURE temp_dump IS
1328: cursor cur_rec IS
1329: select *
1330: from gmd_lcf_details_gtmp;
1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);

Line 1350: from gmd_lcf_tech_data_gtmp a, gmd_lcf_details_gtmp b

1346:
1347: procedure temp_param IS
1348: cursor cur_rec1 IS
1349: select a.*,b.concatenated_segments
1350: from gmd_lcf_tech_data_gtmp a, gmd_lcf_details_gtmp b
1351: where a.line_id= b.line_id;
1352: begin
1353: FOR L_REC IN CUR_REC1 LOOP
1354: gmd_debug.put_line('item lineid techparmname value');