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_LAYERS dependencies on GMF_BATCH_VIB_DETAILS

Line 304: FROM gmf_batch_vib_details v,

300: /* PK Bug 8219507 removed mtln */
301:
302: CURSOR c_null_vib_rows IS
303: SELECT v.rowid, v.*, mmt.organization_id, l.layer_date
304: FROM gmf_batch_vib_details v,
305: gmf_batch_requirements r,
306: gmf_incoming_material_layers l,
307: mtl_material_transactions mmt
308: -- mtl_transaction_lot_numbers mtln

Line 442: gmf_batch_vib_details v

438:
439: SELECT -sum(nvl(consume_ib_doc_qty,0)), l.ROWID
440: INTO l_rev_consume_ib_doc_qty, l_rowid
441: FROM gmf_outgoing_material_layers l,
442: gmf_batch_vib_details v
443: WHERE l.mmt_transaction_id = p_tran_rec.reverse_id and
444: nvl(l.lot_number,'X')= nvl(p_tran_rec.lot_number,'X') and
445: l.layer_id = v.consume_layer_id (+)
446: GROUP BY l.ROWID;

Line 523: UPDATE gmf_batch_vib_details

519: IF g_debug <= gme_debug.g_log_statement THEN
520: gme_debug.put_line ('If ingredient qty is more then what is needed.');
521: END IF;
522:
523: UPDATE gmf_batch_vib_details
524: SET consume_layer_id = l_layer_id,
525: consume_layer_date = p_tran_rec.transaction_date
526: WHERE ROWID = n.rowid;
527:

Line 554: INSERT INTO gmf_batch_vib_details(

550: , FROM_NAME => NULL
551: , TO_NAME => NULL
552: );
553:
554: INSERT INTO gmf_batch_vib_details(
555: prod_layer_id,
556: prod_layer_pri_qty,
557: consume_layer_id,
558: consume_layer_date,

Line 599: UPDATE gmf_batch_vib_details

595: , FROM_NAME => NULL
596: , TO_NAME => NULL
597: );
598:
599: UPDATE gmf_batch_vib_details
600: SET consume_layer_id = l_layer_id,
601: consume_ib_doc_qty = l_remaining_ib_doc_qty,
602: consume_ib_pri_qty = l_consume_ib_pri_qty,
603: consume_layer_date = p_tran_rec.transaction_date

Line 712: gmf_batch_vib_details v,

708: --SELECT v.rowid, v.*, t.organization_id, l.layer_date
709: -- VKINDURI Added hint as per bug # 13424903
710: SELECT /*+ LEADING(r) */ v.rowid, v.*, t.organization_id, l.layer_date
711: FROM gmf_batch_requirements r,
712: gmf_batch_vib_details v,
713: gmf_incoming_material_layers l,
714: mtl_material_transactions t
715: WHERE
716: r.batch_id = p_rsrc_rec.doc_id AND

Line 787: gmf_batch_vib_details v

783:
784: SELECT -sum(nvl(consume_ib_doc_qty,0)), l.ROWID
785: INTO l_rev_consume_ib_doc_qty, l_rowid
786: FROM gmf_resource_layers l,
787: gmf_batch_vib_details v
788: WHERE l.poc_trans_id = p_rsrc_rec.reverse_id and
789: l.layer_id = v.consume_layer_id(+)
790: GROUP BY l.ROWID;
791:

Line 845: UPDATE gmf_batch_vib_details

841:
842: -- If resource usage is more then what is needed.
843: IF n.consume_ib_doc_qty <= l_remaining_ib_doc_qty THEN
844:
845: UPDATE gmf_batch_vib_details
846: SET consume_layer_id = l_layer_id
847: WHERE ROWID = n.rowid;
848:
849: l_remaining_ib_doc_qty := l_remaining_ib_doc_qty - n.consume_ib_doc_qty;

