APPS.GMF_VIB dependencies on GMF_RESOURCE_LAYERS

Line 1063: gmf_resource_layers ol,

1059: decode (t.reverse_id, NULL, 'N', 'Y') c_rev_layer,
1060: decode (t.reverse_id, NULL, ol.ROWID, ol2.ROWID) c_rowid
1061: FROM gmf_batch_vib_details v,
1062: gmf_incoming_material_layers il,
1063: gmf_resource_layers ol,
1064: gme_resource_txns t,
1065: gmf_resource_layers ol2,
1066: gme_resource_txns t2
1067: WHERE

Line 1065: gmf_resource_layers ol2,

1061: FROM gmf_batch_vib_details v,
1062: gmf_incoming_material_layers il,
1063: gmf_resource_layers ol,
1064: gme_resource_txns t,
1065: gmf_resource_layers ol2,
1066: gme_resource_txns t2
1067: WHERE
1068: il.mmt_transaction_id = p_tran_rec.reverse_id AND
1069: nvl(il.lot_number, '@@@') = nvl(p_tran_rec.lot_number, '@@@') AND

Line 1125: FROM gmf_resource_layers l, gme_resource_txns p

1121:
1122:
1123: CURSOR c_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1124: 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.*
1125: FROM gmf_resource_layers l, gme_resource_txns p
1126: WHERE
1127: p.doc_type = 'PROD' AND
1128: p.doc_id = p_tran_rec.transaction_source_id AND
1129: p.line_id = p_batchstep_resource_id AND

Line 1343: UPDATE gmf_resource_layers

1339: sysdate,
1340: p_tran_rec.last_update_login,
1341: v.requirement_id);
1342:
1343: UPDATE gmf_resource_layers
1344: SET remaining_ib_doc_qty = remaining_ib_doc_qty + v.consume_ib_doc_qty
1345: WHERE
1346: ROWID = v.c_rowid;
1347:

Line 1608: FROM gmf_resource_layers rl,

1604: IF rsrc.reverse_id IS NOT NULL
1605: THEN
1606: SELECT nvl(sum (consume_ib_doc_qty), 0)
1607: INTO l_orig_layer_consumption_qty
1608: FROM gmf_resource_layers rl,
1609: gmf_batch_vib_details v,
1610: gmf_batch_requirements r
1611: WHERE
1612: rl.poc_trans_id = rsrc.reverse_id AND

Line 1700: UPDATE gmf_resource_layers

1696: sysdate,
1697: p_tran_rec.last_update_login,
1698: req.requirement_id );
1699:
1700: UPDATE gmf_resource_layers
1701: SET remaining_ib_doc_qty = l_remaining_ib_doc_qty
1702: WHERE
1703: ROWID = rsrc.ROWID;
1704: EXCEPTION

Line 1930: FROM gmf_resource_layers l,

1926:
1927: CURSOR c_remaining_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1928: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.line_type, t.trans_date,
1929: t.resource_usage, t.trans_qty_um trans_um, l.ROWID, t.reverse_id, l.layer_doc_qty
1930: FROM gmf_resource_layers l,
1931: gme_resource_txns t
1932: WHERE
1933: t.doc_type = 'PROD' AND
1934: t.doc_id = p_batch_id AND

Line 2398: FROM gmf_resource_layers rl,

2394: IF rsrc.reverse_id IS NOT NULL
2395: THEN
2396: SELECT nvl(sum (consume_ib_doc_qty), 0)
2397: INTO l_orig_layer_consumption_qty
2398: FROM gmf_resource_layers rl,
2399: gmf_batch_vib_details v,
2400: gmf_incoming_material_layers il,
2401: mtl_material_transactions mmt
2402: WHERE

Line 2542: UPDATE gmf_resource_layers

2538:
2539: FOR c IN c_finalize_layer_consumption LOOP
2540: BEGIN
2541: IF c.line_type = 0 THEN
2542: UPDATE gmf_resource_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

Line 2805: UPDATE gmf_resource_layers

2801: FOR f IN c_finalize_rows LOOP
2802: BEGIN
2803: -- Update the layers material, resource remaining_doc_qty
2804: IF f.line_type = 0 THEN
2805: UPDATE gmf_resource_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