DBA Data[Home] [Help]

APPS.CN_NOTIFY_INVOICES dependencies on CN_GLOBAL

Line 90: cn_global.inv_event_id,

86: 'N',
87: rct.rowid,
88: rct.customer_trx_id,
89: 'AR',
90: cn_global.inv_event_id,
91: x_org_id
92: FROM ra_customer_trx rct,
93: ra_cust_trx_types rctt,
94: ra_cust_trx_line_gl_dist rctlgd,

Line 114: AND event_id= cn_global.inv_event_id

110: AND NOT EXISTS (
111: SELECT 1
112: FROM cn_not_trx
113: WHERE source_trx_id = rct.customer_trx_id
114: AND event_id= cn_global.inv_event_id
115: AND org_id = x_org_id) ;
116:
117: ELSE -- CN_COLLECT_ON_ACCT_CREDITS = 'N'
118:

Line 141: cn_global.inv_event_id,

137: 'N',
138: rct.rowid,
139: rct.customer_trx_id,
140: 'AR',
141: cn_global.inv_event_id,
142: x_org_id
143: FROM ra_customer_trx rct,
144: ra_cust_trx_types rctt,
145: ra_cust_trx_line_gl_dist rctlgd,

Line 168: AND event_id= cn_global.inv_event_id

164: AND NOT EXISTS (
165: SELECT 1
166: FROM cn_not_trx
167: WHERE source_trx_id = rct.customer_trx_id
168: AND event_id= cn_global.inv_event_id
169: AND org_id = x_org_id) ;
170:
171: END IF;
172: