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.

[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MSC_CTO_SOURCES

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

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

Line 1177: INSERT INTO msc_cto_sources (

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

Line 1210: FROM msc_cto_sources

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