APPS.GMF_LAYERS dependencies on GMF_INCOMING_MATERIAL_LAYERS

Line 62: l_layer_rec gmf_incoming_material_layers%ROWTYPE;

58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2) IS
60:
61: l_layer_id NUMBER;
62: l_layer_rec gmf_incoming_material_layers%ROWTYPE;
63: l_doc_qty NUMBER;
64: l_doc_um VARCHAR2(4);
65: l_req_count PLS_INTEGER;
66:

Line 113: FROM gmf_incoming_material_layers l, mtl_material_transactions mmt,

109: IF (p_tran_rec.reverse_id IS NOT NULL and p_tran_rec.doc_qty IS NULL) THEN
110: BEGIN
111: SELECT -l.layer_doc_qty, l.layer_doc_um
112: INTO l_doc_qty, l_doc_um
113: FROM gmf_incoming_material_layers l, mtl_material_transactions mmt,
114: mtl_transaction_lot_numbers mtln
115: WHERE
116: mmt.transaction_id = p_tran_rec.reverse_id AND
117: mtln.transaction_id (+) = p_tran_rec.reverse_id AND

Line 150: INSERT INTO gmf_incoming_material_layers(

146: IF g_debug <= gme_debug.g_log_statement THEN
147: gme_debug.put_line ('creating incoming layer: ' || l_layer_id);
148: END IF;
149:
150: INSERT INTO gmf_incoming_material_layers(
151: layer_id,
152: mmt_transaction_id,
153: mmt_organization_id,
154: lot_number,

Line 289: gmf_incoming_material_layers l,

285: CURSOR c_null_vib_rows IS
286: SELECT v.rowid, v.*, mmt.organization_id, l.layer_date
287: FROM gmf_batch_vib_details v,
288: gmf_batch_requirements r,
289: gmf_incoming_material_layers l,
290: mtl_material_transactions mmt,
291: mtl_transaction_lot_numbers mtln
292: WHERE
293: r.batch_id = p_tran_rec.transaction_source_id AND

Line 688: gmf_incoming_material_layers l,

684: CURSOR c_null_vib_rows IS
685: SELECT v.rowid, v.*, t.organization_id, l.layer_date
686: FROM gmf_batch_vib_details v,
687: gmf_batch_requirements r,
688: gmf_incoming_material_layers l,
689: mtl_material_transactions t
690: WHERE
691: r.batch_id = p_rsrc_rec.doc_id AND
692: r.batchstep_resource_id = p_rsrc_rec.line_id AND