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 729: FROM okl_trx_types_b trx_b

725: SELECT qte.quote_number quote_number,
726: qte.date_accepted quote_accepted_date,
727: qte.qtp_code quote_type
728:
729: FROM okl_trx_types_b trx_b
730: ,okl_trx_contracts_all rel_trx
731: ,okl_trx_quotes_all_b qte
732: ,okl_txl_quote_lines_b qtl
733: WHERE trx_b.trx_type_class = 'TERMINATION'

Line 986: ,okl_trx_types_b try

982: ,try.accounting_event_class_code accounting_event_class_code
983: ,try.id try_id
984: ,tcn_type tcn_type
985: FROM okl_trx_contracts_all tcn
986: ,okl_trx_types_b try
987: WHERE tcn.id = p_source_id
988: AND tcn.try_id = try.id
989: AND try.accounting_event_class_code IS NOT NULL;
990: l_tcn_basic_csr_rec c_tcn_basic_csr%ROWTYPE;

Line 1014: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;

1010: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
1011: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
1012: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
1013: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
1014: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
1015: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;
1016: l_rent_ia_chr_id okc_k_headers_all_b.id%TYPE;
1017: l_res_ia_chr_id okc_k_headers_all_b.id%TYPE;
1018: l_master_lease_id okc_k_headers_all_b.id%TYPE;

Line 1645: ,okl_trx_types_b try

1641: ,tcn.set_of_books_id ledger_id
1642: ,try.accounting_event_class_code
1643: FROM okl_txl_cntrct_lns_all tcl
1644: ,okl_trx_contracts_all tcn
1645: ,okl_trx_types_b try
1646: WHERE tcl.id = p_source_id
1647: AND tcl.tcn_id = tcn.id
1648: AND try.id = tcn.try_id
1649: AND try.accounting_event_class_code IS NOT NULL;

Line 2207: ,okl_trx_types_b try

2203: ,tcn.khr_id khr_id
2204: ,tcn.set_of_books_id ledger_id
2205: ,try.accounting_event_class_code accounting_event_class_code
2206: FROM okl_trx_contracts_all tcn
2207: ,okl_trx_types_b try
2208: WHERE tcn.id = p_tcn_id
2209: AND tcn.try_id = try.id
2210: AND try.accounting_event_class_code IS NOT NULL;
2211: l_tcn_basic_csr_rec c_tcn_basic_csr%ROWTYPE;