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.MSC_BAL_UTILS dependencies on MRP_ATP_SCHEDULE_TEMP

Line 44: 'insert into mrp_atp_schedule_temp '||

40:
41: l_sql_stmt1 varchar2(30000) :=
42: 'begin '||
43: -- 'FORALL j IN 1 .. :l_num_of_lines '||
44: 'insert into mrp_atp_schedule_temp '||
45: '(action, '||
46: 'calling_module, '||
47: 'sequence_number, '||
48: 'session_id, '||

Line 201: delete from mrp_atp_schedule_temp

197: open check_oe('PLANNING_PRIORITY');
198: fetch check_oe into l_column_exist;
199: close check_oe;
200:
201: delete from mrp_atp_schedule_temp
202: where session_id = -444;
203:
204:
205: if l_column_exist = 1 then

Line 213: l_stmt := ' INSERT into mrp_atp_schedule_temp

209:
210: END IF;
211:
212:
213: l_stmt := ' INSERT into mrp_atp_schedule_temp
214: (order_line_id,
215: order_header_id,
216: scenario_id,
217: session_id,

Line 259: l_stmt := ' INSERT into mrp_atp_schedule_temp

255: msc_sch_wb.atp_debug('MSC_BAL_UTILS.populate_temp_table: new column Planning_priority DOES NOT exsits' );
256: msc_sch_wb.atp_debug(' You are trying to sequece lines on planning_priority of a line , however dependency patches are not applied' );
257: msc_sch_wb.atp_debug(' OM dependency patch #3898070 is not applied correctly ');
258: END IF;
259: l_stmt := ' INSERT into mrp_atp_schedule_temp
260: (order_line_id,
261: order_header_id,
262: scenario_id, -- not null col
263: session_id, -- not null col

Line 347: mrp_atp_schedule_temp mrp

343: omodv1.promise_date,
344: omodv1.order_number,
345: omodv1.planning_priority
346: from oe_mrp_open_demands_v omodv1,
347: mrp_atp_schedule_temp mrp
348: where mrp.session_id = -444
349: and mrp.order_header_id = omodv1.header_id
350: and ( mrp.order_line_id = omodv1.line_id
351: OR

Line 373: mrp_atp_schedule_temp mrp

369: omodv1.promise_date,
370: omodv1.order_number,
371: 0
372: from oe_mrp_open_demands_v omodv1,
373: mrp_atp_schedule_temp mrp
374: where mrp.session_id = -444
375: and mrp.order_header_id = omodv1.header_id
376: and ( mrp.order_line_id = omodv1.line_id
377: OR

Line 814: from mrp_atp_schedule_temp a

810: x_atp_rec.Component_Sequence_ID,
811: x_atp_rec.Component_Code,
812: x_atp_rec.line_number,
813: x_atp_rec.included_item_flag
814: from mrp_atp_schedule_temp a
815: where a.session_id = p_session_id
816: and a.status_flag = 1
817: order by a.sequence_number;
818:

Line 926: from mrp_atp_schedule_temp

922: bulk collect into
923: p_atp_qty_ordered_temp.quantity_ordered,
924: p_atp_qty_ordered_temp.order_line_id,
925: p_atp_qty_ordered_temp.session_id
926: from mrp_atp_schedule_temp
927: where session_id = p_session_id
928: and status_flag =1 ;
929:
930: IF PG_DEBUG in ('Y', 'C') THEN

Line 989: from mrp_atp_schedule_temp

985:
986: IF PG_DEBUG in ('Y', 'C') THEN
987: select count(*)
988: INTO l_count
989: from mrp_atp_schedule_temp
990: where session_id = p_atp_qty_ordered_temp.session_id(1)
991: and status_flag = 1;
992: msc_sch_wb.atp_debug('MSC_BAL_UTILS.update_schedule_qties status_flag = 1 rec are '|| l_count);
993:

Line 997: from mrp_atp_schedule_temp

993:
994: l_count := 0;
995: select count(*)
996: INTO l_count
997: from mrp_atp_schedule_temp
998: where session_id = p_atp_qty_ordered_temp.session_id(1)
999: and status_flag = 2;
1000: msc_sch_wb.atp_debug('MSC_BAL_UTILS.update_schedule_qties status_flag = 2 rec are '|| l_count);
1001:

Line 1005: from mrp_atp_schedule_temp

1001:
1002: l_count := 0;
1003: select count(*)
1004: INTO l_count
1005: from mrp_atp_schedule_temp
1006: where session_id = p_atp_qty_ordered_temp.session_id(1);
1007: msc_sch_wb.atp_debug('MSC_BAL_UTILS.update_schedule_qties TOTAL rec are '|| l_count);
1008:
1009: END IF;

Line 1012: update mrp_atp_schedule_temp

1008:
1009: END IF;
1010:
1011: FORALL lCounter IN 1 .. p_atp_qty_ordered_temp.order_line_id.COUNT
1012: update mrp_atp_schedule_temp
1013: set status_flag = 1,
1014: quantity_ordered = p_atp_qty_ordered_temp.quantity_ordered(lCounter)
1015: where session_id =p_atp_qty_ordered_temp.session_id(lCounter)
1016: and order_line_id = p_atp_qty_ordered_temp.order_line_id(lCounter)

Line 1024: from mrp_atp_schedule_temp

1020: msc_sch_wb.atp_debug('MSC_BAL_UTILS.update_schedule_qties ' ||p_atp_qty_ordered_temp.order_line_id.COUNT);
1021: l_count := 0;
1022: select count(*)
1023: INTO l_count
1024: from mrp_atp_schedule_temp
1025: where session_id = p_atp_qty_ordered_temp.session_id(1);
1026: msc_sch_wb.atp_debug('MSC_BAL_UTILS.update_schedule_qties TOTAL rec are '|| l_count);
1027: END IF;
1028:

Line 1056: from mrp_atp_schedule_temp

1052: l_time varchar2(80);
1053:
1054: cursor records_exist is
1055: select count(*)
1056: from mrp_atp_schedule_temp
1057: where session_id = p_session_id
1058: and status_flag = 2;
1059:
1060: l_records_exist NUMBER := 0;

Line 1083: delete from mrp_atp_schedule_temp

1079: close records_exist;
1080:
1081: -- if records exist it means this is saving after scheduling
1082: if l_records_exist > 0 then
1083: delete from mrp_atp_schedule_temp
1084: where session_id = p_session_id
1085: and status_flag = 1;
1086:
1087: delete from mrp_atp_details_temp

Line 1090: update mrp_atp_schedule_temp

1086:
1087: delete from mrp_atp_details_temp
1088: where session_id = p_session_id;
1089:
1090: update mrp_atp_schedule_temp
1091: set status_flag = 1
1092: where session_id = p_session_id
1093: and status_flag = 2;
1094: -- if i am saving after scheduling

Line 1113: from mrp_atp_schedule_temp

1109: bulk collect into
1110: p_atp_qty_ordered_temp.quantity_ordered,
1111: p_atp_qty_ordered_temp.order_line_id,
1112: p_atp_qty_ordered_temp.session_id
1113: from mrp_atp_schedule_temp
1114: where session_id = p_session_id
1115: and status_flag =1 ;
1116: undemand_orders(p_session_id, x_msg_count, x_msg_data, x_return_status);
1117: update_schedule_qties(p_atp_qty_ordered_temp,

Line 1252: ' update mrp_atp_schedule_temp a set flow_status_code = '||

1248: TYPE CurTyp IS REF CURSOR;
1249: c1 CurTyp;
1250:
1251: sql_stmt varchar2(3000) :=
1252: ' update mrp_atp_schedule_temp a set flow_status_code = '||
1253: ' ( select flow_status_code from oe_mrp_open_demands_v b '||
1254: ' where a.order_line_id = b.line_id ) '||
1255: ' where a.session_id = :p_session_id ';
1256:

Line 1442: FROM mrp_atp_schedule_temp mrp,

1438: to_date(null), --earliest_ship_date
1439: mrp.delivery_lead_time,
1440: mrp.ship_method,
1441: decode(mrp.firm_flag, 1, 'Y', 2, 'N')
1442: FROM mrp_atp_schedule_temp mrp,
1443: oe_mrp_open_demands_v omodv
1444: WHERE mrp.session_id = p_session_id
1445: AND mrp.order_line_id = omodv.line_id
1446: AND mrp.order_header_id = omodv.header_id

Line 1675: delete from mrp_atp_schedule_temp

1671: record_firm_filter mrp_bal_utils.seq_alter;
1672: my_count NUMBER;
1673:
1674: BEGIN
1675: delete from mrp_atp_schedule_temp
1676: where session_id = p_session_id
1677: and status_flag = -88;
1678:
1679:

Line 1687: INSERT INTO mrp_atp_schedule_temp (session_id,

1683: ||p_seq_alter.order_line_id.COUNT);
1684: END IF;
1685:
1686: FOR j IN 1..p_seq_alter.order_line_id.COUNT LOOP
1687: INSERT INTO mrp_atp_schedule_temp (session_id,
1688: inventory_item_id,
1689: scenario_id,
1690: status_flag,
1691: sequence_number,

Line 1710: FROM mrp_atp_schedule_temp

1706: sequence_number,
1707: order_line_id,
1708: quantity_ordered, --old_seq_num,
1709: available_quantity --sequence_diff
1710: FROM mrp_atp_schedule_temp
1711: WHERE status_flag = -88
1712: AND session_id = '||p_session_id
1713: || 'order by sequence_number';
1714: a:= 1;

Line 1718: from mrp_atp_schedule_temp

1714: a:= 1;
1715:
1716: select count(*)
1717: INTO l_num_rec
1718: from mrp_atp_schedule_temp
1719: where status_flag = -88
1720: and session_id = p_session_id;
1721:
1722: IF PG_DEBUG in ('Y', 'C') THEN

Line 1755: delete from mrp_atp_schedule_temp

1751: END IF;
1752: END LOOP;
1753: CLOSE cv;
1754:
1755: delete from mrp_atp_schedule_temp
1756: where session_id = p_session_id
1757: and status_flag = -88;
1758:
1759:

Line 1762: FROM mrp_atp_schedule_temp

1758:
1759:
1760: SELECT MAX(sequence_number)
1761: INTO l_max_seq
1762: FROM mrp_atp_schedule_temp
1763: WHERE session_id = p_session_id
1764: and status_flag = 1;
1765:
1766: -- loop through the record to find firmed rows:

Line 1785: from mrp_atp_schedule_temp

1781: FOR j IN 1..p_seq_alter.order_line_id.COUNT LOOP
1782: IF p_seq_alter.order_line_id(j) IS NOT NULL THEN
1783: select sequence_number, sequence_number + p_seq_alter.seq_diff(j)
1784: into l_old_seq, l_new_seq
1785: from mrp_atp_schedule_temp
1786: where
1787: order_line_id = p_seq_alter.order_line_id(j)
1788: and session_id = p_session_id
1789: and status_flag = 1;

Line 1793: from mrp_atp_schedule_temp

1789: and status_flag = 1;
1790: ELSE
1791: select sequence_number, sequence_number + p_seq_alter.seq_diff(j)
1792: into l_old_seq, l_new_seq
1793: from mrp_atp_schedule_temp
1794: where
1795: NVL(p_seq_alter.ship_set_id(j),p_seq_alter.arrival_set_id(j))
1796: = Decode(p_seq_alter.ship_set_id(j),NULL, arrival_set_id, ship_set_id)
1797: and session_id = p_session_id

Line 1823: update mrp_atp_schedule_temp mast

1819: IF PG_DEBUG in ('Y', 'C') THEN
1820: msc_sch_wb.atp_debug('update_seq: ' || ' b4 update ');
1821: END IF;
1822:
1823: update mrp_atp_schedule_temp mast
1824: set mast.sequence_number = p_seq_alter.seq_num(j)
1825: , last_update_date = sysdate
1826: , last_updated_by = FND_GLOBAL.USER_ID
1827: , last_update_login = FND_GLOBAL.USER_ID

Line 1832: update mrp_atp_schedule_temp mast

1828: WHERE mast.session_id = p_session_id
1829: AND mast.order_line_id = p_seq_alter.order_line_id(j) ;
1830:
1831:
1832: update mrp_atp_schedule_temp mast
1833: set mast.sequence_number = Decode( Sign(p_seq_alter.seq_diff(j)),
1834: -1,mast.sequence_number + 1,
1835: 1, mast.sequence_number -1)
1836: -- dsting

Line 1853: update mrp_atp_schedule_temp mast

1849: AND mast.order_line_id <> p_seq_alter.order_line_id(j) ;
1850:
1851: FOR b IN 1..record_firm_filter.order_line_id.COUNT LOOP
1852:
1853: update mrp_atp_schedule_temp mast
1854: set mast.sequence_number = record_firm_filter.seq_num(b)
1855: , last_update_date = sysdate
1856: , last_updated_by = FND_GLOBAL.USER_ID
1857: , last_update_login = FND_GLOBAL.USER_ID

Line 1869: update mrp_atp_schedule_temp mast

1865: ' line_id ' || record_firm_filter.order_line_id(b) || ' ' ||SQL%ROWCOUNT);
1866: END IF;
1867:
1868:
1869: update mrp_atp_schedule_temp mast
1870: set mast.sequence_number = Decode( Sign(p_seq_alter.seq_diff(j)),
1871: -1, mast.sequence_number + 1,
1872: 1, mast.sequence_number -1)
1873: where