APPS.MSC_ATP_CTO dependencies on MSC_CTO_BOM

Line 996: delete msc_cto_bom where session_id = p_session_id;

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

Line 998: insert into msc_cto_bom

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

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

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

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

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

Line 1197: FROM msc_cto_bom mcb,

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