APPS.MSC_ATP_CTO dependencies on MSC_CTO_BOM

Line 999: delete msc_cto_bom where session_id = p_session_id;

995: msc_sch_wb.atp_debug('p_session_id := ' || p_session_id);
996: END IF;
997:
998: --delete data for old session
999: delete msc_cto_bom where session_id = p_session_id;
1000: ---first insert into local database
1001: insert into msc_cto_bom
1002: (SR_INVENTORY_ITEM_ID,
1003: inventory_item_id,

Line 1001: insert into msc_cto_bom

997:
998: --delete data for old session
999: delete msc_cto_bom where session_id = p_session_id;
1000: ---first insert into local database
1001: insert into msc_cto_bom
1002: (SR_INVENTORY_ITEM_ID,
1003: inventory_item_id,
1004: LINE_ID,
1005: TOP_MODEL_LINE_ID,

Line 1049: l_sql_stmt := 'Insert into Msc_CTO_Bom' || l_dblink;

1045: IF p_dblink is not null THEN
1046: -- now transfer the data accross the database link
1047: --- in case of distributed transaction
1048: l_dblink := '@' || p_dblink;
1049: l_sql_stmt := 'Insert into Msc_CTO_Bom' || l_dblink;
1050: l_sql_stmt := l_sql_stmt ||
1051: ' Select * from Msc_CTO_Bom where session_id = :p_session_id';
1052:
1053:

Line 1051: ' Select * from Msc_CTO_Bom where session_id = :p_session_id';

1047: --- in case of distributed transaction
1048: l_dblink := '@' || p_dblink;
1049: l_sql_stmt := 'Insert into Msc_CTO_Bom' || l_dblink;
1050: l_sql_stmt := l_sql_stmt ||
1051: ' Select * from Msc_CTO_Bom where session_id = :p_session_id';
1052:
1053:
1054: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
1055: END IF;

Line 1200: FROM msc_cto_bom mcb,

1196: p_comp_rec.dest_inventory_item_id,
1197: p_comp_rec.comp_uom, --bug3110023
1198: p_comp_rec.usage_qty, --4775920
1199: p_comp_rec.organization_type --4775920
1200: FROM msc_cto_bom mcb,
1201: msc_calendar_dates c1,
1202: msc_calendar_dates c2,
1203: msc_trading_partners tp,
1204: msc_system_items msi,