eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_NOTIFY_ORDERS dependencies on ASO_I_OE_ORDER_HEADERS_V

Line 207: aso_i_oe_order_headers_v asoh,

203: g_source_doc_type,
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

Line 322: aso_i_oe_order_headers_v asoh

318: g_source_doc_type,
319: 'Y',
320: cn_global.ord_event_id
321: FROM
322: aso_i_oe_order_headers_v asoh
323: WHERE
324: asoh.header_id = p_header_id
325: AND asoh.booked_flag = 'Y'
326: AND asoh.org_id = l_org_id; -- only interested in status of booked

Line 1262: -- the selection from ASO_I_OE_ORDER_HEADERS_V to only the

1258: -- The purpose of this procedure is to collect new orders for the
1259: -- current Org only, so we have to add an Org filter to the WHERE
1260: -- clause of the query.
1261: -- This is why there is a line in the WHERE clause to restrict
1262: -- the selection from ASO_I_OE_ORDER_HEADERS_V to only the
1263: -- current Org_Id. We only need to do this on the ...HEADERS_V
1264: -- view, because we then join from ...HEADERS_V to ...LINES_V using
1265: -- ASO_I_OE_ORDER_HEADERS_V.Header_Id, which is Primary Key.
1266:

Line 1265: -- ASO_I_OE_ORDER_HEADERS_V.Header_Id, which is Primary Key.

1261: -- This is why there is a line in the WHERE clause to restrict
1262: -- the selection from ASO_I_OE_ORDER_HEADERS_V to only the
1263: -- current Org_Id. We only need to do this on the ...HEADERS_V
1264: -- view, because we then join from ...HEADERS_V to ...LINES_V using
1265: -- ASO_I_OE_ORDER_HEADERS_V.Header_Id, which is Primary Key.
1266:
1267:
1268: -- History
1269: -- 04-16-98 J.Cheng Created

Line 1384: aso_i_oe_order_headers_v asoh,

1380: x_adj_flag,
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