APPS.GMO_DISPENSE_PVT dependencies on GME_MATERIAL_DETAILS

Line 12: gme_material_details gme

8: l_return_value Varchar2(240);
9: CURSOR C_GET_BATCH_PRODUCT IS
10: SELECT msi.concatenated_segments
11: FROM mtl_system_items_vl msi,
12: gme_material_details gme
13: WHERE gme.organization_id = msi.organization_id
14: AND gme.inventory_item_id = msi.inventory_item_id
15: AND gme.line_type = 1
16: AND gme.line_no = 1

Line 31: gme_material_details gme

27: l_return_value Varchar2(240);
28: CURSOR C_GET_BATCH_PRODUCT IS
29: SELECT msi.description
30: FROM mtl_system_items_vl msi,
31: gme_material_details gme
32: WHERE gme.organization_id = msi.organization_id
33: AND gme.inventory_item_id = msi.inventory_item_id
34: AND gme.line_type = 1
35: AND gme.line_no = 1

Line 473: gme_material_Details gmd,

469: IS
470: CURSOR C_GET_RESERVATIONS IS
471: SELECT res.*
472: FROM MTL_RESERVATIONS res,
473: gme_material_Details gmd,
474: gme_batch_header gbh
475: WHERE res.demand_source_type_id = 5
476: and res.inventory_item_id = gmd.inventory_item_id
477: and GBH.BATCH_ID = GMD.BATCH_ID

Line 498: FROM gme_material_details gmd

494: l_result_record mtl_reservations%ROWTYPE;
495: l_Pending_reservations_tab GME_COMMON_PVT.reservations_tab;
496: CURSOR C_GET_MATERIAL_LINE IS
497: SELECT gmd.organization_id
498: FROM gme_material_details gmd
499: WHERE gmd.material_detail_id = p_material_detail_id;
500: l_material_line C_GET_MATERIAL_LINE%ROWTYPE;
501: RES_UOM_CONV_EXCEPTION EXCEPTION;
502: DISP_NOT_REQ_EXCEPTION EXCEPTION;