APPS.GMD_SAMPLES_GRP dependencies on GME_MATERIAL_DETAILS

Line 3648: FROM gme_material_details md

3644: AND ( ( bh.batch_status IN (1,2) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) -- Bug # 4619570 Pending or WIP Batches Only
3645: OR ( bh.batch_status IN (1,2, 4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Pending or WIP Or Closed Batches Only
3646: AND exists -- Only Batches with Spec Item in it
3647: (SELECT 1
3648: FROM gme_material_details md
3649: WHERE md.batch_id = bh.batch_id
3650: AND md.inventory_item_id = p_sample.inventory_item_id)
3651: ;
3652:

Line 3681: FROM gme_material_details

3677:
3678: -- Bug 4640143: added cursor
3679: CURSOR c_material_detail_id IS
3680: SELECT 1
3681: FROM gme_material_details
3682: WHERE inventory_item_id = p_sample.inventory_item_id
3683: AND batch_id = p_sample.batch_id
3684: AND organization_id = p_sample.organization_id
3685: AND material_detail_id = p_sample.material_detail_id;

Line 4644: FROM gme_material_details d,

4640: -- with byproduct type as sample.
4641: CURSOR Cur_material_detail_with_step IS
4642: SELECT d.material_detail_id,
4643: d.inventory_item_id, d.revision, d.dtl_um --RLNAGARA B5738041 Added Revision
4644: FROM gme_material_details d,
4645: gme_batch_step_items i
4646: WHERE d.material_detail_id = i.material_detail_id
4647: AND d.line_type = 2
4648: AND d.release_type = 1

Line 4658: FROM gme_material_details d

4654:
4655: CURSOR Cur_material_detail_no_step IS
4656: SELECT d.material_detail_id,
4657: d.inventory_item_id, d.revision, d.dtl_um --RLNAGARA B5738041 Added Revision
4658: FROM gme_material_details d
4659: WHERE d.line_type = 2
4660: AND d.release_type = 1
4661: AND d.by_product_type = 'S'
4662: AND d.batch_id = p_sample.batch_id

Line 4681: --x_material_detail gme_material_details%ROWTYPE;

4677: x_mmt_rec mtl_material_transactions%ROWTYPE;
4678: x_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
4679:
4680: --p_tran_row gme_inventory_txns_gtmp%ROWTYPE;
4681: --x_material_detail gme_material_details%ROWTYPE;
4682: --x_tran_row gme_inventory_txns_gtmp%ROWTYPE;
4683: x_def_tran_row gme_inventory_txns_gtmp%ROWTYPE;
4684: p_validation_level NUMBER := 100; --gme_api_pub.max_errors;
4685:

Line 4692: material_detail_item_um gme_material_details.dtl_um%TYPE;

4688: dummy_number NUMBER := 0;
4689:
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);

Line 6172: FROM gme_material_details md,

6168:
6169: CURSOR Cur_batchline IS
6170: SELECT line_no,
6171: gem.meaning
6172: FROM gme_material_details md,
6173: gem_lookups gem
6174: WHERE batch_id = P_batch_id
6175: AND material_detail_id = P_material_detail_id
6176: AND inventory_item_id = P_inventory_item_id