APPS.GMF_LAYERS dependencies on GMF_BATCH_REQUIREMENTS

Line 206: FROM gmf_batch_requirements

202:
203: l_req_count := 0;
204: SELECT count(*)
205: INTO l_req_count
206: FROM gmf_batch_requirements
207: WHERE batch_id = p_tran_rec.transaction_source_id
208: AND delete_mark = 0;
209:
210: IF l_req_count = 0 THEN

Line 305: gmf_batch_requirements r,

301:
302: CURSOR c_null_vib_rows IS
303: SELECT v.rowid, v.*, mmt.organization_id, l.layer_date
304: FROM gmf_batch_vib_details v,
305: gmf_batch_requirements r,
306: gmf_incoming_material_layers l,
307: mtl_material_transactions mmt
308: -- mtl_transaction_lot_numbers mtln
309: WHERE

Line 711: FROM gmf_batch_requirements r,

707: CURSOR c_null_vib_rows IS
708: --SELECT v.rowid, v.*, t.organization_id, l.layer_date
709: -- VKINDURI Added hint as per bug # 13424903
710: SELECT /*+ LEADING(r) */ v.rowid, v.*, t.organization_id, l.layer_date
711: FROM gmf_batch_requirements r,
712: gmf_batch_vib_details v,
713: gmf_incoming_material_layers l,
714: mtl_material_transactions t
715: WHERE

Line 1128: FROM gmf_batch_requirements br, gme_batch_header h

1124: DELETE
1125: FROM gmf_batch_vib_details bvd
1126: WHERE bvd.requirement_id IN
1127: (SELECT br.requirement_id
1128: FROM gmf_batch_requirements br, gme_batch_header h
1129: WHERE h.batch_id = p_batch_id
1130: AND h.batch_id = br.batch_id
1131: );
1132:

Line 1134: FROM gmf_batch_requirements br

1130: AND h.batch_id = br.batch_id
1131: );
1132:
1133: DELETE
1134: FROM gmf_batch_requirements br
1135: WHERE br.batch_id IN
1136: (SELECT batch_id
1137: FROM gme_batch_header
1138: WHERE batch_id = p_batch_id

Line 1334: FROM gmf_batch_requirements br

1330:
1331: IF (l_count = 0) THEN
1332:
1333: DELETE
1334: FROM gmf_batch_requirements br
1335: WHERE br.batch_id IN
1336: (SELECT batch_id
1337: FROM gme_batch_header
1338: WHERE batch_id = p_batch_id

Line 2620: FROM gmf_batch_requirements br, gme_batch_header h

2616: SELECT count(*) INTO l_count
2617: FROM gmf_batch_vib_details bvd
2618: WHERE bvd.requirement_id IN
2619: (SELECT br.requirement_id
2620: FROM gmf_batch_requirements br, gme_batch_header h
2621: WHERE h.batch_id = rec.batch_id
2622: AND h.batch_id = br.batch_id
2623: );
2624: fnd_file.put_line(fnd_file.log, ' Batch Vib details count = '|| l_count);

Line 2626: FROM gmf_batch_requirements br

2622: AND h.batch_id = br.batch_id
2623: );
2624: fnd_file.put_line(fnd_file.log, ' Batch Vib details count = '|| l_count);
2625: SELECT count(*) INTO l_count
2626: FROM gmf_batch_requirements br
2627: WHERE br.batch_id IN
2628: (SELECT batch_id
2629: FROM gme_batch_header
2630: WHERE batch_id = rec.batch_id