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_SPREAD_FETCH_PKG dependencies on GMD_MATERIAL_DETAILS_GTMP

Line 22: DELETE FROM gmd_material_details_gtmp;

18: V_batch_id IN NUMBER,V_formula_id IN NUMBER,V_spec_id IN NUMBER DEFAULT NULL,
19: V_orgn_id IN NUMBER,V_update_inv_ind IN VARCHAR2,
20: V_plant_id IN NUMBER) IS
21: BEGIN
22: DELETE FROM gmd_material_details_gtmp;
23: DELETE FROM gmd_technical_data_gtmp;
24: IF (V_sprd_id IS NOT NULL) THEN
25: gmd_spread_fetch_pkg.load_spread_details(V_entity_id,V_sprd_id,V_orgn_id);
26: ELSIF (V_batch_id IS NOT NULL AND V_spec_id IS NULL) THEN

Line 65: FROM gmd_material_details_gtmp

61: ORDER BY a.line_type,a.line_no;
62:
63: CURSOR Cur_get_lines IS
64: SELECT parent_line_id
65: FROM gmd_material_details_gtmp
66: WHERE entity_id = V_entity_id
67: AND line_type <> 3 ;
68:
69: CURSOR Cur_get_batch_text(V_matldetlid IN NUMBER) IS

Line 104: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

100: CLOSE Cur_get_formula_text;
101: l_parent_line_id := l_spread_rec.formulaline_id;
102: END IF;
103:
104: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
105: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,
106: INVENTORY_ITEM_ID,DESCRIPTION,QTY,SECONDARY_QTY,DETAIL_UOM,ORGANIZATION_ID,
107: GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,LOT_CONTROL_CODE,REVISION,
108: GRADE_CONTROL_FLAG,LOT_NUMBER,TEXT_CODE,ORGINAL_TEXT_CODE,SPRD_LINE_ID,ACTION_CODE,

Line 172: FROM gme_pending_product_lots a, gmd_material_details_gtmp b,

168: SELECT a.*, c.expiration_date, b.inventory_item_id,
169: b.detail_uom, b.primary_uom, b.secondary_uom,
170: b.tracking_quantity_ind,b.lot_control_code,b.secondary_default_ind,
171: b.grade_control_flag,b.location_control_code, b.organization_id,b.locator_id
172: FROM gme_pending_product_lots a, gmd_material_details_gtmp b,
173: mtl_lot_numbers c
174: WHERE a.material_detail_id = b.material_detail_id
175: AND a.material_detail_id = V_matl_detl_id
176: AND a.batch_id = V_batch_id

Line 196: FROM gmd_material_details_gtmp

192: AND c.lot_number = V_lot_number;
193:
194: CURSOR Cur_get_lines IS
195: SELECT material_detail_id
196: FROM gmd_material_details_gtmp
197: WHERE entity_id = V_entity_id
198: AND line_type <> 3 ;
199:
200: l_line_id NUMBER DEFAULT 0;

Line 284: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

280: FETCH Cur_get_formulaid INTO l_tpformula_id;
281: CLOSE Cur_get_formulaid;
282: END IF;
283: END IF;
284: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
285: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,
286: INVENTORY_ITEM_ID,DESCRIPTION,EXPAND_IND,QTY,SECONDARY_QTY,DETAIL_UOM,
287: GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,LOT_CONTROL_CODE,ORGANIZATION_ID,
288: GRADE_CONTROL_FLAG,REVISION,TEXT_CODE,ORGINAL_TEXT_CODE,MATERIAL_DETAIL_ID,FORMULALINE_ID,

Line 328: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

324: l_mmln_tbl(j).lot_number,
325: l_batch_rec.organization_id);
326: FETCH Cur_get_controls INTO l_control;
327: CLOSE Cur_get_controls;
328: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
329: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,EXPAND_IND,
330: EXPIRATION_DATE,LOT_NUMBER,QTY,PRIMARY_QTY,PRIMARY_UOM,SECONDARY_QTY,SECONDARY_UOM,
331: DETAIL_UOM,GRADE_CODE,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,LOT_CONTROL_CODE,
332: GRADE_CONTROL_FLAG,SUBINVENTORY_CODE,MATERIAL_DETAIL_ID,TRANSACTION_ID,

Line 397: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

