DBA Data[Home] [Help]

APPS.CN_NOTIFY_ORDERS dependencies on CN_GLOBAL

Line 205: cn_global.ord_event_id

201: asoh.header_id,
202: asol.line_id,
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

Line 320: cn_global.ord_event_id

316: asoh.header_id,
317: p_line_id,
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

Line 1381: cn_global.ord_event_id,

1377: asoh.header_id,
1378: asol.line_id,
1379: g_source_doc_type,
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

Line 1411: AND event_id= cn_global.ord_event_id

1407: (SELECT 1
1408: FROM cn_not_trx
1409: WHERE source_trx_id = asoh.header_id
1410: AND source_trx_line_id = asol.line_id
1411: AND event_id= cn_global.ord_event_id
1412: AND org_id = l_client_org_id) ;
1413:
1414: l_trx_count := SQL%ROWCOUNT;
1415: