APPS.GMF_VIB dependencies on GMF_RESOURCE_LAYERS

Line 1048: gmf_resource_layers ol,

1044: decode (t.reverse_id, NULL, 'N', 'Y') c_rev_layer,
1045: decode (t.reverse_id, NULL, ol.ROWID, ol2.ROWID) c_rowid
1046: FROM gmf_batch_vib_details v,
1047: gmf_incoming_material_layers il,
1048: gmf_resource_layers ol,
1049: gme_resource_txns t,
1050: gmf_resource_layers ol2,
1051: gme_resource_txns t2
1052: WHERE

Line 1050: gmf_resource_layers ol2,

1046: FROM gmf_batch_vib_details v,
1047: gmf_incoming_material_layers il,
1048: gmf_resource_layers ol,
1049: gme_resource_txns t,
1050: gmf_resource_layers ol2,
1051: gme_resource_txns t2
1052: WHERE
1053: il.mmt_transaction_id = p_tran_rec.reverse_id AND
1054: nvl(il.lot_number, '@@@') = nvl(p_tran_rec.lot_number, '@@@') AND

Line 1091: FROM gmf_resource_layers l, gme_resource_txns p

1087:
1088:
1089: CURSOR c_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1090: SELECT p.resource_usage, p.trans_qty_um as trans_um, p.trans_date, p.line_type, p.reverse_id, p.organization_id, l.ROWID, l.*
1091: FROM gmf_resource_layers l, gme_resource_txns p
1092: WHERE
1093: p.doc_type = 'PROD' AND
1094: p.doc_id = p_tran_rec.transaction_source_id AND
1095: p.line_id = p_batchstep_resource_id AND

Line 1306: UPDATE gmf_resource_layers

1302: sysdate,
1303: p_tran_rec.last_update_login,
1304: v.requirement_id);
1305:
1306: UPDATE gmf_resource_layers
1307: SET remaining_ib_doc_qty = remaining_ib_doc_qty + v.consume_ib_doc_qty
1308: WHERE
1309: ROWID = v.c_rowid;
1310:

Line 1548: FROM gmf_resource_layers rl,

1544: IF rsrc.reverse_id IS NOT NULL
1545: THEN
1546: SELECT nvl(sum (consume_ib_doc_qty), 0)
1547: INTO l_orig_layer_consumption_qty
1548: FROM gmf_resource_layers rl,
1549: gmf_batch_vib_details v,
1550: gmf_batch_requirements r
1551: WHERE
1552: rl.poc_trans_id = rsrc.reverse_id AND

Line 1640: UPDATE gmf_resource_layers

1636: sysdate,
1637: p_tran_rec.last_update_login,
1638: req.requirement_id );
1639:
1640: UPDATE gmf_resource_layers
1641: SET remaining_ib_doc_qty = l_remaining_ib_doc_qty
1642: WHERE
1643: ROWID = rsrc.ROWID;
1644: EXCEPTION

Line 1869: FROM gmf_resource_layers l,

1865:
1866: CURSOR c_remaining_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1867: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.line_type, t.trans_date,
1868: t.resource_usage, t.trans_qty_um trans_um, l.ROWID, t.reverse_id, l.layer_doc_qty
1869: FROM gmf_resource_layers l,
1870: gme_resource_txns t
1871: WHERE
1872: l.poc_trans_id = t.poc_trans_id AND
1873: t.line_id = p_batchstep_resource_id AND

Line 2335: FROM gmf_resource_layers rl,

2331: IF rsrc.reverse_id IS NOT NULL
2332: THEN
2333: SELECT nvl(sum (consume_ib_doc_qty), 0)
2334: INTO l_orig_layer_consumption_qty
2335: FROM gmf_resource_layers rl,
2336: gmf_batch_vib_details v,
2337: gmf_incoming_material_layers il,
2338: mtl_material_transactions mmt
2339: WHERE

Line 2479: UPDATE gmf_resource_layers

2475:
2476: FOR c IN c_finalize_layer_consumption LOOP
2477: BEGIN
2478: IF c.line_type = 0 THEN
2479: UPDATE gmf_resource_layers
2480: SET remaining_ib_doc_qty = remaining_ib_doc_qty - c.consume_ib_doc_qty
2481: WHERE
2482: layer_id = c.consume_layer_id;
2483: ELSE

Line 2630: UPDATE gmf_resource_layers

2626: FOR f IN c_finalize_rows LOOP
2627: BEGIN
2628: -- Update the layers material, resource remaining_doc_qty
2629: IF f.line_type = 0 THEN
2630: UPDATE gmf_resource_layers
2631: SET remaining_ib_doc_qty = remaining_ib_doc_qty + f.consume_ib_doc_qty
2632: WHERE
2633: layer_id = f.consume_layer_id;
2634: ELSE