393: plab_id => l_batch_rec.organization_id);
394:
395: END IF;
396:
397: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
398: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,EXPAND_IND,
399: EXPIRATION_DATE,LOT_NUMBER,QTY,PRIMARY_QTY,PRIMARY_UOM,SECONDARY_QTY,SECONDARY_UOM,
400: DETAIL_UOM,GRADE_CODE,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,LOT_CONTROL_CODE,
401: GRADE_CONTROL_FLAG,SUBINVENTORY_CODE,MATERIAL_DETAIL_ID,RESERVATION_ID,

Line 444: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

440: IF (l_primary_qty < 0) THEN
441: l_primary_qty := NULL;
442: END IF;
443: END IF;
444: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
445: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,EXPAND_IND,
446: EXPIRATION_DATE,SECONDARY_UOM,LOT_NUMBER,QTY,PRIMARY_QTY,PRIMARY_UOM,SECONDARY_QTY,
447: DETAIL_UOM,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,LOT_CONTROL_CODE,
448: GRADE_CONTROL_FLAG,MATERIAL_DETAIL_ID,PARENT_LINE_ID,ACTION_CODE,CREATED_BY,

Line 509: FROM gmd_material_details_gtmp a, mtl_lot_numbers b, (select inventory_item_id,lot_number, lot_organization_id

505: ORDER BY a.line_type, a.line_no;
506:
507: CURSOR Cur_get_materials IS
508: SELECT a.*, b.lot_number lot,b.expiration_date expire, b.inventory_item_id itemid
509: FROM gmd_material_details_gtmp a, mtl_lot_numbers b, (select inventory_item_id,lot_number, lot_organization_id
510: from gmd_technical_data_vl group by inventory_item_id,lot_number,lot_organization_id) c
511: WHERE a.entity_id = V_formula_id
512: AND a.inventory_item_id = b.inventory_item_id
513: AND a.inventory_item_id = c.inventory_item_id

Line 521: FROM gmd_material_details_gtmp

517: ORDER BY a.formulaline_id,b.lot_number;
518:
519: CURSOR Cur_get_lines IS
520: SELECT formulaline_id
521: FROM gmd_material_details_gtmp
522: WHERE entity_id = V_entity_id
523: AND line_type <> 3 ;
524:
525: l_line_id NUMBER DEFAULT 0;

Line 623: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

619: ELSIF l_formula_rec.line_type = 1 THEN
620: l_tpformula_id := V_formula_id ;
621: END IF; /*Added in Bug No.7462584 */
622:
623: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
624: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,EXPAND_IND,TRACKING_QUANTITY_IND,
625: LOCATION_CONTROL_CODE,INVENTORY_ITEM_ID,DESCRIPTION,TPFORMULA_ID,
626: QTY,SECONDARY_QTY,DETAIL_UOM,GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,LOT_CONTROL_CODE,
627: GRADE_CONTROL_FLAG,REVISION,TEXT_CODE,ORGINAL_TEXT_CODE,FORMULALINE_ID,PARENT_LINE_ID,

Line 660: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

656: ELSE
657: l_secondary_qty := NULL;
658: END IF;
659:
660: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
661: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,
662: INVENTORY_ITEM_ID,EXPAND_IND,EXPIRATION_DATE,LOT_NUMBER,QTY,SECONDARY_QTY,
663: DETAIL_UOM,GRADE_CODE,FORMULALINE_ID,PARENT_LINE_ID,LOT_CONTROL_CODE,
664: GRADE_CONTROL_FLAG,ACTION_CODE,SECONDARY_UOM,SECONDARY_DEFAULT_IND,

Line 899: FROM gmd_material_details_gtmp

895: AND b.organization_id = V_orgn_id;
896:
897: CURSOR Cur_line_id IS
898: SELECT MAX(line_id)
899: FROM gmd_material_details_gtmp
900: WHERE entity_id = V_entity_id;
901:
902: CURSOR Cur_formulaline_id IS
903: SELECT gem5_formulaline_id_s.NEXTVAL

Line 912: FROM gmd_material_details_gtmp

908: FROM dual;
909:
910: CURSOR Cur_get_materials (Pline_id NUMBER) IS
911: SELECT *
912: FROM gmd_material_details_gtmp
913: WHERE line_id = Pline_id;
914:
915: CURSOR Cur_get_batch IS
916: SELECT *

Line 960: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

956: FETCH Cur_get_item INTO l_item_rec;
957: CLOSE Cur_get_item;
958: l_line_id := l_line_id + 1;
959:
960: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
961: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,
962: DESCRIPTION,EXPAND_IND,QTY,DETAIL_UOM,GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,TRACKING_QUANTITY_IND,SECONDARY_DEFAULT_IND,
963: LOT_CONTROL_CODE,GRADE_CONTROL_FLAG,LOCATION_CONTROL_CODE,TEXT_CODE,ORGINAL_TEXT_CODE,FORMULALINE_ID,
964: MATERIAL_DETAIL_ID,PARENT_LINE_ID,ACTION_CODE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,

Line 1050: FROM gmd_material_details_gtmp

1046: PROCEDURE load_spread_values (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,
1047: V_orgn_id IN NUMBER,V_parent_line_id IN NUMBER) IS
1048: CURSOR Cur_get_line IS
1049: SELECT line_id
1050: FROM gmd_material_details_gtmp
1051: WHERE parent_line_id = V_parent_line_id
1052: ORDER BY line_type;
1053: BEGIN
1054: /* Inserting the technical parameter data of item and lot to temp tables*/

Line 1062: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1058: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1059: SELECT a.sprd_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1060: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1061: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1062: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1063: WHERE a.tech_parm_id = b.tech_parm_id
1064: AND a.sprd_id = V_entity_id
1065: AND a.line_id = c.sprd_line_id
1066: AND a.organization_id = V_orgn_id

Line 1089: FROM gmd_material_details_gtmp

1085: V_orgn_id IN NUMBER,V_matl_detl_id IN NUMBER,
1086: V_line_id IN NUMBER,V_plant_id IN NUMBER) IS
1087: CURSOR Cur_get_line IS
1088: SELECT line_id
1089: FROM gmd_material_details_gtmp
1090: WHERE parent_line_id = V_matl_detl_id
1091: ORDER BY line_type;
1092: BEGIN
1093: /* Inserting the technical parameter data of item and lot to temp tables*/

