[Home] [Help]
641: FROM okl_trx_contracts_all trx
642: ,okl_txl_cntrct_lns_all txl
643: ,okl_trns_acc_dstrs_all dist
644: ,okl_trx_types_v try
645: ,okl_strm_type_v sty
646: ,okc_k_headers_all_b chr
647: ,okl_k_headers khr
648: ,okl_products pdt
649: ,okl_ae_tmpt_sets_all aes
753: FROM okl_trx_contracts_all trx
754: ,okl_txl_cntrct_lns_all txl
755: ,okl_trns_acc_dstrs_all dist
756: ,okl_trx_types_v try
757: ,okl_strm_type_v sty
758: ,okc_k_headers_all_b chr
759: ,okl_k_headers khr
760: ,okl_products pdt
761: ,okl_ae_tmpt_sets_all aes
873: FROM okl_trx_contracts_all trx
874: ,okl_txl_cntrct_lns_all txl
875: ,okl_trns_acc_dstrs_all dist
876: ,okl_trx_types_v try
877: ,okl_strm_type_v sty
878: ,okc_k_headers_all_b chr
879: ,okl_k_headers khr
880: ,okl_products pdt
881: ,okl_ae_tmpt_sets_all aes
1016: FROM okl_trx_contracts_all trx
1017: ,okl_txl_cntrct_lns_all txl
1018: ,okl_trns_acc_dstrs_all dist
1019: ,okl_trx_types_v try
1020: ,okl_strm_type_v sty
1021: ,okc_k_headers_all_b chr
1022: ,okl_k_headers khr
1023: ,okl_products pdt
1024: ,okl_ae_tmpt_sets_all aes
1263: ,okl_products pdt
1264: ,okl_ae_tmpt_sets_all aes
1265: ,okl_st_gen_tmpt_sets_all gts
1266: ,okl_trx_types_v try
1267: ,okl_strm_type_v sty
1268: -- OLM Reconciliation Report Entities
1269: ,okl_reports_b rep
1270: ,okl_report_trx_params rtryp
1271: ,okl_rep_products_gt pdt_gt
1383: ,okl_products pdt
1384: ,okl_ae_tmpt_sets_all aes
1385: ,okl_st_gen_tmpt_sets_all gts
1386: ,okl_trx_types_v try
1387: ,okl_strm_type_v sty
1388: -- AR Tables
1389: ,ra_customer_trx_lines_all rcl
1390: ,ra_customer_trx_all rct
1391: ,ra_cust_trx_line_gl_dist_all rad
1507: ,okl_products pdt
1508: ,okl_ae_tmpt_sets_all aes
1509: ,okl_st_gen_tmpt_sets_all gts
1510: ,okl_trx_types_v try
1511: ,okl_strm_type_v sty
1512: -- AR Tables
1513: ,ra_customer_trx_lines_all rcl
1514: ,ra_customer_trx_all rct
1515: ,ra_cust_trx_line_gl_dist_all rad
1658: ,okl_products pdt
1659: ,okl_ae_tmpt_sets_all aes
1660: ,okl_st_gen_tmpt_sets_all gts
1661: ,okl_trx_types_v try
1662: ,okl_strm_type_v sty
1663: -- AR Tables
1664: ,ra_customer_trx_lines_all rcl
1665: ,ra_customer_trx_all rct
1666: ,ra_cust_trx_line_gl_dist_all rad
1914: ,okl_products pdt
1915: ,okl_ae_tmpt_sets_all aes
1916: ,okl_st_gen_tmpt_sets_all gts
1917: ,okl_trx_types_v try
1918: ,okl_strm_type_v sty
1919: -- OLM Reconciliation Report Entities
1920: ,okl_reports_b rep
1921: ,okl_report_trx_params rtryp
1922: ,okl_rep_products_gt pdt_gt
2015: ,okl_products pdt
2016: ,okl_ae_tmpt_sets_all aes
2017: ,okl_st_gen_tmpt_sets_all gts
2018: ,okl_trx_types_v try
2019: ,okl_strm_type_v sty
2020: -- AR Tables
2021: ,ar_adjustments_all radj
2022: -- XLA Tables
2023: ,xla_events xe
2135: ,okl_products pdt
2136: ,okl_ae_tmpt_sets_all aes
2137: ,okl_st_gen_tmpt_sets_all gts
2138: ,okl_trx_types_v try
2139: ,okl_strm_type_v sty
2140: -- AR Tables
2141: ,ar_adjustments_all radj
2142: ,ar_distributions_all rdist
2143: -- OLM Reconciliation Report Entities
2285: ,okl_products pdt
2286: ,okl_ae_tmpt_sets_all aes
2287: ,okl_st_gen_tmpt_sets_all gts
2288: ,okl_trx_types_v try
2289: ,okl_strm_type_v sty
2290: -- AR Tables
2291: ,ar_adjustments_all radj
2292: ,ar_distributions_all rdist
2293: -- OLM Reconciliation Report Entities
2531: ,okl_products pdt
2532: ,okl_ae_tmpt_sets_all aes
2533: ,okl_st_gen_tmpt_sets_all gts
2534: ,okl_trx_types_v try
2535: ,okl_strm_type_v sty
2536: -- OLM Reconciliation Report Entities
2537: ,okl_reports_b rep
2538: ,okl_report_trx_params rtryp
2539: ,okl_rep_products_gt pdt_gt
2648: ,okl_products pdt
2649: ,okl_ae_tmpt_sets_all aes
2650: ,okl_st_gen_tmpt_sets_all gts
2651: ,okl_trx_types_v try
2652: ,okl_strm_type_v sty
2653: -- AP Tables
2654: ,ap_invoices_all inv
2655: ,ap_invoice_lines_all lin
2656: ,ap_invoice_distributions_all invdist
2782: ,okl_products pdt
2783: ,okl_ae_tmpt_sets_all aes
2784: ,okl_st_gen_tmpt_sets_all gts
2785: ,okl_trx_types_v try
2786: ,okl_strm_type_v sty
2787: -- AP Tables
2788: ,ap_invoices_all inv
2789: ,ap_invoice_lines_all lin
2790: ,ap_invoice_distributions_all invdist
2943: ,okl_products pdt
2944: ,okl_ae_tmpt_sets_all aes
2945: ,okl_st_gen_tmpt_sets_all gts
2946: ,okl_trx_types_v try
2947: ,okl_strm_type_v sty
2948: -- AP Tables
2949: ,ap_invoices_all inv
2950: ,ap_invoice_lines_all lin
2951: ,ap_invoice_distributions_all invdist
3166: SELECT stm.khr_id khr_id
3167: ,SUM(se.amount) unbilled_amount
3168: FROM okl_streams_rep_v stm
3169: ,okl_strm_elements se
3170: ,okl_strm_type_v sty
3171: WHERE
3172: stm.khr_id = p_khr_id
3173: AND se.stm_id = stm.id
3174: AND sty.id = stm.sty_id
4016: ,okl_trns_acc_dstrs_all dist
4017: ,okl_txl_cntrct_lns_all txl
4018: ,okl_trx_contracts_all trx
4019: ,okl_trx_types_v try
4020: ,okl_strm_type_v sty
4021: ,okc_k_headers_all_b chr
4022: ,okl_k_headers khr
4023: ,okl_products pdt
4024: ,okl_ae_tmpt_sets_all aes
4244: ,okl_products pdt
4245: ,okl_ae_tmpt_sets_all aes
4246: ,okl_st_gen_tmpt_sets_all gts
4247: ,okl_trx_types_v try
4248: ,okl_strm_type_v sty
4249: -- To fetch Names
4250: ,hr_operating_units ou
4251: ,gl_ledgers ledger
4252: ,fnd_application_vl app
4467: ,okl_products pdt
4468: ,okl_ae_tmpt_sets_all aes
4469: ,okl_st_gen_tmpt_sets_all gts
4470: ,okl_trx_types_v try
4471: ,okl_strm_type_v sty
4472: -- To fetch Names
4473: ,hr_operating_units ou
4474: ,gl_ledgers ledger
4475: ,fnd_application_vl app
4689: ,okl_products pdt
4690: ,okl_ae_tmpt_sets_all aes
4691: ,okl_st_gen_tmpt_sets_all gts
4692: ,okl_trx_types_v try
4693: ,okl_strm_type_v sty
4694: -- To fetch Names
4695: ,hr_operating_units ou
4696: ,gl_ledgers ledger
4697: ,fnd_application_vl app
6008: CURSOR C_ALL_ACCRUABLE_STREAMS (p_pdt_id NUMBER)
6009: IS
6010: SELECT styy.id STY_ID
6011: FROM OKL_PROD_STRM_TYPES PSYY,
6012: OKL_STRM_TYPE_V STYY
6013: WHERE psyy.sty_id = styy.id
6014: AND psyy.accrual_yn = 'Y'
6015: AND psyy.pdt_id = p_pdt_id;
6016:
6064: AND period_type = (SELECT gl.accounted_period_type
6065: FROM gl_ledgers gl
6066: WHERE ledger_id = p_ledger_id)
6067: ) STREAM_PERIOD
6068: FROM OKL_STRM_TYPE_V STY,
6069: okl_streams_rep_v STM,
6070: OKL_STRM_ELEMENTS STE,
6071: OKC_K_HEADERS_ALL_B KHR,
6072: OKL_K_HEADERS KH,
6083: AND KH.PDT_ID = PRO.ID
6084: AND KHR.ORG_ID = OU.ORGANIZATION_ID
6085: AND STY.ID IN ( SELECT styy.id
6086: FROM OKL_PROD_STRM_TYPES PSYY,
6087: OKL_STRM_TYPE_V STYY
6088: WHERE psyy.sty_id = sty.id
6089: AND psyy.accrual_yn = 'Y'
6090: and psyy.pdt_id = KH.PDT_ID
6091: UNION
6095: )
6096: and KH.ID = p_khr_id
6097: AND STM.ID IN ( SELECT MAX(ID)
6098: FROM ( SELECT STM.STY_ID, STM.ID, MAX(DATE_CURRENT)
6099: FROM OKL_STRM_TYPE_V STY,
6100: okl_streams_rep_v STM,
6101: OKL_STRM_ELEMENTS STE,
6102: OKC_K_HEADERS_ALL_B KHR,
6103: OKL_K_HEADERS KH,
6152: AND period_type = (SELECT gl.accounted_period_type
6153: FROM gl_ledgers gl
6154: WHERE ledger_id = p_ledger_id)
6155: ) STREAM_PERIOD
6156: FROM OKL_STRM_TYPE_V STY,
6157: okl_streams_rep_v STM,
6158: OKL_STRM_ELEMENTS STE,
6159: OKC_K_HEADERS_ALL_B KHR,
6160: OKL_K_HEADERS KH,
6171: AND KH.PDT_ID = PRO.ID
6172: AND KHR.ORG_ID = OU.ORGANIZATION_ID
6173: AND STY.ID IN ( SELECT styy.id
6174: FROM OKL_PROD_STRM_TYPES PSYY,
6175: OKL_STRM_TYPE_V STYY
6176: WHERE psyy.sty_id = sty.id
6177: AND psyy.accrual_yn = 'Y'
6178: and psyy.pdt_id = KH.PDT_ID
6179: UNION
6183: )
6184: and KH.ID = p_khr_id
6185: AND STM.ID IN ( SELECT MAX(ID)
6186: FROM ( SELECT STM.STY_ID, STM.ID, MAX(DATE_CURRENT)
6187: FROM OKL_STRM_TYPE_V STY,
6188: okl_streams_rep_v STM,
6189: OKL_STRM_ELEMENTS STE,
6190: OKC_K_HEADERS_ALL_B KHR,
6191: OKL_K_HEADERS KH,
6253: NULL REVERSAL_PERIOD
6254: FROM OKL_TRX_CONTRACTS_ALL TCN,
6255: OKL_TXL_CNTRCT_LNS_ALL TCL,
6256: OKL_TRX_TYPES_V TTY,
6257: OKL_STRM_TYPE_V STY,
6258: HR_OPERATING_UNITS OU,
6259: OKC_K_LINES_V CLE
6260: WHERE TCN.ID = TCL.TCN_ID
6261: AND TCN.TRY_ID = TTY.ID
6324: ) REVERSAL_PERIOD
6325: FROM OKL_TRX_CONTRACTS_ALL TCN,
6326: OKL_TXL_CNTRCT_LNS_ALL TCL,
6327: OKL_TRX_TYPES_V TTY,
6328: OKL_STRM_TYPE_V STY,
6329: HR_OPERATING_UNITS OU,
6330: OKC_K_LINES_V CLE
6331: WHERE TCN.ID = TCL.TCN_ID
6332: AND TCN.TRY_ID = TTY.ID
6375: c.Sty_Id Sty_Id,
6376: ce.se_Line_Number line_number
6377: FROM okl_streams_rep_v c,
6378: okl_streams_rep_v p,
6379: Okl_strm_Type_v st,
6380: Okl_strm_Elements ce,
6381: Okl_strm_Elements pe,
6382: Okc_k_Headers_All_b khr,
6383: Okc_k_lines_v kle,
7209: ,okl_trns_acc_dstrs_all dist
7210: ,okl_txl_cntrct_lns_all txl
7211: ,okl_trx_contracts_all trx
7212: ,okl_trx_types_v try
7213: ,okl_strm_type_v sty
7214: ,okc_k_headers_all_b chr
7215: ,okl_k_headers khr
7216: ,okl_products pdt
7217: ,okl_ae_tmpt_sets_all aes