APPS.GMD_SAMPLES_GRP dependencies on GME_MATERIAL_DETAILS

Line 3053: FROM gme_material_details md

3049: 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
3050: 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
3051: AND exists -- Only Batches with Spec Item in it
3052: (SELECT 1
3053: FROM gme_material_details md
3054: WHERE md.batch_id = bh.batch_id
3055: AND md.inventory_item_id = p_sample.inventory_item_id)
3056: ;
3057:

Line 3086: FROM gme_material_details

3082:
3083: -- Bug 4640143: added cursor
3084: CURSOR c_material_detail_id IS
3085: SELECT 1
3086: FROM gme_material_details
3087: WHERE inventory_item_id = p_sample.inventory_item_id
3088: AND batch_id = p_sample.batch_id
3089: AND organization_id = p_sample.organization_id
3090: AND material_detail_id = p_sample.material_detail_id;

Line 3999: FROM gme_material_details d,

3995: -- with byproduct type as sample.
3996: CURSOR Cur_material_detail_with_step IS
3997: SELECT d.material_detail_id,
3998: d.inventory_item_id, d.revision, d.dtl_um --RLNAGARA B5738041 Added Revision
3999: FROM gme_material_details d,
4000: gme_batch_step_items i
4001: WHERE d.material_detail_id = i.material_detail_id
4002: AND d.line_type = 2
4003: AND d.release_type = 1

Line 4013: FROM gme_material_details d

4009:
4010: CURSOR Cur_material_detail_no_step IS
4011: SELECT d.material_detail_id,
4012: d.inventory_item_id, d.revision, d.dtl_um --RLNAGARA B5738041 Added Revision
4013: FROM gme_material_details d
4014: WHERE d.line_type = 2
4015: AND d.release_type = 1
4016: AND d.by_product_type = 'S'
4017: AND d.batch_id = p_sample.batch_id

Line 4036: --x_material_detail gme_material_details%ROWTYPE;

4032: x_mmt_rec mtl_material_transactions%ROWTYPE;
4033: x_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
4034:
4035: --p_tran_row gme_inventory_txns_gtmp%ROWTYPE;
4036: --x_material_detail gme_material_details%ROWTYPE;
4037: --x_tran_row gme_inventory_txns_gtmp%ROWTYPE;
4038: x_def_tran_row gme_inventory_txns_gtmp%ROWTYPE;
4039: p_validation_level NUMBER := 100; --gme_api_pub.max_errors;
4040:

Line 4047: material_detail_item_um gme_material_details.dtl_um%TYPE;

4043: dummy_number NUMBER := 0;
4044:
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);

Line 5504: FROM gme_material_details md,

5500:
5501: CURSOR Cur_batchline IS
5502: SELECT line_no,
5503: gem.meaning
5504: FROM gme_material_details md,
5505: gem_lookups gem
5506: WHERE batch_id = P_batch_id
5507: AND material_detail_id = P_material_detail_id
5508: AND inventory_item_id = P_inventory_item_id