Line 1101: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1097: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1098: SELECT V_entity_id,c.line_id,a.tech_parm_name, a.tech_parm_id,
1099: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1100: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1101: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1102: WHERE a.tech_parm_id = b.tech_parm_id
1103: AND a.organization_id = V_orgn_id
1104: AND a.inventory_item_id = c.inventory_item_id
1105: AND c.parent_line_id = V_matl_detl_id

Line 1152: FROM gmd_material_details_gtmp

1148: V_orgn_id IN NUMBER,V_formulaline_id IN NUMBER,
1149: V_line_id IN NUMBER,V_plant_id IN NUMBER) IS
1150: CURSOR Cur_get_line IS
1151: SELECT line_id
1152: FROM gmd_material_details_gtmp
1153: WHERE (V_formulaline_id IS NULL OR parent_line_id = V_formulaline_id)
1154: ORDER BY line_type;
1155: BEGIN
1156: /* Inserting the technical parameter data of item and lot to temp tables*/

Line 1164: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1160: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1161: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1162: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1163: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1164: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1165: WHERE a.tech_parm_id = b.tech_parm_id
1166: AND a.organization_id = V_orgn_id
1167: AND a.inventory_item_id = c.inventory_item_id
1168: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1228: FROM gmd_material_details_gtmp

1224: text_code,subinventory_code,location,locator_id,lot_number,expiration_date,grade_code,
1225: transaction_id,reservation_id,secondary_qty,secondary_uom,buffer_ind,revision,
1226: revision_qty_control_code,plant_organization_id,organization_id,
1227: last_updated_by,last_update_date,created_by,creation_date
1228: FROM gmd_material_details_gtmp
1229: WHERE entity_id = V_entity_id;
1230: X_sprd_id NUMBER(10);
1231: X_line_id NUMBER(10);
1232: l_user_id NUMBER;

Line 1358: FROM gmd_material_details_gtmp

1354:
1355: CURSOR Cur_line_qty IS
1356: SELECT inventory_item_id, lot_number, qty,
1357: detail_uom,primary_uom,secondary_uom
1358: FROM gmd_material_details_gtmp
1359: WHERE line_id = V_line_id;
1360:
1361: CURSOR Cur_line_item_number (V_inventory_item_id NUMBER)IS
1362: SELECT concatenated_segments

Line 1440: UPDATE gmd_material_details_gtmp

1436: ELSE
1437: l_primary_qty := l_rec.qty;
1438: END IF;
1439:
1440: UPDATE gmd_material_details_gtmp
1441: SET qty_mass = l_mass_qty,
1442: mass_uom = V_mass_uom,
1443: qty_vol = l_vol_qty,
1444: vol_uom = V_vol_uom,

