APPS.MSC_SCH_WB dependencies on MRP_ATP_DETAILS_TEMP

Line 462: DELETE FROM mrp_atp_details_temp madt

458: IF PG_DEBUG in ('Y', 'C') THEN
459: atp_debug('delete_lines: ' || ' deleting all rows for session_id 2 '||p_session_id);
460: END IF;
461:
462: DELETE FROM mrp_atp_details_temp madt
463: WHERE madt.session_id = p_session_id;
464: IF PG_DEBUG in ('Y', 'C') THEN
465: atp_debug('delete_lines: ' || ' deleting all rows for session_id 3 '||p_session_id);
466: END IF;

Line 1152: FROM mrp_atp_details_temp

1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display
1150: -- for line. otherwise following values shift left.
1151: INTO l_pivot_hdr
1152: FROM mrp_atp_details_temp
1153: WHERE pegging_id = p_pegging_id
1154: AND record_type = 3;
1155: END IF;
1156:

Line 1184: FROM MRP_ATP_DETAILS_TEMP

1180: x_atp_period_string.Period_End_Date,
1181: x_atp_period_string.Period_Quantity,
1182: x_atp_period_string.Cumulative_Quantity,
1183: x_atp_period_string.Bucketed_Quantity
1184: FROM MRP_ATP_DETAILS_TEMP
1185: WHERE
1186: record_type = 1
1187: AND (( p_pegging_id IS NULL and end_pegging_id = p_end_pegging_id)
1188: OR pegging_id = p_pegging_id)

Line 1216: FROM MRP_ATP_DETAILS_TEMP a,

1212: x_atp_period_string.Period_End_Date,
1213: x_atp_period_string.Period_Quantity,
1214: x_atp_period_string.Cumulative_Quantity,
1215: x_atp_period_string.Bucketed_Quantity
1216: FROM MRP_ATP_DETAILS_TEMP a,
1217: MRP_ATP_DETAILS_TEMP b
1218: WHERE
1219: a.record_type (+) = 1
1220: and a.session_id (+) = p_session_id

Line 1217: MRP_ATP_DETAILS_TEMP b

1213: x_atp_period_string.Period_Quantity,
1214: x_atp_period_string.Cumulative_Quantity,
1215: x_atp_period_string.Bucketed_Quantity
1216: FROM MRP_ATP_DETAILS_TEMP a,
1217: MRP_ATP_DETAILS_TEMP b
1218: WHERE
1219: a.record_type (+) = 1
1220: and a.session_id (+) = p_session_id
1221: and b.session_id = p_old_session_id

Line 1243: FROM MRP_ATP_DETAILS_TEMP

1239: x_atp_period_string.Period_End_Date,
1240: x_atp_period_string.Period_Quantity,
1241: x_atp_period_string.Cumulative_Quantity,
1242: x_atp_period_string.Bucketed_Quantity
1243: FROM MRP_ATP_DETAILS_TEMP
1244: WHERE
1245: record_type = 1
1246: and session_id = p_session_id
1247: order by period_start_date;

Line 1816: from mrp_atp_details_temp

1812: PROCEDURE update_constraint_path(p_session_id IN NUMBER,
1813: p_return_error IN OUT NoCopy VARCHAR2) IS
1814: CURSOR get_constr_peg_id IS
1815: select distinct end_pegging_id
1816: from mrp_atp_details_temp
1817: where session_id = p_session_id
1818: and record_type = 3
1819: and constraint_type is not NULL;
1820:

Line 1846: sql_stmt := 'UPDATE mrp_atp_details_temp

1842: END IF;
1843:
1844: IF l_end_peg_id <> '-1' THEN
1845:
1846: sql_stmt := 'UPDATE mrp_atp_details_temp
1847: set constrained_path = ' || l_constraint_path_flag ||
1848: ' where record_type = ' || l_peg_record_type ||
1849: ' and session_id = '||p_session_id||
1850: ' and pegging_id in

Line 1852: from mrp_atp_details_temp

1848: ' where record_type = ' || l_peg_record_type ||
1849: ' and session_id = '||p_session_id||
1850: ' and pegging_id in
1851: (select pegging_id
1852: from mrp_atp_details_temp
1853: where record_type = ' || l_peg_record_type ||
1854: ' and session_id ='||p_session_id||
1855: ' start with session_id = '||p_session_id||
1856: ' and record_type = ' || l_peg_record_type ||

Line 1887: from mrp_atp_details_temp mast

1883: p_session_id NUMBER,
1884: p_organization_id NUMBER ) IS
1885: select
1886: trunc(mast.supply_demand_date - mast.required_date)
1887: from mrp_atp_details_temp mast
1888: where --mast.constraint_type is not NULL
1889: mast.session_id = p_session_id
1890: and mast.record_type = 3
1891: and mast.supply_demand_type = 2

Line 1899: from mrp_atp_details_temp mast

1895: CURSOR ato_details_no_org( p_inventory_item_id NUMBER,
1896: p_session_id NUMBER)
1897: IS
1898: select trunc(mast.supply_demand_date - mast.required_date) date_diff
1899: from mrp_atp_details_temp mast
1900: where --mast.constrained_path is not NULL
1901: mast.session_id = p_session_id
1902: and mast.record_type = 3
1903: and mast.supply_demand_type = 2