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_LM_MIGRATION dependencies on DUAL

Line 36: FROM sys.dual;

32: BEGIN
33:
34: FOR C_get_tech_parms_rec IN C_get_tech_parms LOOP
35: SELECT gmd_tech_parm_id_s.nextval INTO l_tech_parm_id
36: FROM sys.dual;
37:
38: /* Create tech_parm_id for the hdr table - lm_tech_hdr */
39: UPDATE gmd_tech_parameters_b
40: SET tech_parm_id = l_tech_parm_id

Line 92: * Description : Get all items from lm_sprd_dtl that has dual uom

88: * PROCEDURE populate_lm_sprd_dtl_sec_qty
89: *
90: * Synopsis : populate_lm_sprd_dtl_sec_qty
91: *
92: * Description : Get all items from lm_sprd_dtl that has dual uom
93: * and derives the secondary qty a (i.e the qty value
94: * converted from primary to secondary uom).
95: *
96: *

Line 101: CURSOR C_check_Item_dual_ind(vItem_id NUMBER) IS

97: * History :
98: * Shyam Sitaraman 03/10/03 Initial Implementation
99: * *************************************************************** */
100: PROCEDURE populate_lm_sprd_dtl_sec_qty IS
101: CURSOR C_check_Item_dual_ind(vItem_id NUMBER) IS
102: SELECT item_um2
103: FROM ic_item_mst_b
104: Where item_id = vItem_id
105: AND dualum_ind > 0;

Line 105: AND dualum_ind > 0;

101: CURSOR C_check_Item_dual_ind(vItem_id NUMBER) IS
102: SELECT item_um2
103: FROM ic_item_mst_b
104: Where item_id = vItem_id
105: AND dualum_ind > 0;
106:
107: CURSOR C_get_lm_sprd_dtl IS
108: SELECT *
109: FROM lm_sprd_dtl;

Line 111: l_dual_um ic_item_mst_b.item_um2%TYPE;

107: CURSOR C_get_lm_sprd_dtl IS
108: SELECT *
109: FROM lm_sprd_dtl;
110:
111: l_dual_um ic_item_mst_b.item_um2%TYPE;
112:
113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);

Line 115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);

111: l_dual_um ic_item_mst_b.item_um2%TYPE;
112:
113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,

Line 116: FETCH C_check_Item_dual_ind INTO l_dual_um;

112:
113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,

Line 117: IF C_check_Item_dual_ind%FOUND THEN

113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,

Line 122: l_dual_um,0),

118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id
125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;
126: END IF;

Line 123: secondary_um = l_dual_um

119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id
125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;
126: END IF;
127: CLOSE C_check_Item_dual_ind;

Line 127: CLOSE C_check_Item_dual_ind;

123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id
125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;
126: END IF;
127: CLOSE C_check_Item_dual_ind;
128: END LOOP;
129: EXCEPTION
130: WHEN OTHERS THEN
131: P_line_no := P_line_no + 1;

Line 241: FROM sys.dual;

237: * *************************************************************** */
238: PROCEDURE insert_gmd_tech_seq_hdr(x_tech_seq_id OUT NOCOPY NUMBER) IS
239: BEGIN
240: SELECT gmd_tech_seq_id_s.nextval INTO x_tech_seq_id
241: FROM sys.dual;
242:
243: INSERT INTO gmd_technical_sequence_hdr
244: ( tech_seq_id
245: , orgn_code

Line 268: sys.dual

264: , v_lm_prlt_asc_rec.last_update_date
265: , v_lm_prlt_asc_rec.last_updated_by
266: , v_lm_prlt_asc_rec.last_update_login
267: FROM
268: sys.dual
269: WHERE NOT EXISTS (SELECT 1
270: FROM gmd_technical_sequence_hdr
271: WHERE orgn_code = v_lm_prlt_asc_rec.orgn_code);
272: EXCEPTION

Line 343: FROM sys.dual

339: , v_lm_prlt_asc_rec.created_by
340: , v_lm_prlt_asc_rec.last_update_date
341: , v_lm_prlt_asc_rec.last_updated_by
342: , v_lm_prlt_asc_rec.last_update_login
343: FROM sys.dual
344: WHERE NOT EXISTS
345: (SELECT 1 FROM gmd_technical_sequence_dtl
346: WHERE tech_parm_id = l_tech_parm_id
347: AND tech_seq_id = vTech_seq_id);

Line 462: FROM sys.dual;

458: PROCEDURE insert_gmd_tech_data_hdr(x_tech_data_id OUT NOCOPY NUMBER) IS
459:
460: BEGIN
461: SELECT gmd_tech_data_id_s.nextval INTO x_tech_data_id
462: FROM sys.dual;
463:
464: INSERT INTO gmd_technical_data_hdr
465: ( tech_data_id
466: , orgn_code

Line 493: sys.dual

489: , v_lm_item_dat_rec.last_update_date
490: , v_lm_item_dat_rec.last_updated_by
491: , v_lm_item_dat_rec.last_update_login
492: FROM
493: sys.dual
494: WHERE NOT EXISTS (SELECT 1
495: FROM gmd_technical_data_hdr
496: WHERE orgn_code = v_lm_item_dat_rec.orgn_code
497: AND item_id = v_lm_item_dat_rec.item_id);

Line 580: FROM sys.dual

576: , v_lm_item_dat_rec.created_by
577: , v_lm_item_dat_rec.last_update_date
578: , v_lm_item_dat_rec.last_updated_by
579: , v_lm_item_dat_rec.last_update_login
580: FROM sys.dual
581: WHERE NOT EXISTS
582: (SELECT 1 FROM gmd_technical_data_dtl
583: WHERE tech_parm_id = l_tech_parm_id
584: AND tech_data_id = vTech_data_id);