APPS.OKL_LTE_CHRG_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;

33: i NUMBER := 0;
34:
35: l_rec_inv_id OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID%type;
36: l_rec_inv_contract_id NUMBER;
37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;

Line 38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;

34:
35: l_rec_inv_id OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID%type;
36: l_rec_inv_contract_id NUMBER;
37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;

Line 114: AR_PAYMENT_SCHEDULES_ALL PAY_SCH

110: PAY_SCH.CLASS PAY_SCH_CLASS
111: FROM
112: RA_CUSTOMER_TRX_ALL RACTRX,
113: RA_CUST_TRX_TYPES_ALL RATRXTYPE,
114: AR_PAYMENT_SCHEDULES_ALL PAY_SCH
115: WHERE
116: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
117: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
118: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) lpt

Line 172: from AR_PAYMENT_SCHEDULES_ALL PS

168: ,HD.id
169: ,HD.consolidated_invoice_number
170: ,sum(PS.amount_due_remaining) amount_due_remaining
171: ,PS.due_date
172: from AR_PAYMENT_SCHEDULES_ALL PS
173: ,OKL_CNSLD_AR_STRMS_B ST
174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN

Line 246: AR_PAYMENT_SCHEDULES_ALL PAY_SCH

242: PAY_SCH.CLASS PAY_SCH_CLASS
243: FROM
244: RA_CUSTOMER_TRX_ALL RACTRX,
245: RA_CUST_TRX_TYPES_ALL RATRXTYPE,
246: AR_PAYMENT_SCHEDULES_ALL PAY_SCH
247: WHERE
248: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
249: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
250: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) orig_arv

Line 258: AR_PAYMENT_SCHEDULES_ALL PAY_SCH

254: PAY_SCH.CLASS PAY_SCH_CLASS
255: FROM
256: RA_CUSTOMER_TRX_ALL RACTRX,
257: RA_CUST_TRX_TYPES_ALL RATRXTYPE,
258: AR_PAYMENT_SCHEDULES_ALL PAY_SCH
259: WHERE
260: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
261: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
262: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv

Line 335: FROM AR_PAYMENT_SCHEDULES_ALL PS,

331: ST.SEL_ID SEL_ID,
332: PS.CLASS CLASS ,
333: SM.ID STREAM_TYPE_ID,
334: PS.STATUS STATUS
335: FROM AR_PAYMENT_SCHEDULES_ALL PS,
336: OKL_CNSLD_AR_STRMS_B ST,
337: OKL_CNSLD_AR_HDRS_B HD,
338: OKC_K_HEADERS_ALL_B CN,
339: OKL_CNSLD_AR_LINES_B LN,

Line 360: FROM AR_PAYMENT_SCHEDULES_ALL PS,

356: ST.SEL_ID SEL_ID,
357: PS.CLASS CLASS ,
358: SM.ID STREAM_TYPE_ID,
359: PS.STATUS STATUS
360: FROM AR_PAYMENT_SCHEDULES_ALL PS,
361: OKL_CNSLD_AR_STRMS_B ST,
362: OKL_CNSLD_AR_HDRS_B HD,
363: OKC_K_HEADERS_ALL_B CN,
364: OKL_CNSLD_AR_LINES_B LN,

Line 553: , ar_payment_schedules_all ps

549: , okl_cnsld_ar_lines_b lln
550: , okl_pool_contents_v pk
551: -- , okl_pools_v pol
552: , okl_pools pol
553: , ar_payment_schedules_all ps
554: , okl_strm_elements_v sel
555: where cnr.id = l_consolidated_invoice_id
556: and lln.cnr_id = cnr.id
557: and lsm.lln_id = lln.id