DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 136: , OKL_TXD_AR_LN_DTLS_B TXD

132: ,okc_rules_b rul_hld
133: , OKL_LATE_POLICIES_V LTE
134: , AR_CASH_RECEIPTS_ALL CRA
135: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
136: , OKL_TXD_AR_LN_DTLS_B TXD
137: , AR_DISTRIBUTIONS_ALL AD
138: WHERE
139: TO_CHAR(TXD.ID) = RACTRL.interface_line_attribute14
140: AND RACTRL.CUSTOMER_TRX_ID = AR_PAY.CUSTOMER_TRX_ID

Line 210: , OKL_TXD_AR_LN_DTLS_B TXD

206: , OKL_LATE_POLICIES_V LTE
207: , AR_CASH_RECEIPTS_ALL CRA
208: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
209: , RA_CUSTOMER_TRX_LINES_ALL RACTRL_TAX
210: , OKL_TXD_AR_LN_DTLS_B TXD
211: , AR_DISTRIBUTIONS_ALL AD
212: WHERE
213: TO_CHAR(TXD.ID) = RACTRL.interface_line_attribute14
214: AND RACTRL.CUSTOMER_TRX_ID = AR_PAY.CUSTOMER_TRX_ID

Line 1071: Update OKL_TXD_AR_LN_DTLS_B

1067: IF l_inv_cur.INVOICE_FLAG = 'AR-INVOICE' THEN
1068: IF NOT(l_error_flag) THEN
1069: FOR l_lsm IN l_AR_lsm_cur(l_inv_cur.RECEIVABLES_INVOICE_ID, l_inv_cur.CONTRACT_ID)
1070: LOOP
1071: Update OKL_TXD_AR_LN_DTLS_B
1072: set LATE_INT_ASS_YN = 'Y'
1073: , LATE_INT_ASSESS_DATE = SYSDATE
1074: ,last_updated_by = l_last_updated_by
1075: ,last_update_date = sysdate