DBA Data[Home] [Help]

APPS.CN_NOTIFY_AIA_OM dependencies on CN_AIA_ORDER_CAPTURE

Line 113: cn_aia_order_capture cco10145

109: cco10145.trans_seq_id t_source_trx_line_id, --*** Line Table Key Column
110: 'AIA_OM' t_source_doc_type, --*** Source Type
111: x_org_id t_org_id
112: FROM
113: cn_aia_order_capture cco10145
114: WHERE --*** Header.Primary_Key = Line.Foreign_Key
115: 1 = 1
116: AND TRUNC(processed_date) BETWEEN x_start_date AND x_end_date
117: AND preprocess_flag = FND_API.G_FALSE

Line 192: FROM CN_AIA_ORDER_CAPTURE

188: x_org_id NUMBER ) IS
189:
190: CURSOR get_failed_trx_cr(p_start_date Date, p_end_date Date) IS
191: SELECT distinct original_order_number, ln_num
192: FROM CN_AIA_ORDER_CAPTURE
193: WHERE org_id = x_org_id and trans_seq_id in
194: ( SELECT source_trx_line_id
195: FROM cn_not_trx_all
196: WHERE batch_id = p_batch_id and org_id = x_org_id and source_trx_line_id not in