DBA Data[Home] [Help]

APPS.FUN_TRX_TYPES_PUB dependencies on AR_MEMO_LINES_ALL_VL

Line 166: AR_MEMO_LINES_ALL_VL m

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
170: tm.memo_line_id = m.memo_line_id AND

Line 184: AR_MEMO_LINES_ALL_VL m

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
188: tm.memo_line_id = m.memo_line_id AND

Line 203: AR_MEMO_LINES_ALL_VL m

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
207: AND ar.org_id = p_org_id

Line 219: AR_MEMO_LINES_ALL_VL m

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
223: AND ar.org_id = p_org_id