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 168: from AR_PAYMENT_SCHEDULES_ALL PS

164: ,HD.id
165: ,HD.consolidated_invoice_number
166: ,sum(PS.amount_due_remaining) amount_due_remaining
167: ,PS.due_date
168: from AR_PAYMENT_SCHEDULES_ALL PS
169: ,OKL_CNSLD_AR_STRMS_B ST
170: ,OKL_CNSLD_AR_HDRS_B HD
171: ,OKC_K_HEADERS_ALL_B CN
172: ,OKL_CNSLD_AR_LINES_B LN

Line 241: AR_PAYMENT_SCHEDULES_ALL PAY_SCH

237: PAY_SCH.CLASS PAY_SCH_CLASS
238: FROM
239: RA_CUSTOMER_TRX_ALL RACTRX,
240: RA_CUST_TRX_TYPES_ALL RATRXTYPE,
241: AR_PAYMENT_SCHEDULES_ALL PAY_SCH
242: WHERE
243: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
244: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
245: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) orig_arv

Line 253: AR_PAYMENT_SCHEDULES_ALL PAY_SCH

249: PAY_SCH.CLASS PAY_SCH_CLASS
250: FROM
251: RA_CUSTOMER_TRX_ALL RACTRX,
252: RA_CUST_TRX_TYPES_ALL RATRXTYPE,
253: AR_PAYMENT_SCHEDULES_ALL PAY_SCH
254: WHERE
255: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
256: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
257: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv

Line 330: FROM AR_PAYMENT_SCHEDULES_ALL PS,

326: ST.SEL_ID SEL_ID,
327: PS.CLASS CLASS ,
328: SM.ID STREAM_TYPE_ID,
329: PS.STATUS STATUS
330: FROM AR_PAYMENT_SCHEDULES_ALL PS,
331: OKL_CNSLD_AR_STRMS_B ST,
332: OKL_CNSLD_AR_HDRS_B HD,
333: OKC_K_HEADERS_ALL_B CN,
334: OKL_CNSLD_AR_LINES_B LN,

Line 355: FROM AR_PAYMENT_SCHEDULES_ALL PS,

351: ST.SEL_ID SEL_ID,
352: PS.CLASS CLASS ,
353: SM.ID STREAM_TYPE_ID,
354: PS.STATUS STATUS
355: FROM AR_PAYMENT_SCHEDULES_ALL PS,
356: OKL_CNSLD_AR_STRMS_B ST,
357: OKL_CNSLD_AR_HDRS_B HD,
358: OKC_K_HEADERS_ALL_B CN,
359: OKL_CNSLD_AR_LINES_B LN,

Line 548: , ar_payment_schedules_all ps

544: , okl_cnsld_ar_lines_b lln
545: , okl_pool_contents_v pk
546: -- , okl_pools_v pol
547: , okl_pools pol
548: , ar_payment_schedules_all ps
549: , okl_strm_elements_v sel
550: where cnr.id = l_consolidated_invoice_id
551: and lln.cnr_id = cnr.id
552: and lsm.lln_id = lln.id