eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REPORT_GENERATOR_PVT dependencies on HR_OPERATING_UNITS

Line 66: ,hr_operating_units ou

62: HAVING MIN(bkg_trx.transaction_date ) < p_end_date
63: ) a
64: ,okc_k_headers_all_b CHR
65: ,okl_k_headers KHR
66: ,hr_operating_units ou
67: WHERE
68: a.contract_id = CHR.id
69: AND KHR.ID = CHR.ID
70: AND ou.organization_id = chr.authoring_org_id

Line 655: ,hr_operating_units ou

651: ,okl_reports_b rep
652: ,okl_report_trx_params rtryp
653: ,okl_rep_products_gt pdt_gt
654: -- To fetch Names
655: ,hr_operating_units ou
656: ,xle_entity_profiles le
657: ,gl_ledgers_v ledger
658: WHERE trx.id = txl.tcn_id
659: AND trx.try_id = try.id

Line 767: ,hr_operating_units ou

763: ,okl_reports_b rep
764: ,okl_report_trx_params rtryp
765: ,okl_rep_products_gt pdt_gt
766: -- To fetch Names
767: ,hr_operating_units ou
768: ,xle_entity_profiles le
769: ,gl_ledgers_v ledger
770: -- XLA Entities
771: ,xla_events xe

Line 895: ,hr_operating_units ou

891: ,okl_report_trx_params rtryp
892: ,okl_rep_products_gt pdt_gt
893: -- To fetch Names
894: ,gl_code_combinations_kfv glcc
895: ,hr_operating_units ou
896: ,xle_entity_profiles le
897: ,gl_ledgers_v ledger
898: WHERE trx.id = txl.tcn_id
899: AND trx.try_id = try.id

Line 1042: ,hr_operating_units ou

1038: ,okl_report_trx_params rtryp
1039: ,okl_rep_products_gt pdt_gt
1040: -- To fetch Names
1041: ,gl_code_combinations_kfv glcc
1042: ,hr_operating_units ou
1043: ,xle_entity_profiles le
1044: ,gl_ledgers_v ledger
1045: WHERE trx.id = txl.tcn_id
1046: AND trx.try_id = try.id

Line 1273: ,hr_operating_units ou

1269: ,okl_reports_b rep
1270: ,okl_report_trx_params rtryp
1271: ,okl_rep_products_gt pdt_gt
1272: -- To fetch Names
1273: ,hr_operating_units ou
1274: ,xle_entity_profiles le
1275: ,gl_ledgers_v ledger
1276: WHERE -- OKL to AR Application Predicates
1277: txd.til_id_details = til.id -- Trx. Detail to Trx. Line

Line 1400: ,hr_operating_units ou

1396: ,okl_reports_b rep
1397: ,okl_report_trx_params rtryp
1398: ,okl_rep_products_gt pdt_gt
1399: -- To fetch Names
1400: ,hr_operating_units ou
1401: ,xle_entity_profiles le
1402: ,gl_ledgers_v ledger
1403: WHERE -- OKL to AR Application Predicates
1404: txd.til_id_details = til.id -- Trx. Detail to Trx. Line

Line 1527: ,hr_operating_units ou

1523: ,okl_reports_b rep
1524: ,okl_report_trx_params rtryp
1525: ,okl_rep_products_gt pdt_gt
1526: -- To fetch Names
1527: ,hr_operating_units ou
1528: ,xle_entity_profiles le
1529: ,gl_ledgers_v ledger
1530: WHERE -- OKL to AR Application Predicates
1531: txd.til_id_details = til.id -- Trx. Detail to Trx. Line

Line 1683: ,hr_operating_units ou

1679: ,okl_reports_b rep
1680: ,okl_report_trx_params rtryp
1681: ,okl_rep_products_gt pdt_gt
1682: -- To fetch Names
1683: ,hr_operating_units ou
1684: ,xle_entity_profiles le
1685: ,gl_ledgers_v ledger
1686: WHERE -- OKL to AR Application Predicates
1687: txd.til_id_details = til.id -- Trx. Detail to Trx. Line

Line 1924: ,hr_operating_units ou

1920: ,okl_reports_b rep
1921: ,okl_report_trx_params rtryp
1922: ,okl_rep_products_gt pdt_gt
1923: -- To fetch Names
1924: ,hr_operating_units ou
1925: ,gl_ledgers_v ledger
1926: WHERE -- OKL - AR Adjustment Application Predicates
1927: adj.id = ajl.adj_id
1928: AND ajl.til_id = til.id

Line 2030: ,hr_operating_units ou

2026: ,okl_reports_b rep
2027: ,okl_report_trx_params rtryp
2028: ,okl_rep_products_gt pdt_gt
2029: -- To fetch Names
2030: ,hr_operating_units ou
2031: ,gl_ledgers_v ledger
2032: WHERE -- OKL - AR Adjustment Application Predicates
2033: adj.id = ajl.adj_id
2034: AND ajl.til_id = til.id

Line 2148: ,hr_operating_units ou

2144: ,okl_reports_b rep
2145: ,okl_report_trx_params rtryp
2146: ,okl_rep_products_gt pdt_gt
2147: -- To fetch Names
2148: ,hr_operating_units ou
2149: ,gl_ledgers_v ledger
2150: -- XLA Tables
2151: ,xla_events xe
2152: ,xla_event_types_vl xvl

Line 2298: ,hr_operating_units ou

2294: ,okl_reports_b rep
2295: ,okl_report_trx_params rtryp
2296: ,okl_rep_products_gt pdt_gt
2297: -- To fetch Names
2298: ,hr_operating_units ou
2299: ,gl_ledgers_v ledger
2300: -- XLA Tables
2301: ,xla_events xe
2302: ,xla_event_types_vl xvl

Line 2541: ,hr_operating_units ou

2537: ,okl_reports_b rep
2538: ,okl_report_trx_params rtryp
2539: ,okl_rep_products_gt pdt_gt
2540: -- To fetch Names
2541: ,hr_operating_units ou
2542: ,xle_entity_profiles le
2543: ,gl_ledgers_v ledger
2544: WHERE
2545: -- OKL to AP Application Predicates

Line 2665: ,hr_operating_units ou

2661: ,okl_reports_b rep
2662: ,okl_report_trx_params rtryp
2663: ,okl_rep_products_gt pdt_gt
2664: -- To fetch Names
2665: ,hr_operating_units ou
2666: ,xle_entity_profiles le
2667: ,gl_ledgers_v ledger
2668: WHERE
2669: -- OKL to AP Application Predicates

Line 2802: ,hr_operating_units ou

2798: ,okl_reports_b rep
2799: ,okl_report_trx_params rtryp
2800: ,okl_rep_products_gt pdt_gt
2801: -- To fetch Names
2802: ,hr_operating_units ou
2803: ,xle_entity_profiles le
2804: ,gl_ledgers_v ledger
2805: WHERE
2806: -- OKL to AP Application Predicates

Line 2967: ,hr_operating_units ou

2963: ,okl_reports_b rep
2964: ,okl_report_trx_params rtryp
2965: ,okl_rep_products_gt pdt_gt
2966: -- To fetch Names
2967: ,hr_operating_units ou
2968: ,xle_entity_profiles le
2969: ,gl_ledgers_v ledger
2970: WHERE
2971: -- OKL to AP Application Predicates

Line 4027: ,hr_operating_units ou

4023: ,okl_products pdt
4024: ,okl_ae_tmpt_sets_all aes
4025: ,okl_st_gen_tmpt_sets_all gts
4026: -- To fetch Names
4027: ,hr_operating_units ou
4028: ,gl_ledgers ledger
4029: ,fnd_application_vl app
4030: WHERE
4031: -- Restrict the Code Combinations to the one setup on the Report

Line 4250: ,hr_operating_units ou

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
4253: WHERE
4254: -- Restrict the Code Combinations to the one setup on the Report

Line 4473: ,hr_operating_units ou

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
4476: WHERE
4477: -- Restrict the Code Combinations to the one setup on the Report

Line 4695: ,hr_operating_units ou

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
4698: WHERE
4699: -- Restrict the Code Combinations to the one setup on the Report

Line 5843: FROM hr_operating_units hr

5839: CURSOR c_orgs_using_ledger_csr( p_ledger_id NUMBER )
5840: IS
5841: SELECT organization_id org_id
5842: ,NAME org_name
5843: FROM hr_operating_units hr
5844: WHERE hr.set_of_books_id = p_ledger_id;
5845: -----------------------------------------------------------------
5846: -- Declare Process Variable
5847: -----------------------------------------------------------------

Line 6075: HR_OPERATING_UNITS OU

6071: OKC_K_HEADERS_ALL_B KHR,
6072: OKL_K_HEADERS KH,
6073: OKC_K_LINES_V KLE,
6074: OKL_PRODUCTS_V PRO,
6075: HR_OPERATING_UNITS OU
6076: WHERE STY.ID = STM.STY_ID
6077: AND STM.ID = STE.STM_ID
6078: AND STM.KHR_ID = KHR.ID
6079: -- AND STM.ACTIVE_YN = 'Y'

Line 6106: HR_OPERATING_UNITS OU

6102: OKC_K_HEADERS_ALL_B KHR,
6103: OKL_K_HEADERS KH,
6104: OKC_K_LINES_V KLE,
6105: OKL_PRODUCTS_V PRO,
6106: HR_OPERATING_UNITS OU
6107: WHERE STY.ID = STM.STY_ID
6108: AND STM.ID = STE.STM_ID
6109: AND STM.KHR_ID = KHR.ID
6110: AND STM.DATE_CURRENT <= p_end_date

Line 6163: HR_OPERATING_UNITS OU

6159: OKC_K_HEADERS_ALL_B KHR,
6160: OKL_K_HEADERS KH,
6161: OKC_K_LINES_V KLE,
6162: OKL_PRODUCTS_V PRO,
6163: HR_OPERATING_UNITS OU
6164: WHERE STY.ID = STM.STY_ID
6165: AND STM.ID = STE.STM_ID
6166: AND STM.KHR_ID = KHR.ID
6167: -- AND STM.ACTIVE_YN = 'Y'

Line 6194: HR_OPERATING_UNITS OU

6190: OKC_K_HEADERS_ALL_B KHR,
6191: OKL_K_HEADERS KH,
6192: OKC_K_LINES_V KLE,
6193: OKL_PRODUCTS_V PRO,
6194: HR_OPERATING_UNITS OU
6195: WHERE STY.ID = STM.STY_ID
6196: AND STM.ID = STE.STM_ID
6197: AND STM.KHR_ID = KHR.ID
6198: AND STM.DATE_CURRENT <= p_end_date

Line 6258: HR_OPERATING_UNITS OU,

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
6262: AND TCL.STY_ID = STY.ID

Line 6329: HR_OPERATING_UNITS OU,

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
6333: AND TCL.KHR_ID = p_khr_id

Line 6384: hr_operating_units ou,

6380: Okl_strm_Elements ce,
6381: Okl_strm_Elements pe,
6382: Okc_k_Headers_All_b khr,
6383: Okc_k_lines_v kle,
6384: hr_operating_units ou,
6385: okl_products prod,
6386: okl_k_headers chr,
6387: okl_trx_contracts_all rbk_trx,
6388: okl_trx_contracts_all acc_trx,

Line 7220: ,hr_operating_units ou

7216: ,okl_products pdt
7217: ,okl_ae_tmpt_sets_all aes
7218: ,okl_st_gen_tmpt_sets_all gts
7219: -- To fetch Names
7220: ,hr_operating_units ou
7221: ,gl_ledgers ledger
7222: ,fnd_application_vl app
7223: ,okc_k_lines_v kle
7224: ,okl_report_trx_params trep