Line 873: INSERT INTO gmf_batch_vib_details(

869: , TO_NAME => NULL
870: );
871:
872:
873: INSERT INTO gmf_batch_vib_details(
874: prod_layer_id,
875: prod_layer_pri_qty,
876: consume_layer_id,
877: consume_layer_date,

Line 919: UPDATE gmf_batch_vib_details

915: , TO_NAME => NULL
916: );
917:
918:
919: UPDATE gmf_batch_vib_details
920: SET consume_layer_id = l_layer_id,
921: consume_ib_pri_qty = l_consume_ib_pri_qty,
922: consume_ib_doc_qty = l_remaining_ib_doc_qty
923: WHERE ROWID = n.rowid;

Line 1125: FROM gmf_batch_vib_details bvd

1121: AND t.doc_type = 'PROD'
1122: );
1123:
1124: DELETE
1125: FROM gmf_batch_vib_details bvd
1126: WHERE bvd.requirement_id IN
1127: (SELECT br.requirement_id
1128: FROM gmf_batch_requirements br, gme_batch_header h
1129: WHERE h.batch_id = p_batch_id

Line 1146: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1142: WHEN OTHERS THEN
1143: err_num := SQLCODE;
1144: err_msg := SUBSTRB(SQLERRM, 1, 100);
1145: GMF_LAYERS.log_message (
1146: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1147: p_procedure_name => 'Delete_old_layers',
1148: p_parameters => err_num,
1149: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' '||err_msg,
1150: p_error_type => 'I');

Line 1202: FROM gmf_batch_vib_details bvd

1198:
1199: -- Cusror selects prior period consumptions for yield in current period
1200: CURSOR CUR_VIB_DETAILS IS
1201: SELECT CONSUME_LAYER_ID, CONSUME_IB_DOC_QTY, CONSUME_IB_PRI_QTY, LINE_TYPE
1202: FROM gmf_batch_vib_details bvd
1203: WHERE bvd.CONSUME_LAYER_DATE < l_start_date
1204: AND bvd.prod_layer_id IN
1205: (SELECT il.layer_id
1206: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il

Line 1277: FROM gmf_batch_vib_details bvd

1273:
1274:
1275: -- Code to add quantities from VIB details ends here
1276: DELETE
1277: FROM gmf_batch_vib_details bvd
1278: WHERE bvd.prod_layer_id IN
1279: (SELECT il.layer_id
1280: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
1281: WHERE h.batch_id = p_batch_id

Line 1348: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1344: WHEN OTHERS THEN
1345: err_num := SQLCODE;
1346: err_msg := SUBSTRB(SQLERRM, 1, 100);
1347: GMF_LAYERS.log_message (
1348: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1349: p_procedure_name => 'Delete_period_layers',
1350: p_parameters => err_num,
1351: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' Period id '||p_period_id||
1352: ' '||err_msg,p_error_type => 'I');

Line 1456: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1452: from gmf_period_statuses
1453: where period_id = p_period_id;
1454:
1455: GMF_LAYERS.log_message (
1456: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1457: p_procedure_name => 'None',
1458: p_parameters => 'None',
1459: p_message => 'Started the migration Recreate_outgoing_layers for the batch',
1460: p_error_type => 'I');

Line 1463: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1459: p_message => 'Started the migration Recreate_outgoing_layers for the batch',
1460: p_error_type => 'I');
1461:
1462: GMF_LAYERS.log_message (
1463: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1464: p_procedure_name => 'None',
1465: p_parameters => 'None',
1466: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),
1467: p_error_type => 'I');

Line 1470: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1466: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),
1467: p_error_type => 'I');
1468:
1469: GMF_LAYERS.log_message (
1470: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1471: p_procedure_name => 'None',
1472: p_parameters => 'None',
1473: p_message => 'Profile GMF_USE_ITEM_STEP_DEPENDENCIES = '||FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES'),
1474: p_error_type => 'I');

Line 1567: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1563: WHEN OTHERS THEN
1564: -- fnd_file.put_line ('Error in UOM conversion');
1565: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
1566: GMF_LAYERS.log_message (
1567: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1568: p_procedure_name => 'None',
1569: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id)||
1570: ' From UOM = '||trans_rec.primary_uom_code||', To UOM = '||t.doc_um,
1571: p_message => 'UOM Conversion error',

Line 1592: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1588: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1589: --
1590: -- fnd_file.put_line ('Error creating outgoing layer : '||to_char (mt.trans_id));
1591: GMF_LAYERS.log_message (
1592: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1593: p_procedure_name => 'None',
1594: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
1595: p_message => 'Error creating outgoing layer',
1596: p_error_type => 'E');

Line 1600: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1596: p_error_type => 'E');
1597: FOR i IN 1..fnd_msg_pub.count_msg
1598: LOOP
1599: GMF_LAYERS.log_message (
1600: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1601: p_procedure_name => 'None',
1602: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
1603: p_message => fnd_msg_pub.get_detail (i, NULL),
1604: p_error_type => 'E');

Line 1619: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1615: END LOOP;
1616:
1617:
1618: GMF_LAYERS.log_message (
1619: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1620: p_procedure_name => 'None',
1621: p_parameters => 'Incoming Layers = '||to_char(l_il_count)||
1622: ', Outgoing Layers = '||to_char(l_ol_count)||
1623: ', Resource Layers = '||to_char(l_rl_count),

Line 1715: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1711: from gmf_period_statuses
1712: where period_id = p_period_id;
1713:
1714: GMF_LAYERS.log_message (
1715: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1716: p_procedure_name => 'None',
1717: p_parameters => 'None',
1718: p_message => 'Started the migration to Recreate_resource_layers for the batch',
1719: p_error_type => 'I');

Line 1722: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1718: p_message => 'Started the migration to Recreate_resource_layers for the batch',
1719: p_error_type => 'I');
1720:
1721: GMF_LAYERS.log_message (
1722: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1723: p_procedure_name => 'None',
1724: p_parameters => 'None',
1725: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),
1726: p_error_type => 'I');

Line 1729: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1725: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST'),
1726: p_error_type => 'I');
1727:
1728: GMF_LAYERS.log_message (
1729: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1730: p_procedure_name => 'None',
1731: p_parameters => 'None',
1732: p_message => 'Profile GMF_USE_ITEM_STEP_DEPENDENCIES = '||FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES'),
1733: p_error_type => 'I');

Line 1769: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1765:
1766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1767: -- fnd_file.put_line ('Error creating resource layer : '||to_char (rt.poc_trans_id));
1768: GMF_LAYERS.log_message (
1769: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1770: p_procedure_name => 'None',
1771: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1772: p_message => 'Error creating resource layer',
1773: p_error_type => 'E');

Line 1776: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1772: p_message => 'Error creating resource layer',
1773: p_error_type => 'E');
1774: FOR i IN 1..fnd_msg_pub.count_msg LOOP
1775: GMF_LAYERS.log_message (
1776: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1777: p_procedure_name => 'None',
1778: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1779: p_message => fnd_msg_pub.get_detail (i, NULL),
1780: p_error_type => 'E');

Line 1794: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1790: END;
1791: END LOOP;
1792:
1793: GMF_LAYERS.log_message (
1794: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1795: p_procedure_name => 'None',
1796: p_parameters => 'Incoming Layers = '||to_char(l_il_count)||
1797: ', Outgoing Layers = '||to_char(l_ol_count)||
1798: ', Resource Layers = '||to_char(l_rl_count),

Line 1905: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1901: l_use_vib := FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST');
1902: l_use_step_dep := FND_PROFILE.VALUE ('GMF_USE_ITEM_STEP_DEPENDENCIES');
1903:
1904: GMF_LAYERS.log_message (
1905: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1906: p_procedure_name => 'None',
1907: p_parameters => 'None',
1908: p_message => 'Started the migration to Recreate_incoming_layers for the batch',
1909: p_error_type => 'I');

Line 1912: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1908: p_message => 'Started the migration to Recreate_incoming_layers for the batch',
1909: p_error_type => 'I');
1910:
1911: GMF_LAYERS.log_message (
1912: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1913: p_procedure_name => 'None',
1914: p_parameters => 'None',
1915: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||l_use_vib,
1916: p_error_type => 'I');

