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_TXL_ITM_INSTS_PVT dependencies on OKC_LINE_STYLES_B

Line 968: okc_line_styles_b style,

964: CURSOR ff1_csr (p_chr_id IN NUMBER,
965: p_line_id IN NUMBER) IS
966: SELECT line.id asset_id
967: FROM okc_k_lines_b line,
968: okc_line_styles_b style,
969: okc_statuses_b sts
970: WHERE line.lse_id = style.id
971: AND style.lty_code = 'FREE_FORM1'
972: AND line.dnz_chr_id = p_chr_id

Line 981: okc_line_styles_b style,

977: CURSOR check_item_csr (p_line_id IN NUMBER) IS
978: SELECT mtl.serial_number_control_code,
979: mtl.description item_desc
980: FROM okc_k_lines_b line,
981: okc_line_styles_b style,
982: okc_k_items kitem,
983: mtl_system_items mtl
984: WHERE line.lse_id = style.id
985: AND style.lty_code = 'ITEM'

Line 996: okc_line_styles_b ff2style,

992: CURSOR inst_csr (p_asset_id IN NUMBER) IS
993: SELECT inst.id inst_id
994: FROM okc_k_lines_b ff2,
995: okc_k_lines_b inst,
996: okc_line_styles_b ff2style,
997: okc_line_styles_b inststyle,
998: okl_txl_itm_insts txl
999: WHERE ff2.lse_id = ff2style.id
1000: AND ff2style.lty_code = 'FREE_FORM2'

Line 997: okc_line_styles_b inststyle,

993: SELECT inst.id inst_id
994: FROM okc_k_lines_b ff2,
995: okc_k_lines_b inst,
996: okc_line_styles_b ff2style,
997: okc_line_styles_b inststyle,
998: okl_txl_itm_insts txl
999: WHERE ff2.lse_id = ff2style.id
1000: AND ff2style.lty_code = 'FREE_FORM2'
1001: AND ff2.id = inst.cle_id