APPS.GMD_SAMPLES_GRP dependencies on DUAL

Line 2176: FROM DUAL;

2172: ) IS
2173: --xxx
2174: CURSOR Cur_get_seq IS
2175: SELECT gmd_qc_change_disp_id_s.NEXTVAL
2176: FROM DUAL;
2177:
2178: CURSOR Cur_get_lot IS
2179: SELECT lot_number
2180: FROM MTL_LOT_NUMBERS

Line 4310: FROM DUAL;

4306: AND rt.transaction_type = 'DELIVER';
4307:
4308: CURSOR Cur_get_seq IS
4309: SELECT mtl_material_transactions_s.NEXTVAL
4310: FROM DUAL;
4311:
4312: p_validation_level NUMBER := 100;
4313:
4314: -- 2995114

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

4444: -- l_item_rec.organization_id := p_sample.organization_id;
4445:
4446: -- Gmd_samples_grp.Get_item_values( p_sample_display => l_item_rec);
4447:
4448: -- IF l_item_rec.Dual_uom_control = 3 THEN
4449: -- l_trans_rec.trans_qty2
4450: -- := INV_CONVERT.inv_um_convert(
4451: -- item_id => p_sample.inventory_item_id
4452: -- , precision => 5

Line 4667: dual_uom_control,

4663: AND d.inventory_item_id = p_sample.inventory_item_id;
4664:
4665: CURSOR c_item_no(p_item_id NUMBER) IS
4666: SELECT concatenated_segments item_no ,
4667: dual_uom_control,
4668: primary_uom_code,
4669: secondary_uom_code
4670: FROM mtl_system_items_b_kfv
4671: WHERE inventory_item_id = p_item_id

Line 4694: l_dualum_ind NUMBER(1);

4690: p_create_lot VARCHAR2(10) ; --BOOLEAN := TRUE;
4691: temp_lot_no VARCHAR2(32) := NULL;
4692: material_detail_item_um gme_material_details.dtl_um%TYPE;
4693: l_item_no VARCHAR2(80);
4694: l_dualum_ind NUMBER(1);
4695: l_item_um2 VARCHAR2(3);
4696: l_primary_uom_code VARCHAR2(3);
4697:
4698: BEGIN

Line 4742: l_dualum_ind ,

4738: END IF;
4739:
4740: OPEN c_item_no (p_sample.inventory_item_id);
4741: FETCH c_item_no INTO l_item_no ,
4742: l_dualum_ind ,
4743: l_primary_uom_code ,
4744: l_item_um2;
4745: CLOSE c_item_no;
4746:

Line 4819: IF l_dualum_ind = 3 THEN

4815: -- p_tran_row.doc_id := p_sample.batch_id;xxx
4816: -- p_tran_row.alloc_um := p_sample.sample_qty_uom;
4817: -- p_tran_row.completed_ind := 1;
4818:
4819: IF l_dualum_ind = 3 THEN
4820: -- bug 4165704: changed uom conversion routine for inventory convergence
4821: -- p_mmti_rec.secondary_transaction_quantity := gmicuom.uom_conversion(
4822: -- p_sample.inventory_item_id,
4823: -- 0,

Line 5630: Dual_uom_control,

5626: Lot_control_code,
5627: Lot_status_enabled,
5628: grade_control_flag,
5629: Primary_uom_code,
5630: Dual_uom_control,
5631: Eng_item_flag, -- (experimental item)
5632: Child_lot_flag, -- parent lot control
5633: Indivisible_flag,
5634: Serial_number_control_code, --(must = 0 to generate inv transaction)

Line 5662: p_sample_display.Dual_uom_control,

5658: p_sample_display.Lot_control_code,
5659: p_sample_display.Lot_status_enabled,
5660: p_sample_display.Grade_control_flag,
5661: p_sample_display.Primary_uom_code,
5662: p_sample_display.Dual_uom_control,
5663: p_sample_display.Eng_item_flag,
5664: p_sample_display.Child_lot_flag,
5665: p_sample_display.Indivisible_flag,
5666: p_sample_display.Serial_number_control_code,