APPS.FUN_TRX_TYPES_PUB dependencies on RA_CUST_TRX_TYPES_ALL

Line 165: RA_CUST_TRX_TYPES_ALL ar,

161: ar.cust_trx_type_id,
162: ar.name ,
163: Nvl(ar.default_term, 4)
164: FROM FUN_TRX_TYPE_AR_MAPS tm,
165: RA_CUST_TRX_TYPES_ALL ar,
166: AR_MEMO_LINES_ALL_VL m
167: WHERE tm.trx_type_id = p_trx_type_id AND
168: tm.org_id = p_org_id AND
169: tm.ar_trx_type_id = ar.cust_trx_type_id AND

Line 183: RA_CUST_TRX_TYPES_ALL ar,

179: ar.cust_trx_type_id,
180: ar.name ,
181: null default_term_id
182: FROM FUN_TRX_TYPE_AR_MAPS tm,
183: RA_CUST_TRX_TYPES_ALL ar,
184: AR_MEMO_LINES_ALL_VL m
185: WHERE tm.trx_type_id = p_trx_type_id AND
186: tm.org_id = p_org_id AND
187: tm.ar_cm_trx_type_id = ar.cust_trx_type_id AND

Line 202: RA_CUST_TRX_TYPES_ALL ar,

198: ar.cust_trx_type_id,
199: ar.name,
200: 4 default_term_id
201: FROM fun_system_options fun,
202: RA_CUST_TRX_TYPES_ALL ar,
203: AR_MEMO_LINES_ALL_VL m
204: WHERE fun.default_memo_line_id = m.memo_line_id
205: AND fun.default_ar_trx_type_id = ar.cust_trx_type_id
206: AND ar.org_id = m.org_id

Line 218: RA_CUST_TRX_TYPES_ALL ar,

214: ar.cust_trx_type_id,
215: ar.name,
216: null default_term_id
217: FROM fun_system_options fun,
218: RA_CUST_TRX_TYPES_ALL ar,
219: AR_MEMO_LINES_ALL_VL m
220: WHERE fun.default_memo_line_id = m.memo_line_id
221: AND fun.default_cm_trx_type_id = ar.cust_trx_type_id
222: AND ar.org_id = m.org_id

Line 321: RA_CUST_TRX_TYPES_ALL ar

317: p_trx_date DATE)
318: IS
319: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
320: FROM FUN_TRX_TYPE_AR_MAPS tm,
321: RA_CUST_TRX_TYPES_ALL ar
322: WHERE tm.trx_type_id = p_trx_type_id AND
323: tm.org_id = p_org_id AND
324: tm.org_id = ar.org_id AND
325: tm.ar_trx_type_id = ar.cust_trx_type_id AND

Line 334: RA_CUST_TRX_TYPES_ALL ar

330: p_trx_date DATE)
331: IS
332: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
333: FROM FUN_TRX_TYPE_AR_MAPS tm,
334: RA_CUST_TRX_TYPES_ALL ar
335: WHERE tm.trx_type_id = p_trx_type_id AND
336: tm.org_id = p_org_id AND
337: tm.org_id = ar.org_id AND
338: tm.ar_cm_trx_type_id = ar.cust_trx_type_id AND

Line 346: RA_CUST_TRX_TYPES_ALL ar

342: p_trx_date DATE)
343: IS
344: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
345: FROM fun_system_options fun,
346: RA_CUST_TRX_TYPES_ALL ar
347: WHERE fun.default_ar_trx_type_id = ar.cust_trx_type_id
348: AND ar.org_id = p_org_id
349: AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);
350:

Line 356: RA_CUST_TRX_TYPES_ALL ar

352: p_trx_date DATE)
353: IS
354: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
355: FROM fun_system_options fun,
356: RA_CUST_TRX_TYPES_ALL ar
357: WHERE fun.default_cm_trx_type_id = ar.cust_trx_type_id
358: AND ar.org_id = p_org_id
359: AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);
360: