APPS.MSC_BAL_UTILS dependencies on OE_MRP_OPEN_DEMANDS_V

Line 35: where table_name ='OE_MRP_OPEN_DEMANDS_V'

31:
32: cursor check_oe (p_column_name varchar2) is
33: select 1
34: from user_tab_columns
35: where table_name ='OE_MRP_OPEN_DEMANDS_V'
36: and column_name = p_column_name;
37:
38: l_column_exist number;
39: l_sql_stmt varchar2(30000);

Line 155: 'oe_mrp_open_demands_v omodv '||

151: 'hz_cust_site_uses_all ras, '||
152: 'hz_parties hp, '||
153: 'hz_cust_accounts hca, '||
154: 'org_organization_definitions ood, '||
155: 'oe_mrp_open_demands_v omodv '||
156: 'WHERE hp.party_id = hca.party_id '||
157: 'AND hca.cust_account_id = omodv.sold_to_org_id '||
158: 'AND ras.site_use_id = omodv.ship_to_org_id '||
159: 'AND ras.site_use_code = '||' ''SHIP_TO'' '||

Line 251: oe_mrp_open_demands_v omodv

247: omodv.request_arrival_date,
248: omodv.promise_date,
249: omodv.planning_priority
250: FROM
251: oe_mrp_open_demands_v omodv
252: WHERE 1=1 ';
253: else
254: IF PG_DEBUG in ('Y', 'C') THEN
255: msc_sch_wb.atp_debug('MSC_BAL_UTILS.populate_temp_table: new column Planning_priority DOES NOT exsits' );

Line 296: oe_mrp_open_demands_v omodv

292: omodv.request_ship_date,
293: omodv.request_arrival_date,
294: omodv.promise_date
295: FROM
296: oe_mrp_open_demands_v omodv
297: WHERE 1=1 ';
298: end if;
299: l_stmt := l_stmt || p_where;
300:

Line 346: from oe_mrp_open_demands_v omodv1,

342: omodv1.request_arrival_date,
343: omodv1.promise_date,
344: omodv1.order_number,
345: omodv1.planning_priority
346: from oe_mrp_open_demands_v omodv1,
347: mrp_atp_schedule_temp mrp
348: where mrp.session_id = -444
349: and mrp.order_header_id = omodv1.header_id
350: and ( mrp.order_line_id = omodv1.line_id

Line 372: from oe_mrp_open_demands_v omodv1,

368: omodv1.request_arrival_date,
369: omodv1.promise_date,
370: omodv1.order_number,
371: 0
372: from oe_mrp_open_demands_v omodv1,
373: mrp_atp_schedule_temp mrp
374: where mrp.session_id = -444
375: and mrp.order_header_id = omodv1.header_id
376: and ( mrp.order_line_id = omodv1.line_id

Line 1242: where table_name ='OE_MRP_OPEN_DEMANDS_V'

1238:
1239: cursor check_oe is
1240: select 1
1241: from user_tab_columns
1242: where table_name ='OE_MRP_OPEN_DEMANDS_V'
1243: and column_name ='FLOW_STATUS_CODE';
1244:
1245: l_column_exist number;
1246: l_time varchar2(80);

Line 1253: ' ( select flow_status_code from oe_mrp_open_demands_v b '||

1249: c1 CurTyp;
1250:
1251: sql_stmt varchar2(3000) :=
1252: ' update mrp_atp_schedule_temp a set flow_status_code = '||
1253: ' ( select flow_status_code from oe_mrp_open_demands_v b '||
1254: ' where a.order_line_id = b.line_id ) '||
1255: ' where a.session_id = :p_session_id ';
1256:
1257: l_return_status VARCHAR2(1);

Line 1443: oe_mrp_open_demands_v omodv

1439: mrp.delivery_lead_time,
1440: mrp.ship_method,
1441: decode(mrp.firm_flag, 1, 'Y', 2, 'N')
1442: FROM mrp_atp_schedule_temp mrp,
1443: oe_mrp_open_demands_v omodv
1444: WHERE mrp.session_id = p_session_id
1445: AND mrp.order_line_id = omodv.line_id
1446: AND mrp.order_header_id = omodv.header_id
1447: AND mrp.status_flag = 2