APPS.GMD_SAMPLES_GRP dependencies on DUAL

Line 1994: FROM DUAL;

1990: ) IS
1991: --xxx
1992: CURSOR Cur_get_seq IS
1993: SELECT gmd_qc_change_disp_id_s.NEXTVAL
1994: FROM DUAL;
1995:
1996: CURSOR Cur_get_lot IS
1997: SELECT lot_number
1998: FROM MTL_LOT_NUMBERS

Line 3673: FROM DUAL;

3669: AND rt.transaction_type = 'DELIVER';
3670:
3671: CURSOR Cur_get_seq IS
3672: SELECT mtl_material_transactions_s.NEXTVAL
3673: FROM DUAL;
3674:
3675: p_validation_level NUMBER := 100;
3676:
3677: -- 2995114

Line 3810: -- IF l_item_rec.Dual_uom_control = 3 THEN

3806: -- l_item_rec.organization_id := p_sample.organization_id;
3807:
3808: -- Gmd_samples_grp.Get_item_values( p_sample_display => l_item_rec);
3809:
3810: -- IF l_item_rec.Dual_uom_control = 3 THEN
3811: -- l_trans_rec.trans_qty2
3812: -- := INV_CONVERT.inv_um_convert(
3813: -- item_id => p_sample.inventory_item_id
3814: -- , precision => 5

Line 4022: dual_uom_control,

4018: AND d.inventory_item_id = p_sample.inventory_item_id;
4019:
4020: CURSOR c_item_no(p_item_id NUMBER) IS
4021: SELECT concatenated_segments item_no ,
4022: dual_uom_control,
4023: primary_uom_code,
4024: secondary_uom_code
4025: FROM mtl_system_items_b_kfv
4026: WHERE inventory_item_id = p_item_id

Line 4049: l_dualum_ind NUMBER(1);

4045: p_create_lot VARCHAR2(10) ; --BOOLEAN := TRUE;
4046: temp_lot_no VARCHAR2(32) := NULL;
4047: material_detail_item_um gme_material_details.dtl_um%TYPE;
4048: l_item_no VARCHAR2(80);
4049: l_dualum_ind NUMBER(1);
4050: l_item_um2 VARCHAR2(3);
4051: l_primary_uom_code VARCHAR2(3);
4052:
4053: BEGIN

Line 4097: l_dualum_ind ,

4093: END IF;
4094:
4095: OPEN c_item_no (p_sample.inventory_item_id);
4096: FETCH c_item_no INTO l_item_no ,
4097: l_dualum_ind ,
4098: l_primary_uom_code ,
4099: l_item_um2;
4100: CLOSE c_item_no;
4101:

Line 4174: IF l_dualum_ind = 3 THEN

4170: -- p_tran_row.doc_id := p_sample.batch_id;xxx
4171: -- p_tran_row.alloc_um := p_sample.sample_qty_uom;
4172: -- p_tran_row.completed_ind := 1;
4173:
4174: IF l_dualum_ind = 3 THEN
4175: -- bug 4165704: changed uom conversion routine for inventory convergence
4176: -- p_mmti_rec.secondary_transaction_quantity := gmicuom.uom_conversion(
4177: -- p_sample.inventory_item_id,
4178: -- 0,

Line 4963: Dual_uom_control,

4959: Lot_control_code,
4960: Lot_status_enabled,
4961: grade_control_flag,
4962: Primary_uom_code,
4963: Dual_uom_control,
4964: Eng_item_flag, -- (experimental item)
4965: Child_lot_flag, -- parent lot control
4966: Indivisible_flag,
4967: Serial_number_control_code, --(must = 0 to generate inv transaction)

Line 4994: p_sample_display.Dual_uom_control,

4990: p_sample_display.Lot_control_code,
4991: p_sample_display.Lot_status_enabled,
4992: p_sample_display.Grade_control_flag,
4993: p_sample_display.Primary_uom_code,
4994: p_sample_display.Dual_uom_control,
4995: p_sample_display.Eng_item_flag,
4996: p_sample_display.Child_lot_flag,
4997: p_sample_display.Indivisible_flag,
4998: p_sample_display.Serial_number_control_code,