Line 1919: p_table_name => 'GMF_BATCH_VIB_DETAILS',

1915: p_message => 'Profile GMF_USE_VIB_FOR_ACOST = '||l_use_vib,
1916: p_error_type => 'I');
1917:
1918: GMF_LAYERS.log_message (
1919: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1920: p_procedure_name => 'None',
1921: p_parameters => 'None',
1922: p_message => 'Profile GMF_USE_ITEM_STEP_DEPENDENCIES = '||l_use_step_dep,
1923: p_error_type => 'I');

Line 2027: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2023: WHEN OTHERS THEN
2024: -- fnd_file.put_line ('Error in UOM conversion');
2025: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
2026: GMF_LAYERS.log_message (
2027: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2028: p_procedure_name => 'None',
2029: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id)||
2030: ' From UOM = '||trans_rec.primary_uom_code||', To UOM = '||t.doc_um,
2031: p_message => 'UOM Conversion error',

Line 2064: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2060:
2061: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: -- fnd_file.put_line ('Error creating incoming layer : '||to_char (mt.trans_id));
2063: GMF_LAYERS.log_message (
2064: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2065: p_procedure_name => 'None',
2066: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2067: p_message => 'Error creating incoming layer',
2068: p_error_type => 'E');

Line 2071: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2067: p_message => 'Error creating incoming layer',
2068: p_error_type => 'E');
2069: FOR i IN 1..fnd_msg_pub.count_msg LOOP
2070: GMF_LAYERS.log_message (
2071: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2072: p_procedure_name => 'None',
2073: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2074: p_message => fnd_msg_pub.get_detail (i, NULL),
2075: p_error_type => 'E');

Line 2090: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2086: l_prev_mat_det_id := t.mat_det_id; -- B 15888374
2087: END LOOP;
2088:
2089: GMF_LAYERS.log_message (
2090: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2091: p_procedure_name => 'None',
2092: p_parameters => 'Incoming Layers = '||to_char(l_il_count)||
2093: ', Outgoing Layers = '||to_char(l_ol_count)||
2094: ', Resource Layers = '||to_char(l_rl_count),

Line 2161: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2157: x_msg_data);
2158:
2159: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2160: GMF_LAYERS.log_message (
2161: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2162: p_procedure_name => 'None',
2163: p_parameters => 'Batch ID = '||to_char(cls.batch_id),
2164: p_message => 'Error creating finalization layers',
2165: p_error_type => 'E');

Line 2169: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2165: p_error_type => 'E');
2166:
2167: FOR i IN 1..fnd_msg_pub.count_msg LOOP
2168: GMF_LAYERS.log_message (
2169: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2170: p_procedure_name => 'None',
2171: p_parameters => 'Batch ID = '||to_char(cls.batch_id),
2172: p_message => fnd_msg_pub.get_detail (i, NULL),
2173: p_error_type => 'E');

Line 2182: p_table_name => 'GMF_BATCH_VIB_DETAILS',

2178: NULL;
2179: END;
2180: END LOOP;
2181: GMF_LAYERS.log_message (
2182: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2183: p_procedure_name => 'None',
2184: p_parameters => 'Batch ID = '||to_char(p_batch_id),
2185: p_message => 'Layer Finalization completed',
2186: p_error_type => 'E');

Line 2617: FROM gmf_batch_vib_details bvd

2613: AND t.transaction_source_type_id = 5
2614: );
2615: fnd_file.put_line(fnd_file.log, ' Outgoing layers count = '|| l_count);
2616: SELECT count(*) INTO l_count
2617: FROM gmf_batch_vib_details bvd
2618: WHERE bvd.requirement_id IN
2619: (SELECT br.requirement_id
2620: FROM gmf_batch_requirements br, gme_batch_header h
2621: WHERE h.batch_id = rec.batch_id