eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_VIB dependencies on GMF_BATCH_VIB_DETAILS

Line 1012: FROM gmf_batch_vib_details v,

1008: decode (tp.transaction_id2, NULL, ol.remaining_ib_doc_qty, ol2.remaining_ib_doc_qty) remaining_ib_doc_qty,
1009: decode (tp.transaction_id2, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
1010: decode (tp.transaction_id2, NULL, 'N', 'Y') c_rev_layer,
1011: decode (tp.transaction_id2, NULL, ol.ROWID, ol2.ROWID) c_rowid
1012: FROM gmf_batch_vib_details v,
1013: gmf_incoming_material_layers il,
1014: gmf_outgoing_material_layers ol,
1015: mtl_material_transactions t,
1016: gme_transaction_pairs tp,

Line 1046: FROM gmf_batch_vib_details v,

1042: decode (t.reverse_id, NULL, ol.remaining_ib_doc_qty, ol2.remaining_ib_doc_qty) remaining_ib_doc_qty,
1043: decode (t.reverse_id, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
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,

Line 1135: FROM gmf_batch_vib_details

1131:
1132: -- Validate that the VIB details do not exist already
1133: SELECT count(*)
1134: INTO l_count
1135: FROM gmf_batch_vib_details
1136: WHERE
1137: prod_layer_id = p_layer_rec.layer_id;
1138:
1139: IF l_count > 0 THEN

Line 1177: FROM gmf_batch_vib_details vib,

1173: THEN
1174:
1175: SELECT count (1)
1176: INTO l_count
1177: FROM gmf_batch_vib_details vib,
1178: gmf_batch_requirements r
1179: WHERE
1180: r.batch_id = p_tran_rec.transaction_source_id AND
1181: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1196: INSERT INTO gmf_batch_vib_details(

1192: END IF;
1193: END IF;
1194:
1195: -- Insert VIB reversals
1196: INSERT INTO gmf_batch_vib_details(
1197: prod_layer_id,
1198: prod_layer_pri_qty,
1199: consume_layer_id,
1200: consume_layer_date,

Line 1254: FROM gmf_batch_vib_details vib,

1250: THEN
1251:
1252: SELECT count (1)
1253: INTO l_count
1254: FROM gmf_batch_vib_details vib,
1255: gmf_batch_requirements r
1256: WHERE
1257: r.batch_id = p_tran_rec.transaction_source_id AND
1258: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1273: INSERT INTO gmf_batch_vib_details(

1269: END IF;
1270: END IF;
1271:
1272: -- Insert VIB reversals
1273: INSERT INTO gmf_batch_vib_details(
1274: prod_layer_id,
1275: prod_layer_pri_qty,
1276: consume_layer_id,
1277: consume_layer_date,

Line 1379: FROM gmf_batch_vib_details v,

1375: -- If the entire quantity is remaining, no need to check.
1376: IF ing.layer_doc_qty <> ing.remaining_ib_doc_qty THEN
1377: SELECT nvl(sum (consume_ib_doc_qty), 0)
1378: INTO l_prev_consume_ib_doc_qty
1379: FROM gmf_batch_vib_details v,
1380: gmf_batch_requirements r
1381: WHERE
1382: r.batch_id = p_tran_rec.transaction_source_id AND
1383: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1398: gmf_batch_vib_details v,

1394: THEN
1395: SELECT nvl(sum (consume_ib_doc_qty), 0)
1396: INTO l_orig_layer_consumption_qty
1397: FROM gmf_outgoing_material_layers ol,
1398: gmf_batch_vib_details v,
1399: gmf_batch_requirements r
1400: WHERE
1401: ol.mmt_transaction_id = ing.reverse_id AND
1402: v.consume_layer_id = ol.layer_id AND

Line 1445: INSERT INTO gmf_batch_vib_details(

1441: , FROM_NAME => NULL
1442: , TO_NAME => NULL
1443: );
1444:
1445: INSERT INTO gmf_batch_vib_details(
1446: prod_layer_id,
1447: prod_layer_pri_qty,
1448: consume_layer_id,
1449: consume_layer_date,

Line 1530: FROM gmf_batch_vib_details v,

1526: -- If the entire quantity is remaining, no need to check.
1527: IF rsrc.layer_doc_qty <> rsrc.remaining_ib_doc_qty THEN
1528: SELECT nvl(sum (consume_ib_doc_qty), 0)
1529: INTO l_prev_consume_ib_doc_qty
1530: FROM gmf_batch_vib_details v,
1531: gmf_batch_requirements r
1532: WHERE
1533: r.batch_id = p_tran_rec.transaction_source_id AND
1534: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1549: gmf_batch_vib_details v,

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
1553: v.consume_layer_id = rl.layer_id AND

Line 1607: INSERT INTO gmf_batch_vib_details(

1603: , TO_NAME => NULL
1604: );
1605:
1606:
1607: INSERT INTO gmf_batch_vib_details(
1608: prod_layer_id,
1609: prod_layer_pri_qty,
1610: consume_layer_id,
1611: consume_layer_date,

Line 1709: INSERT INTO gmf_batch_vib_details(

1705:
1706:
1707: END IF;
1708:
1709: INSERT INTO gmf_batch_vib_details(
1710: prod_layer_id,
1711: prod_layer_pri_qty,
1712: consume_layer_id,
1713: consume_layer_date,

Line 1814: FROM gmf_batch_vib_details v,

1810: ORDER BY prod_material_detail_id;
1811:
1812: CURSOR c_null_consume_layers IS
1813: SELECT v.*, l.layer_doc_qty, l.layer_doc_um, l.mmt_transaction_id, l.lot_number, l.mmt_organization_id
1814: FROM gmf_batch_vib_details v,
1815: gmf_batch_requirements r,
1816: gmf_incoming_material_layers l
1817: WHERE
1818: r.batch_id = p_batch_id AND

Line 1880: gmf_batch_vib_details v,

1876:
1877: CURSOR c_finalize_layer_consumption IS
1878: SELECT v.consume_layer_id, v.line_type, sum(v.consume_ib_doc_qty) consume_ib_doc_qty
1879: FROM
1880: gmf_batch_vib_details v,
1881: gmf_batch_requirements r
1882: WHERE
1883: r.batch_id = p_batch_id AND
1884: v.requirement_id = r.requirement_id AND

Line 1944: FROM gmf_batch_vib_details v,

1940: -- Check if he VIB details already exist for this batch
1941: BEGIN
1942: SELECT count(*)
1943: INTO l_count
1944: FROM gmf_batch_vib_details v,
1945: gmf_batch_requirements r
1946: WHERE
1947: r.batch_id = p_batch_id AND
1948: r.requirement_id = v.requirement_id and

Line 2029: INSERT INTO gmf_batch_vib_details(

2025: NULL,
2026: 'N');
2027:
2028: -- Create a VIB layer for the pseudo product layer reversing the original VIB row
2029: INSERT INTO gmf_batch_vib_details(
2030: prod_layer_id,
2031: prod_layer_pri_qty,
2032: consume_layer_id,
2033: consume_layer_date,

Line 2111: FROM gmf_batch_vib_details v,

2107: IF l_use_vib = 'N'
2108: THEN
2109: SELECT nvl(sum (consume_ib_doc_qty), 0)
2110: INTO l_prev_consume_ib_doc_qty
2111: FROM gmf_batch_vib_details v,
2112: gmf_incoming_material_layers il,
2113: mtl_material_transactions mmt
2114: WHERE
2115: v.requirement_id = req.requirement_id AND

Line 2144: gmf_batch_vib_details v,

2140: THEN
2141: SELECT nvl(sum (consume_ib_doc_qty), 0)
2142: INTO l_orig_layer_consumption_qty
2143: FROM gmf_outgoing_material_layers ol,
2144: gmf_batch_vib_details v,
2145: gmf_incoming_material_layers il,
2146: mtl_material_transactions mmt
2147: WHERE
2148: ol.mmt_transaction_id = ing.reverse_id AND

Line 2239: INSERT INTO gmf_batch_vib_details(

2235:
2236:
2237: l_remaining_ib_doc_qty := ing.remaining_ib_doc_qty - l_consume_ib_doc_qty;
2238:
2239: INSERT INTO gmf_batch_vib_details(
2240: prod_layer_id,
2241: prod_layer_pri_qty,
2242: consume_layer_id,
2243: consume_layer_date,

Line 2304: FROM gmf_batch_vib_details v,

2300: IF l_use_vib = 'N'
2301: THEN
2302: SELECT nvl(sum (consume_ib_doc_qty), 0)
2303: INTO l_prev_consume_ib_doc_qty
2304: FROM gmf_batch_vib_details v,
2305: gmf_incoming_material_layers il,
2306: mtl_material_transactions mmt
2307: WHERE
2308: v.requirement_id = req.requirement_id AND

Line 2336: gmf_batch_vib_details v,

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
2340: rl.poc_trans_id = rsrc.reverse_id AND

Line 2426: INSERT INTO gmf_batch_vib_details(

2422: );
2423:
2424:
2425: l_remaining_ib_doc_qty := rsrc.remaining_ib_doc_qty - l_consume_ib_doc_qty;
2426: INSERT INTO gmf_batch_vib_details(
2427: prod_layer_id,
2428: prod_layer_pri_qty,
2429: consume_layer_id,
2430: consume_layer_date,

Line 2540: FROM gmf_batch_vib_details v, gmf_batch_requirements r

2536: x_msg_data OUT NOCOPY VARCHAR2) IS
2537:
2538: CURSOR c_finalize_rows IS
2539: SELECT v.ROWID, v.consume_ib_doc_qty, v.consume_layer_id, v.line_type
2540: FROM gmf_batch_vib_details v, gmf_batch_requirements r
2541: WHERE
2542: r.batch_id = p_batch_id and
2543: r.requirement_id = v.requirement_id and
2544: v.finalize_ind = 1 and

Line 2580: -- gmf_batch_vib_details with finalize_ind = 1

2576: RAISE;
2577: END;
2578:
2579: -- Delete all rows from gmf_incoming_material_layers which are used in
2580: -- gmf_batch_vib_details with finalize_ind = 1
2581: IF g_debug <= gme_debug.g_log_statement THEN
2582: gme_debug.put_line ('deleting pseudo layers...');
2583: END IF;
2584:

Line 2590: FROM gmf_batch_vib_details v,

2586: WHERE
2587: pseudo_layer_id IS NOT NULL AND
2588: layer_id in (
2589: SELECT prod_layer_id
2590: FROM gmf_batch_vib_details v,
2591: gmf_batch_requirements r
2592: WHERE
2593: r.batch_id = p_batch_id AND
2594: r.requirement_id = v.requirement_id AND

Line 2602: -- Delete all rows from the gmf_batch_vib_details with finalize_ind = 1

2598: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');
2599: END IF;
2600:
2601:
2602: -- Delete all rows from the gmf_batch_vib_details with finalize_ind = 1
2603: -- and the comsume_layer_id is NULL.
2604: IF g_debug <= gme_debug.g_log_statement THEN
2605: gme_debug.put_line ('now deleting NULL finalized consumption layers');
2606: END IF;

Line 2608: DELETE from gmf_batch_vib_details

2604: IF g_debug <= gme_debug.g_log_statement THEN
2605: gme_debug.put_line ('now deleting NULL finalized consumption layers');
2606: END IF;
2607:
2608: DELETE from gmf_batch_vib_details
2609: WHERE
2610: finalize_ind = 1 and
2611: consume_layer_id IS NULL and
2612: requirement_id in (

Line 2642: DELETE from gmf_batch_vib_details

2638: layer_id = f.consume_layer_id;
2639: END IF;
2640:
2641: -- Delete the row from the gmf_batch_vib_detail table.
2642: DELETE from gmf_batch_vib_details
2643: WHERE
2644: ROWID = f.ROWID;
2645:
2646: END;