[Home] [Help]
74: (reference29 IN ('INV_REC','CB_REC','CM_REC','DM_REC','TRADE_CASH','TRADE_UNAPP','ADJ_REC'))
75: OR
76: ( arp_global.sysparam.accounting_method = 'CASH' AND
77: reference29 = 'TRADE_APP' AND
78: reference30 = 'AR_RECEIVABLE_APPLICATIONS' ) );
79:
80: -- ========================= FND LOG ===========================
81: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 1 -->'
82: || SQL%ROWCOUNT );
95: WHERE gl.user_je_source_name = 'Receivables'
96: AND gl.set_of_books_id = l_sob_id
97: AND gl.group_id = l_group_id
98: AND gl.reference29 = 'TRADE_UNAPP'
99: AND gl.reference30 = 'AR_RECEIVABLE_APPLICATIONS'
100: AND EXISTS
101: ( SELECT 'Cash Receipt Unapplied'
102: FROM ar_cash_receipts ar
103: WHERE ar.cash_receipt_id = TO_NUMBER(SUBSTR(gl.reference22, 1, INSTR(gl.reference22, 'C')-1))
122: WHERE gl.user_je_source_name = 'Receivables'
123: AND gl.set_of_books_id = l_sob_id
124: AND gl.group_id = l_group_id
125: AND gl.reference29 = 'TRADE_UNAPP'
126: AND gl.reference30 = 'AR_RECEIVABLE_APPLICATIONS'
127: AND NOT EXISTS
128: ( SELECT 'Cash Receipt Unapplied'
129: FROM ar_cash_receipts ar
130: WHERE ar.cash_receipt_id = TO_NUMBER(SUBSTR(gl.reference22, 1, INSTR(gl.reference22, 'C')-1))
165: AND set_of_books_id = l_sob_id
166: AND group_id = l_group_id
167: AND ussgl_transaction_code IS NOT NULL
168: AND reference29 = 'TRADE_REC'
169: AND reference30 = 'AR_RECEIVABLE_APPLICATIONS'
170: AND is_mfar_transaction
171: (TO_NUMBER(SUBSTR(reference22, INSTR(reference22, 'C')+1)), l_sob_id) = 'Y';
172:
173: -- ========================= FND LOG ===========================
224:
225: Cursor c_trx_id (c_doc_id IN NUMBER)
226: IS
227: Select applied_customer_trx_id
228: From ar_receivable_applications
229: Where receivable_application_id = c_doc_id;
230:
231: l_cust_trx_id NUMBER;
232: l_mfar_type VARCHAR2(1);