Line 1483: FROM gmd_material_details_gtmp

1479: V_vol_uom IN VARCHAR2,
1480: X_return_status OUT NOCOPY VARCHAR2) IS
1481: CURSOR Cur_get_lines IS
1482: SELECT line_id
1483: FROM gmd_material_details_gtmp
1484: WHERE rollup_ind = 1
1485: AND line_type <> 1
1486: AND entity_id = V_entity_id;
1487:

Line 1525: FROM gmd_material_details_gtmp

1521: WHERE qcassy_typ_id IS NOT NULL;
1522:
1523: CURSOR Cur_get_data IS
1524: SELECT *
1525: FROM gmd_material_details_gtmp
1526: WHERE line_id = V_line_id;
1527:
1528: l_rec Cur_get_data%ROWTYPE;
1529: l_return_status VARCHAR2(1);

Line 1638: FROM gmd_technical_data_gtmp a, gmd_material_details_gtmp c

1634: AND organization_id = P_orgn_id;
1635:
1636: CURSOR cur_get_value (v_tech_parm_id NUMBER) IS
1637: SELECT a.value
1638: FROM gmd_technical_data_gtmp a, gmd_material_details_gtmp c
1639: WHERE a.tech_parm_id = v_tech_parm_id
1640: AND c.parent_line_id = P_parent_detl_id
1641: AND a.line_id = c.line_id
1642: AND c.line_type <> 3;

Line 1646: FROM gmd_material_details_gtmp p

1642: AND c.line_type <> 3;
1643:
1644: CURSOR cur_get_data (v_tech_parm_id NUMBER) IS
1645: SELECT line_id
1646: FROM gmd_material_details_gtmp p
1647: WHERE parent_line_id = P_parent_detl_id
1648: AND line_type = 3
1649: AND NOT EXISTS ( SELECT 1
1650: FROM gmd_technical_data_gtmp g

Line 1708: FROM gmd_material_details_gtmp

1704: l_formula_rec Cur_get_lcf%ROWTYPE;
1705: l_secondary_qty NUMBER;
1706: CURSOR Cur_get_lines IS
1707: SELECT formulaline_id
1708: FROM gmd_material_details_gtmp
1709: WHERE entity_id = V_entity_id;
1710: BEGIN
1711: /* Inserting the item and lot data from formula detail tables to temp tables*/
1712: IF (V_orgn_id IS NOT NULL) THEN

Line 1733: INSERT INTO GMD_MATERIAL_DETAILS_GTMP

1729: l_secondary_qty := NULL;
1730: END IF;
1731: END IF;
1732:
1733: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
1734: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,EXPAND_IND,TRACKING_QUANTITY_IND,
1735: LOCATION_CONTROL_CODE,INVENTORY_ITEM_ID,DESCRIPTION,
1736: QTY,SECONDARY_QTY,DETAIL_UOM,GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,LOT_CONTROL_CODE,
1737: GRADE_CONTROL_FLAG,FORMULALINE_ID,PARENT_LINE_ID,

Line 1780: FROM gmd_material_details_gtmp

1776: V_formulaline_id IN NUMBER,V_plant_id IN NUMBER,
1777: V_line_id IN NUMBER) IS
1778: CURSOR Cur_get_line IS
1779: SELECT line_id
1780: FROM gmd_material_details_gtmp
1781: WHERE (V_formulaline_id IS NULL OR parent_line_id = V_formulaline_id)
1782: ORDER BY line_type;
1783: BEGIN
1784: /* Inserting the technical parameter data of item and lot to temp tables*/

Line 1792: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1788: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1789: SELECT V_entity_id,c.line_id,b.tech_parm_name,a.tech_parm_id,
1790: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1791: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1792: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1793: WHERE a.tech_parm_id = b.tech_parm_id
1794: AND a.organization_id = V_orgn_id
1795: AND a.inventory_item_id = c.inventory_item_id
1796: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1824: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1820:
1821: PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER) IS
1822: CURSOR Cur_get_type IS
1823: SELECT a.*, c.line_id line, b.tech_parm_id tech, b.tech_parm_name name,b.sort_seq, c.inventory_item_id
1824: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1825: WHERE a.tech_parm_id = b.tech_parm_id
1826: AND c.line_id = V_line_id;
1827: l_value NUMBER;
1828: l_parm_value VARCHAR2(240);