APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TRX_TYPES_B

Line 244: ,okl_trx_types_b try_b

240: IS
241: SELECT try_tl.NAME transaction_type_name
242: ,try_b.trx_type_class trx_type_class_code
243: FROM okl_trx_types_tl try_tl
244: ,okl_trx_types_b try_b
245: WHERE try_tl.id = p_try_id
246: AND TRY_B.ID = try_tl.id
247: AND try_tl.language = p_led_lang;
248:

Line 709: FROM okl_trx_types_b trx_b

705: IS
706: SELECT qte.quote_number quote_number
707: ,qte.date_accepted quote_accepted_date
708: ,qte.qtp_code quote_type
709: FROM okl_trx_types_b trx_b
710: ,okl_trx_contracts_all rel_trx
711: ,okl_trx_quotes_all_b qte
712: WHERE trx_b.trx_type_class = 'RE_LEASE'
713: AND trx_b.id = rel_trx.try_id

Line 959: ,okl_trx_types_b try

955: ,try.accounting_event_class_code accounting_event_class_code
956: ,try.id try_id
957: ,tcn_type tcn_type
958: FROM okl_trx_contracts_all tcn
959: ,okl_trx_types_b try
960: WHERE tcn.id = p_source_id
961: AND tcn.try_id = try.id
962: AND try.accounting_event_class_code IS NOT NULL;
963: l_tcn_basic_csr_rec c_tcn_basic_csr%ROWTYPE;

Line 987: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;

983: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
984: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
985: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
986: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
987: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
988: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;
989: l_rent_ia_chr_id okc_k_headers_all_b.id%TYPE;
990: l_res_ia_chr_id okc_k_headers_all_b.id%TYPE;
991: l_master_lease_id okc_k_headers_all_b.id%TYPE;

Line 1618: ,okl_trx_types_b try

1614: ,tcn.set_of_books_id ledger_id
1615: ,try.accounting_event_class_code
1616: FROM okl_txl_cntrct_lns_all tcl
1617: ,okl_trx_contracts_all tcn
1618: ,okl_trx_types_b try
1619: WHERE tcl.id = p_source_id
1620: AND tcl.tcn_id = tcn.id
1621: AND try.id = tcn.try_id
1622: AND try.accounting_event_class_code IS NOT NULL;

Line 2180: ,okl_trx_types_b try

2176: ,tcn.khr_id khr_id
2177: ,tcn.set_of_books_id ledger_id
2178: ,try.accounting_event_class_code accounting_event_class_code
2179: FROM okl_trx_contracts_all tcn
2180: ,okl_trx_types_b try
2181: WHERE tcn.id = p_tcn_id
2182: AND tcn.try_id = try.id
2183: AND try.accounting_event_class_code IS NOT NULL;
2184: l_tcn_basic_csr_rec c_tcn_basic_csr%ROWTYPE;