DBA Data[Home] [Help]

APPS.FUN_TRX_TYPES_PUB dependencies on FUN_TRX_TYPE_AR_MAPS

Line 154: FROM FUN_TRX_TYPE_AR_MAPS tm,

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

Line 236: FROM FUN_TRX_TYPE_AR_MAPS tm,

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