APPS.CN_NOTIFY_ORDERS dependencies on ASO_I_OE_ORDER_LINES_V

Line 208: aso_i_oe_order_lines_v asol

204: p_adj_flag,
205: cn_global.ord_event_id
206: FROM
207: aso_i_oe_order_headers_v asoh,
208: aso_i_oe_order_lines_v asol
209: WHERE
210: asoh.header_id = p_header_id
211: AND asoh.booked_flag = 'Y' -- only interested in status of booked
212: -- NOTE: asoh.header_id is a primary key, so no need to

Line 358: FROM aso_i_oe_order_lines_v

354: l_org_id NUMBER;
355: -- cursor which gets information for a particular line
356: CURSOR c_line (cp_lid NUMBER) IS
357: SELECT top_model_line_id, service_reference_line_id
358: FROM aso_i_oe_order_lines_v
359: WHERE line_id = cp_lid
360: AND org_id = l_org_id;
361: l_line_rec c_line%ROWTYPE;
362:

Line 388: FROM aso_i_oe_order_lines_v asol

384: cn_message_pkg.debug('notify: adjust: . Header SC change');
385: fnd_file.put_line(fnd_file.Log, 'notify: adjust: . Header SC change');
386: FOR rec IN
387: (SELECT line_id
388: FROM aso_i_oe_order_lines_v asol
389: WHERE asol.header_id = p_header_id
390: AND asol.service_reference_line_id IS NULL
391: AND asol.org_id = l_org_id
392: AND (asol.top_model_line_id IS NULL OR

Line 437: FROM aso_i_oe_order_lines_v asol

433: cn_message_pkg.debug('notify: adjust: .. Standard line');
434: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Standard line');
435: FOR rec IN
436: (SELECT header_id, line_id
437: FROM aso_i_oe_order_lines_v asol
438: WHERE asol.service_reference_line_id = p_line_id
439: AND asol.org_id = p_org_id
440: AND NOT EXISTS
441: (SELECT 1

Line 458: FROM aso_i_oe_order_lines_v asol

454: cn_message_pkg.debug('notify: adjust: .. Top Model line');
455: fnd_file.put_line(fnd_file.Log, 'notify: adjust: .. Top Model line');
456: FOR rec IN
457: (SELECT line_id
458: FROM aso_i_oe_order_lines_v asol
459: WHERE asol.top_model_line_id = p_line_id
460: AND asol.org_id = p_org_id
461: AND asol.header_id = p_header_id -- makes use of index
462: AND NOT EXISTS

Line 525: FROM aso_i_oe_order_lines_v

521: -- cursor which loops through all the lines under a
522: -- particular header
523: CURSOR c_affected_lines (cp_hid NUMBER) IS
524: SELECT header_id, line_id
525: FROM aso_i_oe_order_lines_v
526: WHERE header_id = cp_hid
527: AND org_id = x_org_id; -- R12 MOAC Change
528: l_affected_line_rec c_affected_lines%ROWTYPE;
529: -- Cursor which gets all Service lines for the

Line 534: FROM aso_i_oe_order_lines_v

530: -- input line, where the Service line resides on
531: -- another order
532: CURSOR c_affected_service_lines (cp_hid NUMBER, cp_lid NUMBER) IS
533: SELECT header_id, line_id
534: FROM aso_i_oe_order_lines_v
535: WHERE service_reference_line_id = cp_lid
536: AND header_id <> cp_hid
537: AND org_id = x_org_id;
538: l_affected_service_line_rec c_affected_lines%ROWTYPE;

Line 1385: aso_i_oe_order_lines_v asol

1381: cn_global.ord_event_id,
1382: l_client_org_id
1383: FROM
1384: aso_i_oe_order_headers_v asoh,
1385: aso_i_oe_order_lines_v asol
1386: WHERE
1387: -- Multi_org filter, see comment in procedure header
1388: -- NOTE: asoh.header_id is a primary key, so no need to
1389: -- have an org filter for the join to asol