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_ATP_24X7 dependencies on MSC_CTO_SOURCES

Line 1172: -- Select OSS Sourcing records for ATO Models from msc_cto_sources and re-populate with new session_id

1168: AND sr_instance_id = x_atp_rec.instance_id(i);
1169:
1170: conc_debug ('No. of ATO Component records inserted: ' || SQL%ROWCOUNT);
1171:
1172: -- Select OSS Sourcing records for ATO Models from msc_cto_sources and re-populate with new session_id
1173: FORALL i in 1..x_record_count
1174: INSERT INTO msc_cto_sources (
1175: line_id,
1176: organization_id,

Line 1174: INSERT INTO msc_cto_sources (

1170: conc_debug ('No. of ATO Component records inserted: ' || SQL%ROWCOUNT);
1171:
1172: -- Select OSS Sourcing records for ATO Models from msc_cto_sources and re-populate with new session_id
1173: FORALL i in 1..x_record_count
1174: INSERT INTO msc_cto_sources (
1175: line_id,
1176: organization_id,
1177: supplier_id,
1178: status_flag,

Line 1207: FROM msc_cto_sources

1203: make_flag,
1204: refresh_number,
1205: NULL, -- Plan ID
1206: p_session_id
1207: FROM msc_cto_sources
1208: WHERE ato_line_id = x_atp_rec.ATO_Model_Line_Id(i)
1209: AND session_id = x_atp_rec.attribute_11(i)
1210: AND plan_id = p_old_plan_id
1211: AND x_atp_rec.quantity_ordered(i) > 0