150: m.name,
151: ar.cust_trx_type_id,
152: ar.name ,
153: Nvl(ar.default_term, 4)
154: FROM FUN_TRX_TYPE_AR_MAPS tm,
155: RA_CUST_TRX_TYPES_ALL ar,
156: AR_MEMO_LINES_ALL_VL m
157: WHERE tm.trx_type_id = p_trx_type_id AND
158: tm.org_id = p_org_id AND
232: p_org_id NUMBER,
233: p_trx_date DATE)
234: IS
235: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
236: FROM FUN_TRX_TYPE_AR_MAPS tm,
237: RA_CUST_TRX_TYPES_ALL ar
238: WHERE tm.trx_type_id = p_trx_type_id AND
239: tm.org_id = p_org_id AND
240: tm.org_id = ar.org_id AND