APPS.CN_RAM_ADJUSTMENTS_PKG dependencies on CN_NOT_TRX

Line 13: -- Join cn_not_trx and ar_revenue_adjustments to get the customer_trx_id

9: debug_level NUMBER DEFAULT NULL,
10: x_org_id NUMBER ) IS
11:
12:
13: -- Join cn_not_trx and ar_revenue_adjustments to get the customer_trx_id
14: -- of the transactions (header level) which have been RAM-adjusted after
15: -- last collection run within the interested period.
16:
17: -- Note : the application_date and last_collected_date used in the where

Line 33: from cn_not_trx cnt, ar_revenue_adjustments ara

29: ara.from_cust_trx_line_id,
30: ara.from_inventory_item_id,
31: ara.from_category_id,
32: ara.line_selection_mode
33: from cn_not_trx cnt, ar_revenue_adjustments ara
34: where
35: nvl(cnt.last_collected_date, cnt.notified_date) <= ara.application_date and
36: cnt.collected_flag = 'Y' and -- has been collected before
37: cnt.source_doc_type = 'AR' and -- AR collection

Line 104: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl

100: collected_flag = 'N',
101: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
102: where trx_line_id in (
103: select ctl.trx_line_id
104: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl
105: where cnt.not_trx_id = adj.not_trx_id and
106: ct.not_trx_id = cnt.not_trx_id and
107: ctl.trx_id = ct.trx_id and
108: cnt.source_trx_id = adj.customer_trx_id and

Line 137: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl

133: collected_flag = 'N',
134: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
135: where trx_line_id in (
136: select ctl.trx_line_id
137: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl
138: where cnt.not_trx_id = adj.not_trx_id and
139: ct.not_trx_id = cnt.not_trx_id and
140: ctl.trx_id = ct.trx_id and
141: cnt.source_trx_id = adj.customer_trx_id and

Line 164: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl

160: collected_flag = 'N',
161: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
162: where trx_line_id in (
163: select ctl.trx_line_id
164: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl
165: where cnt.not_trx_id = adj.not_trx_id and
166: ct.not_trx_id = cnt.not_trx_id and
167: ctl.trx_id = ct.trx_id and
168: cnt.source_trx_id = adj.customer_trx_id and

Line 196: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,

192: collected_flag = 'N',
193: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
194: where trx_line_id in (
195: select ctl.trx_line_id
196: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,
197: (select rctl.customer_trx_line_id
198: from ra_customer_trx_lines rctl
199: where rctl.customer_trx_id = adj.customer_trx_id and
200: exists

Line 226: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,

222: collected_flag = 'N',
223: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
224: where trx_line_id in (
225: select ctl.trx_line_id
226: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,
227: mtl_item_categories mic
228: where cnt.not_trx_id = adj.not_trx_id and
229: ct.not_trx_id = cnt.not_trx_id and
230: ctl.trx_id = ct.trx_id and

Line 247: -- Update cn_not_trx.last_collected_date

243: end if; -- end if (adj.customer_trx_id = x_last_A_customer_trx_id)
244: end if; -- end if adj.line_selection_mode = 'A'
245:
246:
247: -- Update cn_not_trx.last_collected_date
248: update cn_not_trx
249: set last_collected_date = SYSDATE
250: where not_trx_id = adj.not_trx_id
251: AND org_id = x_org_id; --MOAC Changes made by Ashley

Line 248: update cn_not_trx

244: end if; -- end if adj.line_selection_mode = 'A'
245:
246:
247: -- Update cn_not_trx.last_collected_date
248: update cn_not_trx
249: set last_collected_date = SYSDATE
250: where not_trx_id = adj.not_trx_id
251: AND org_id = x_org_id; --MOAC Changes made by Ashley
252: