[Home] [Help]
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
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
100: CLOSE Cur_get_formula_text;
101: l_parent_line_id := l_spread_rec.formulaline_id;
102: END IF;
103: --Bug12346394 is fixed by adding the code to insert the detial uom instead of items primary uom (l_spread_rec.detail_uom).
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,
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
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;
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,
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,
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,
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,
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
518: ORDER BY a.formulaline_id,b.lot_number;
519:
520: CURSOR Cur_get_lines IS
521: SELECT formulaline_id
522: FROM gmd_material_details_gtmp
523: WHERE entity_id = V_entity_id
524: AND line_type <> 3 ;
525:
526: l_line_id NUMBER DEFAULT 0;
620: ELSIF l_formula_rec.line_type = 1 THEN
621: l_tpformula_id := V_formula_id ;
622: END IF; /*Added in Bug No.7462584 */
623:
624: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
625: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,EXPAND_IND,TRACKING_QUANTITY_IND,
626: LOCATION_CONTROL_CODE,INVENTORY_ITEM_ID,DESCRIPTION,TPFORMULA_ID,
627: QTY,SECONDARY_QTY,DETAIL_UOM,GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,LOT_CONTROL_CODE,
628: GRADE_CONTROL_FLAG,REVISION,TEXT_CODE,ORGINAL_TEXT_CODE,FORMULALINE_ID,PARENT_LINE_ID,
657: ELSE
658: l_secondary_qty := NULL;
659: END IF;
660:
661: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
662: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,TRACKING_QUANTITY_IND,LOCATION_CONTROL_CODE,
663: INVENTORY_ITEM_ID,EXPAND_IND,EXPIRATION_DATE,LOT_NUMBER,QTY,SECONDARY_QTY,
664: DETAIL_UOM,GRADE_CODE,FORMULALINE_ID,PARENT_LINE_ID,LOT_CONTROL_CODE,
665: GRADE_CONTROL_FLAG,ACTION_CODE,SECONDARY_UOM,SECONDARY_DEFAULT_IND,
925: AND b.organization_id = V_orgn_id;
926:
927: CURSOR Cur_line_id IS
928: SELECT MAX(line_id)
929: FROM gmd_material_details_gtmp
930: WHERE entity_id = V_entity_id;
931:
932: CURSOR Cur_formulaline_id IS
933: SELECT gem5_formulaline_id_s.NEXTVAL
938: FROM dual;
939:
940: CURSOR Cur_get_materials (Pline_id NUMBER) IS
941: SELECT *
942: FROM gmd_material_details_gtmp
943: WHERE line_id = Pline_id;
944:
945: CURSOR Cur_get_batch IS
946: SELECT *
986: FETCH Cur_get_item INTO l_item_rec;
987: CLOSE Cur_get_item;
988: l_line_id := l_line_id + 1;
989:
990: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
991: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,INVENTORY_ITEM_ID,
992: DESCRIPTION,EXPAND_IND,QTY,DETAIL_UOM,GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,TRACKING_QUANTITY_IND,SECONDARY_DEFAULT_IND,
993: LOT_CONTROL_CODE,GRADE_CONTROL_FLAG,LOCATION_CONTROL_CODE,TEXT_CODE,ORGINAL_TEXT_CODE,FORMULALINE_ID,
994: MATERIAL_DETAIL_ID,PARENT_LINE_ID,ACTION_CODE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1079: PROCEDURE load_spread_values (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,
1080: V_orgn_id IN NUMBER,V_parent_line_id IN NUMBER) IS
1081: CURSOR Cur_get_line IS
1082: SELECT line_id
1083: FROM gmd_material_details_gtmp
1084: WHERE parent_line_id = V_parent_line_id
1085: ORDER BY line_type;
1086: BEGIN
1087: /* Inserting the technical parameter data of item and lot to temp tables*/
1091: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1092: SELECT a.sprd_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1093: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1094: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1095: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1096: WHERE a.tech_parm_id = b.tech_parm_id
1097: AND a.sprd_id = V_entity_id
1098: AND a.line_id = c.sprd_line_id
1099: AND a.organization_id = V_orgn_id
1118: V_orgn_id IN NUMBER,V_matl_detl_id IN NUMBER,
1119: V_line_id IN NUMBER,V_plant_id IN NUMBER) IS
1120: CURSOR Cur_get_line IS
1121: SELECT line_id
1122: FROM gmd_material_details_gtmp
1123: WHERE parent_line_id = V_matl_detl_id
1124: ORDER BY line_type;
1125: BEGIN
1126: /* Inserting the technical parameter data of item and lot to temp tables*/
1130: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1131: SELECT V_entity_id,c.line_id,a.tech_parm_name, a.tech_parm_id,
1132: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1133: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1134: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1135: WHERE a.tech_parm_id = b.tech_parm_id
1136: AND a.organization_id = V_orgn_id
1137: AND a.inventory_item_id = c.inventory_item_id
1138: AND (V_matl_detl_id IS NULL OR c.parent_line_id = V_matl_detl_id)
1181: V_orgn_id IN NUMBER,V_formulaline_id IN NUMBER,
1182: V_line_id IN NUMBER,V_plant_id IN NUMBER) IS
1183: CURSOR Cur_get_line IS
1184: SELECT line_id
1185: FROM gmd_material_details_gtmp
1186: WHERE (V_formulaline_id IS NULL OR parent_line_id = V_formulaline_id)
1187: ORDER BY line_type;
1188: BEGIN
1189: /* Inserting the technical parameter data of item and lot to temp tables*/
1193: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1194: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1195: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1196: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1197: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1198: WHERE a.tech_parm_id = b.tech_parm_id
1199: AND a.organization_id = V_orgn_id
1200: AND a.inventory_item_id = c.inventory_item_id
1201: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)
1258: text_code,subinventory_code,location,locator_id,lot_number,expiration_date,grade_code,
1259: transaction_id,reservation_id,secondary_qty,secondary_uom,buffer_ind,revision,
1260: revision_qty_control_code,plant_organization_id,organization_id,
1261: tpformula_id,last_updated_by,last_update_date,created_by,creation_date,prod_percent--added tpformula_id for Bug#7254259
1262: FROM gmd_material_details_gtmp
1263: WHERE entity_id = V_entity_id;
1264: X_sprd_id NUMBER(10);
1265: X_line_id NUMBER(10);
1266: l_user_id NUMBER;
1388:
1389: CURSOR Cur_line_qty IS
1390: SELECT inventory_item_id, lot_number, qty,
1391: detail_uom,primary_uom,secondary_uom
1392: FROM gmd_material_details_gtmp
1393: WHERE line_id = V_line_id;
1394:
1395: CURSOR Cur_line_item_number (V_inventory_item_id NUMBER)IS
1396: SELECT concatenated_segments
1481: ELSE
1482: l_primary_qty := l_rec.qty;
1483: END IF;
1484:
1485: UPDATE gmd_material_details_gtmp
1486: SET qty_mass = l_mass_qty,
1487: mass_uom = V_mass_uom,
1488: qty_vol = l_vol_qty,
1489: vol_uom = V_vol_uom,
1523: V_vol_uom IN VARCHAR2,
1524: X_return_status OUT NOCOPY VARCHAR2) IS
1525: CURSOR Cur_get_lines IS
1526: SELECT line_id
1527: FROM gmd_material_details_gtmp
1528: WHERE rollup_ind = 1
1529: AND line_type <> 1
1530: AND entity_id = V_entity_id;
1531:
1565: WHERE qcassy_typ_id IS NOT NULL;
1566:
1567: CURSOR Cur_get_data IS
1568: SELECT *
1569: FROM gmd_material_details_gtmp
1570: WHERE line_id = V_line_id;
1571:
1572: l_rec Cur_get_data%ROWTYPE;
1573: l_return_status VARCHAR2(1);
1678: AND organization_id = P_orgn_id;
1679:
1680: CURSOR cur_get_value (v_tech_parm_id NUMBER) IS
1681: SELECT a.value
1682: FROM gmd_technical_data_gtmp a, gmd_material_details_gtmp c
1683: WHERE a.tech_parm_id = v_tech_parm_id
1684: AND c.parent_line_id = P_parent_detl_id
1685: AND a.line_id = c.line_id
1686: AND c.line_type <> 3;
1686: AND c.line_type <> 3;
1687:
1688: CURSOR cur_get_data (v_tech_parm_id NUMBER) IS
1689: SELECT line_id
1690: FROM gmd_material_details_gtmp p
1691: WHERE parent_line_id = P_parent_detl_id
1692: AND line_type = 3
1693: AND NOT EXISTS ( SELECT 1
1694: FROM gmd_technical_data_gtmp g
1748: l_formula_rec Cur_get_lcf%ROWTYPE;
1749: l_secondary_qty NUMBER;
1750: CURSOR Cur_get_lines IS
1751: SELECT formulaline_id
1752: FROM gmd_material_details_gtmp
1753: WHERE entity_id = V_entity_id;
1754: BEGIN
1755: /* Inserting the item and lot data from formula detail tables to temp tables*/
1756: IF (V_orgn_id IS NOT NULL) THEN
1773: l_secondary_qty := NULL;
1774: END IF;
1775: END IF;
1776:
1777: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
1778: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,EXPAND_IND,TRACKING_QUANTITY_IND,
1779: LOCATION_CONTROL_CODE,INVENTORY_ITEM_ID,DESCRIPTION,
1780: QTY,SECONDARY_QTY,DETAIL_UOM,GRADE_CODE,PRIMARY_UOM,SECONDARY_UOM,LOT_CONTROL_CODE,
1781: GRADE_CONTROL_FLAG,FORMULALINE_ID,PARENT_LINE_ID,
1823: V_formulaline_id IN NUMBER,V_plant_id IN NUMBER,
1824: V_line_id IN NUMBER) IS
1825: CURSOR Cur_get_line IS
1826: SELECT line_id
1827: FROM gmd_material_details_gtmp
1828: WHERE (V_formulaline_id IS NULL OR parent_line_id = V_formulaline_id)
1829: ORDER BY line_type;
1830: BEGIN
1831: /* Inserting the technical parameter data of item and lot to temp tables*/
1835: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1836: SELECT V_entity_id,c.line_id,b.tech_parm_name,a.tech_parm_id,
1837: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1838: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1839: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1840: WHERE a.tech_parm_id = b.tech_parm_id
1841: AND a.organization_id = V_orgn_id
1842: AND a.inventory_item_id = c.inventory_item_id
1843: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)
1868: PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER) IS
1869: CURSOR Cur_get_type IS
1870: SELECT a.*, c.line_id line, b.tech_parm_id tech, b.tech_parm_name name,b.sort_seq,
1871: c.inventory_item_id,c.detail_uom
1872: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1873: WHERE a.tech_parm_id = b.tech_parm_id
1874: AND c.line_id = V_line_id;
1875: CURSOR Cur_get_item (V_inv_item_id NUMBER) IS
1876: SELECT primary_uom_code
1944:
1945:
1946: /* CURSOR Cur_get_materials IS
1947: SELECT a.*,b.lot_no lot, b.sublot_no sublot, b.lot_id item_lotid, b.expire_date expire, b.item_id itemid
1948: FROM gmd_material_details_gtmp a, ic_lots_mst b, (select item_id,lot_id from gmd_technical_data_vl group by item_id,lot_id) c
1949: WHERE a.entity_id = V_formula_id
1950: AND a.item_id = b.item_id
1951: AND a.item_id = c.item_id
1952: AND b.lot_id = c.lot_id
1957:
1958:
1959: CURSOR Cur_get_materials IS
1960: SELECT a.*,b.PARENT_LOT_NUMBER lot, b.LOT_NUMBER sublot, NULL item_lotid, b.EXPIRATION_DATE expire, b.inventory_item_id itemid
1961: FROM gmd_material_details_gtmp a, MTL_LOT_NUMBERS b,
1962: (select inventory_item_id,lot_NUMBER from gmd_technical_data_vl group by inventory_item_id,lot_NUMBER) c
1963: WHERE a.entity_id = V_formula_id
1964: AND a.inventory_item_id = b.inventory_item_id
1965: AND a.inventory_item_id = c.inventory_item_id
1971:
1972:
1973: CURSOR Cur_get_lines IS
1974: SELECT formulaline_id
1975: FROM gmd_material_details_gtmp
1976: WHERE entity_id = V_entity_id
1977: AND line_type <> 3 ;
1978:
1979: l_line_id NUMBER DEFAULT 0;
2023: END IF;
2024:
2025: l_tpformula_id := V_formula_id;
2026:
2027: UPDATE GMD_MATERIAL_DETAILS_GTMP
2028: SET TPFORMULA_ID = l_tpformula_id,
2029: FORMULALINE_ID = l_formula_rec.formulaline_id,
2030: PARENT_LINE_ID = l_formula_rec.formulaline_id
2031: WHERE ENTITY_ID = V_entity_id
2049: ELSE
2050: l_secondary_qty := NULL;
2051: END IF;
2052:
2053: DELETE FROM GMD_MATERIAL_DETAILS_GTMP
2054: WHERE ENTITY_ID = V_entity_id
2055: AND LINE_ID = V_line_id;
2056:
2057: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
2053: DELETE FROM GMD_MATERIAL_DETAILS_GTMP
2054: WHERE ENTITY_ID = V_entity_id
2055: AND LINE_ID = V_line_id;
2056:
2057: INSERT INTO GMD_MATERIAL_DETAILS_GTMP
2058: (ENTITY_ID,LINE_ID,LINE_TYPE,LINE_NO,ROLLUP_IND,DUALUM_IND,LOCT_CTL,ITEM_ID,EXPAND_IND,EXPIRE_DATE,
2059: LOT_ID,LOT_NO,SUBLOT_NO,QTY,SECONDARY_QTY,ITEM_UM,QC_GRADE,FORMULALINE_ID,PARENT_LINE_ID,
2060: LOT_CTL,SUBLOT_CTL,GRADE_CTL,ACTION_CODE,SECONDARY_UM,
2061: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,
2090: V_orgn_id IN number,V_formulaline_id IN NUMBER,
2091: V_line_id IN NUMBER,V_item_id IN NUMBER,V_plant_id IN number) IS
2092: CURSOR Cur_get_line IS
2093: SELECT line_id
2094: FROM gmd_material_details_gtmp
2095: WHERE (V_formulaline_id IS NULL OR parent_line_id = V_formulaline_id)
2096: ORDER BY line_type;
2097:
2098:
2109: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2110: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
2111: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2112: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2113: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
2114: WHERE a.tech_parm_id = b.tech_parm_id
2115: AND a.organization_id = V_orgn_id
2116: AND a.item_id = c.item_id
2117: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)
2133: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2134: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
2135: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2136: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2137: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
2138: WHERE a.tech_parm_id = b.tech_parm_id
2139: AND a.organization_id = V_orgn_id
2140: AND a.inventory_item_id = c.inventory_item_id
2141: and c.organization_id = V_orgn_id
2164: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2165: SELECT V_entity_id,V_line_id,a.tech_parm_name,a.tech_parm_id,
2166: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2167: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2168: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b--, gmd_material_details_gtmp c
2169: WHERE a.tech_parm_id = b.tech_parm_id
2170: AND a.organization_id = V_orgn_id ---1
2171: AND a.inventory_item_id = V_item_id
2172: AND a.formula_id is null