DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on GMF_BATCH_REQUIREMENTS

Line 200: FROM gmf_batch_requirements

196:
197: l_req_count := 0;
198: SELECT count(*)
199: INTO l_req_count
200: FROM gmf_batch_requirements
201: WHERE batch_id = p_tran_rec.transaction_source_id
202: AND delete_mark = 0;
203:
204: IF l_req_count = 0 THEN

Line 288: gmf_batch_requirements r,

284:
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

Line 687: gmf_batch_requirements r,

683:
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