APPS.GME_TRANS_ENGINE_UTIL dependencies on GME_MATERIAL_DETAILS

Line 306: FROM ic_tran_pnd i, gme_material_details g

302: ABS (i.trans_qty),
303: i.trans_um,
304: g.item_um,
305: 0) )
306: FROM ic_tran_pnd i, gme_material_details g
307: WHERE doc_id = p_batch_row.batch_id AND
308: doc_type = l_doc_type AND
309: line_id = g.material_detail_id AND
310: -- Bug 3777331 commented next condition since not needed

Line 823: FROM gme_material_details

819: IS
820: CURSOR cur_get_matl (v_batch_id gme_batch_header.batch_id%TYPE)
821: IS
822: SELECT material_detail_id
823: FROM gme_material_details
824: WHERE batch_id = v_batch_id;
825:
826: get_matl_rec cur_get_matl%ROWTYPE;
827: l_def_trans_id ic_tran_pnd.trans_id%TYPE;

Line 900: p_line_id IN gme_material_details.material_detail_id%TYPE

896: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
897: END deduce_transaction_warehouse;
898:
899: PROCEDURE get_default_lot (
900: p_line_id IN gme_material_details.material_detail_id%TYPE
901: ,x_def_trans_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE
902: ,x_is_plain OUT NOCOPY BOOLEAN
903: ,x_return_status OUT NOCOPY VARCHAR2)
904: IS

Line 905: l_matl_dtl gme_material_details%ROWTYPE;

901: ,x_def_trans_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE
902: ,x_is_plain OUT NOCOPY BOOLEAN
903: ,x_return_status OUT NOCOPY VARCHAR2)
904: IS
905: l_matl_dtl gme_material_details%ROWTYPE;
906: l_item_mst ic_item_mst%ROWTYPE;
907: l_ic_tran_pnd ic_tran_pnd%ROWTYPE;
908: l_whse_loct_ctl ic_whse_mst.whse_code%TYPE;
909: l_def_lot_found BOOLEAN;

Line 913: ,v_line_id gme_material_details.material_detail_id%TYPE

909: l_def_lot_found BOOLEAN;
910:
911: CURSOR cur_get_def_trans (
912: v_batch_id gme_batch_header.batch_id%TYPE
913: ,v_line_id gme_material_details.material_detail_id%TYPE
914: ,v_doc_type gme_inventory_txns_gtmp.doc_type%TYPE)
915: IS
916: SELECT trans_id, whse_code
917: FROM gme_inventory_txns_gtmp

Line 958: FROM gme_material_details

954: x_def_trans_id := NULL;
955:
956: SELECT *
957: INTO l_matl_dtl
958: FROM gme_material_details
959: WHERE material_detail_id = p_line_id;
960:
961: SELECT *
962: INTO l_item_mst