APPS.GMF_VIB dependencies on GMF_OUTGOING_MATERIAL_LAYERS

Line 1029: gmf_outgoing_material_layers ol,

1025: decode (tp.transaction_id2, NULL, 'N', 'Y') c_rev_layer,
1026: decode (tp.transaction_id2, NULL, ol.ROWID, ol2.ROWID) c_rowid
1027: FROM gmf_batch_vib_details v,
1028: gmf_incoming_material_layers il,
1029: gmf_outgoing_material_layers ol,
1030: mtl_material_transactions t,
1031: gme_transaction_pairs tp,
1032: gmf_outgoing_material_layers ol2,
1033: mtl_material_transactions t2

Line 1032: gmf_outgoing_material_layers ol2,

1028: gmf_incoming_material_layers il,
1029: gmf_outgoing_material_layers ol,
1030: mtl_material_transactions t,
1031: gme_transaction_pairs tp,
1032: gmf_outgoing_material_layers ol2,
1033: mtl_material_transactions t2
1034: WHERE
1035: il.mmt_transaction_id = p_tran_rec.reverse_id AND -- incoming layer of reversed prod yield
1036: -- Bug 6312166. il.mmt_transaction_id = p_tran_rec.transaction_id AND -- incoming layer of reversed prod yield

Line 1082: FROM gmf_outgoing_material_layers l,

1078:
1079: CURSOR c_ing_layers (p_ing_material_detail_id NUMBER) IS
1080: SELECT mmt.inventory_item_id, mmt.organization_id, /* mtln.lot_number, */ mmt.primary_quantity, msi.primary_uom_code,
1081: mmt.transaction_date, md.line_type, tp.transaction_id2 as reverse_id, l.ROWID, l.*
1082: FROM gmf_outgoing_material_layers l,
1083: mtl_material_transactions mmt,
1084: mtl_system_items_b msi,
1085: gme_material_details md,
1086: gme_transaction_pairs tp

Line 1103: FROM gmf_outgoing_material_layers l,

1099: ORDER BY mmt.transaction_date;
1100:
1101: CURSOR c_ing_layers_cnt (p_ing_material_detail_id NUMBER) IS -- Bug 8472152 Added cursor
1102: SELECT count(*)
1103: FROM gmf_outgoing_material_layers l,
1104: mtl_material_transactions mmt,
1105: mtl_system_items_b msi,
1106: gme_material_details md,
1107: gme_transaction_pairs tp

Line 1266: UPDATE gmf_outgoing_material_layers

1262: sysdate,
1263: p_tran_rec.last_update_login,
1264: v.requirement_id);
1265:
1266: UPDATE gmf_outgoing_material_layers
1267: SET remaining_ib_doc_qty = remaining_ib_doc_qty + v.consume_ib_doc_qty
1268: WHERE
1269: ROWID = v.c_rowid;
1270:

Line 1457: FROM gmf_outgoing_material_layers ol,

1453: IF ing.reverse_id IS NOT NULL
1454: THEN
1455: SELECT nvl(sum (consume_ib_doc_qty), 0)
1456: INTO l_orig_layer_consumption_qty
1457: FROM gmf_outgoing_material_layers ol,
1458: gmf_batch_vib_details v,
1459: gmf_batch_requirements r
1460: WHERE
1461: ol.mmt_transaction_id = ing.reverse_id AND

Line 1538: UPDATE gmf_outgoing_material_layers

1534: sysdate,
1535: p_tran_rec.last_update_login,
1536: req.requirement_id);
1537:
1538: UPDATE gmf_outgoing_material_layers
1539: SET remaining_ib_doc_qty = l_remaining_ib_doc_qty
1540: WHERE
1541: ROWID = ing.ROWID;
1542: EXCEPTION

Line 1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,

1905: CURSOR c_remaining_ing_layers (p_ing_material_detail_id NUMBER) IS
1906: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.inventory_item_id, t.transaction_date,
1907: NULL lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1908: l.layer_doc_qty
1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1910: gme_material_details md,
1911: mtl_system_items_b msi, gme_transaction_pairs tp
1912: WHERE
1913: t.trx_source_line_id = p_ing_material_detail_id AND

Line 2206: FROM gmf_outgoing_material_layers ol,

2202: IF ing.reverse_id IS NOT NULL
2203: THEN
2204: SELECT nvl(sum (consume_ib_doc_qty), 0)
2205: INTO l_orig_layer_consumption_qty
2206: FROM gmf_outgoing_material_layers ol,
2207: gmf_batch_vib_details v,
2208: gmf_incoming_material_layers il,
2209: mtl_material_transactions mmt
2210: WHERE

Line 2547: UPDATE gmf_outgoing_material_layers

2543: SET remaining_ib_doc_qty = remaining_ib_doc_qty - c.consume_ib_doc_qty
2544: WHERE
2545: layer_id = c.consume_layer_id;
2546: ELSE
2547: UPDATE gmf_outgoing_material_layers
2548: SET remaining_ib_doc_qty = remaining_ib_doc_qty - c.consume_ib_doc_qty
2549: WHERE
2550: layer_id = c.consume_layer_id;
2551: END IF;

Line 2810: UPDATE gmf_outgoing_material_layers

2806: SET remaining_ib_doc_qty = remaining_ib_doc_qty + f.consume_ib_doc_qty
2807: WHERE
2808: layer_id = f.consume_layer_id;
2809: ELSE
2810: UPDATE gmf_outgoing_material_layers
2811: SET remaining_ib_doc_qty = remaining_ib_doc_qty + f.consume_ib_doc_qty
2812: WHERE
2813: layer_id = f.consume_layer_id;
2814: END IF;