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 1027: FROM gmf_batch_vib_details v,

1023: decode (tp.transaction_id2, NULL, ol.remaining_ib_doc_qty, ol2.remaining_ib_doc_qty) remaining_ib_doc_qty,
1024: decode (tp.transaction_id2, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
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,

Line 1061: FROM gmf_batch_vib_details v,

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

Line 1172: FROM gmf_batch_vib_details

1168:
1169: -- Validate that the VIB details do not exist already
1170: SELECT count(*)
1171: INTO l_count
1172: FROM gmf_batch_vib_details
1173: WHERE
1174: prod_layer_id = p_layer_rec.layer_id;
1175:
1176: IF l_count > 0 THEN

Line 1214: FROM gmf_batch_vib_details vib,

1210: THEN
1211:
1212: SELECT count (1)
1213: INTO l_count
1214: FROM gmf_batch_vib_details vib,
1215: gmf_batch_requirements r
1216: WHERE
1217: r.batch_id = p_tran_rec.transaction_source_id AND
1218: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1233: INSERT INTO gmf_batch_vib_details(

1229: END IF;
1230: END IF;
1231:
1232: -- Insert VIB reversals
1233: INSERT INTO gmf_batch_vib_details(
1234: prod_layer_id,
1235: prod_layer_pri_qty,
1236: consume_layer_id,
1237: consume_layer_date,

Line 1291: FROM gmf_batch_vib_details vib,

1287: THEN
1288:
1289: SELECT count (1)
1290: INTO l_count
1291: FROM gmf_batch_vib_details vib,
1292: gmf_batch_requirements r
1293: WHERE
1294: r.batch_id = p_tran_rec.transaction_source_id AND
1295: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1310: INSERT INTO gmf_batch_vib_details(

1306: END IF;
1307: END IF;
1308:
1309: -- Insert VIB reversals
1310: INSERT INTO gmf_batch_vib_details(
1311: prod_layer_id,
1312: prod_layer_pri_qty,
1313: consume_layer_id,
1314: consume_layer_date,

Line 1439: FROM gmf_batch_vib_details v,

1435: -- If the entire quantity is remaining, no need to check.
1436: IF ing.layer_doc_qty <> ing.remaining_ib_doc_qty THEN
1437: SELECT nvl(sum (consume_ib_doc_qty), 0)
1438: INTO l_prev_consume_ib_doc_qty
1439: FROM gmf_batch_vib_details v,
1440: gmf_batch_requirements r
1441: WHERE
1442: r.batch_id = p_tran_rec.transaction_source_id AND
1443: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1458: gmf_batch_vib_details v,

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
1462: v.consume_layer_id = ol.layer_id AND

Line 1505: INSERT INTO gmf_batch_vib_details(

1501: , FROM_NAME => NULL
1502: , TO_NAME => NULL
1503: );
1504:
1505: INSERT INTO gmf_batch_vib_details(
1506: prod_layer_id,
1507: prod_layer_pri_qty,
1508: consume_layer_id,
1509: consume_layer_date,

Line 1590: FROM gmf_batch_vib_details v,

1586: -- If the entire quantity is remaining, no need to check.
1587: IF rsrc.layer_doc_qty <> rsrc.remaining_ib_doc_qty THEN
1588: SELECT nvl(sum (consume_ib_doc_qty), 0)
1589: INTO l_prev_consume_ib_doc_qty
1590: FROM gmf_batch_vib_details v,
1591: gmf_batch_requirements r
1592: WHERE
1593: r.batch_id = p_tran_rec.transaction_source_id AND
1594: r.prod_material_detail_id = p_tran_rec.trx_source_line_id AND

Line 1609: gmf_batch_vib_details v,

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

Line 1667: INSERT INTO gmf_batch_vib_details(

1663: , TO_NAME => NULL
1664: );
1665:
1666:
1667: INSERT INTO gmf_batch_vib_details(
1668: prod_layer_id,
1669: prod_layer_pri_qty,
1670: consume_layer_id,
1671: consume_layer_date,

Line 1769: INSERT INTO gmf_batch_vib_details(

1765:
1766:
1767: END IF;
1768:
1769: INSERT INTO gmf_batch_vib_details(
1770: prod_layer_id,
1771: prod_layer_pri_qty,
1772: consume_layer_id,
1773: consume_layer_date,

Line 1874: FROM gmf_batch_vib_details v,

1870: ORDER BY prod_material_detail_id;
1871:
1872: CURSOR c_null_consume_layers IS
1873: SELECT v.*, l.layer_doc_qty, l.layer_doc_um, l.mmt_transaction_id, l.lot_number, l.mmt_organization_id
1874: FROM gmf_batch_vib_details v,
1875: gmf_batch_requirements r,
1876: gmf_incoming_material_layers l
1877: WHERE
1878: r.batch_id = p_batch_id AND

Line 1943: gmf_batch_vib_details v,

1939:
1940: CURSOR c_finalize_layer_consumption IS
1941: SELECT v.consume_layer_id, v.line_type, sum(v.consume_ib_doc_qty) consume_ib_doc_qty
1942: FROM
1943: gmf_batch_vib_details v,
1944: gmf_batch_requirements r
1945: WHERE
1946: r.batch_id = p_batch_id AND
1947: v.requirement_id = r.requirement_id AND

Line 2007: FROM gmf_batch_vib_details v,

2003: -- Check if he VIB details already exist for this batch
2004: BEGIN
2005: SELECT count(*)
2006: INTO l_count
2007: FROM gmf_batch_vib_details v,
2008: gmf_batch_requirements r
2009: WHERE
2010: r.batch_id = p_batch_id AND
2011: r.requirement_id = v.requirement_id and

Line 2092: INSERT INTO gmf_batch_vib_details(

2088: NULL,
2089: 'N');
2090:
2091: -- Create a VIB layer for the pseudo product layer reversing the original VIB row
2092: INSERT INTO gmf_batch_vib_details(
2093: prod_layer_id,
2094: prod_layer_pri_qty,
2095: consume_layer_id,
2096: consume_layer_date,

Line 2174: FROM gmf_batch_vib_details v,

2170: IF l_use_vib = 'N'
2171: THEN
2172: SELECT nvl(sum (consume_ib_doc_qty), 0)
2173: INTO l_prev_consume_ib_doc_qty
2174: FROM gmf_batch_vib_details v,
2175: gmf_incoming_material_layers il,
2176: mtl_material_transactions mmt
2177: WHERE
2178: v.requirement_id = req.requirement_id AND

Line 2207: gmf_batch_vib_details v,

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
2211: ol.mmt_transaction_id = ing.reverse_id AND

Line 2302: INSERT INTO gmf_batch_vib_details(

2298:
2299:
2300: l_remaining_ib_doc_qty := ing.remaining_ib_doc_qty - l_consume_ib_doc_qty;
2301:
2302: INSERT INTO gmf_batch_vib_details(
2303: prod_layer_id,
2304: prod_layer_pri_qty,
2305: consume_layer_id,
2306: consume_layer_date,

Line 2367: FROM gmf_batch_vib_details v,

2363: IF l_use_vib = 'N'
2364: THEN
2365: SELECT nvl(sum (consume_ib_doc_qty), 0)
2366: INTO l_prev_consume_ib_doc_qty
2367: FROM gmf_batch_vib_details v,
2368: gmf_incoming_material_layers il,
2369: mtl_material_transactions mmt
2370: WHERE
2371: v.requirement_id = req.requirement_id AND

Line 2399: gmf_batch_vib_details v,

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

Line 2489: INSERT INTO gmf_batch_vib_details(

2485: );
2486:
2487:
2488: l_remaining_ib_doc_qty := rsrc.remaining_ib_doc_qty - l_consume_ib_doc_qty;
2489: INSERT INTO gmf_batch_vib_details(
2490: prod_layer_id,
2491: prod_layer_pri_qty,
2492: consume_layer_id,
2493: consume_layer_date,

Line 2607: FROM gmf_batch_vib_details v, gmf_batch_requirements r

2603: x_msg_data OUT NOCOPY VARCHAR2) IS
2604:
2605: CURSOR c_finalize_rows IS
2606: SELECT v.ROWID, v.consume_ib_doc_qty, v.consume_layer_id, v.line_type
2607: FROM gmf_batch_vib_details v, gmf_batch_requirements r
2608: WHERE
2609: r.batch_id = p_batch_id and
2610: r.requirement_id = v.requirement_id and
2611: v.finalize_ind = 1 and

Line 2663: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2659:
2660: IF (l_posted_count >= 1) THEN
2661:
2662: GMF_LAYERS.log_message (
2663: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2664: p_procedure_name => 'Revert_Finalization',
2665: p_parameters => p_batch_id,
2666: p_message => l_posted_count||' Posted events exist. Batch Can not be Reopened.',
2667: p_error_type => 'E');

Line 2719: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2715: gme_debug.put_line ('deleting batch close events extract lines ');
2716: END IF;
2717:
2718: GMF_LAYERS.log_message (
2719: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2720: p_procedure_name => 'Revert_Finalization',
2721: p_parameters => p_batch_id,
2722: p_message => ' Deleting event and extract data for Batch Close Event '||l_event.event_id,
2723: p_error_type => 'E');

Line 2755: -- gmf_batch_vib_details with finalize_ind = 1

2751: END IF;
2752:
2753: -- End Bug 11839588
2754: -- Delete all rows from gmf_incoming_material_layers which are used in
2755: -- gmf_batch_vib_details with finalize_ind = 1
2756: IF g_debug <= gme_debug.g_log_statement THEN
2757: gme_debug.put_line ('deleting pseudo layers...');
2758: END IF;
2759:

Line 2765: FROM gmf_batch_vib_details v,

2761: WHERE
2762: pseudo_layer_id IS NOT NULL AND
2763: layer_id in (
2764: SELECT prod_layer_id
2765: FROM gmf_batch_vib_details v,
2766: gmf_batch_requirements r
2767: WHERE
2768: r.batch_id = p_batch_id AND
2769: r.requirement_id = v.requirement_id AND

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

2773: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');
2774: END IF;
2775:
2776:
2777: -- Delete all rows from the gmf_batch_vib_details with finalize_ind = 1
2778: -- and the comsume_layer_id is NULL.
2779: IF g_debug <= gme_debug.g_log_statement THEN
2780: gme_debug.put_line ('now deleting NULL finalized consumption layers');
2781: END IF;

Line 2783: DELETE from gmf_batch_vib_details

2779: IF g_debug <= gme_debug.g_log_statement THEN
2780: gme_debug.put_line ('now deleting NULL finalized consumption layers');
2781: END IF;
2782:
2783: DELETE from gmf_batch_vib_details
2784: WHERE
2785: finalize_ind = 1 and
2786: consume_layer_id IS NULL and
2787: requirement_id in (

Line 2817: DELETE from gmf_batch_vib_details

2813: layer_id = f.consume_layer_id;
2814: END IF;
2815:
2816: -- Delete the row from the gmf_batch_vib_detail table.
2817: DELETE from gmf_batch_vib_details
2818: WHERE
2819: ROWID = f.ROWID;
2820:
2821: END;