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.OKC_OC_INT_KTQ_PVT dependencies on JTF_OBJECTS_B

Line 295: jtf_objects_b jot

291: ,cpt.name prod_name
292: ,cim.jtot_object1_code item_source_code
293: ,jot.from_table item_source_table
294: FROM
295: jtf_objects_b jot
296: ,okc_k_lines_b cle
297: ,okc_k_items cim
298: ,okc_line_styles_b lse
299: ,okc_line_style_sources lss

Line 353: FROM jtf_objects_b jot

349: ,cim.object1_id2 id2
350: ,sit.name prod_name
351: ,cim.jtot_object1_code
352: ,jot.from_table
353: FROM jtf_objects_b jot
354: ,okc_k_lines_b cle
355: ,okc_k_items cim
356: ,okc_line_styles_b lse
357: ,okc_line_style_sources lss

Line 446: jtf_objects_b jot

442: -- stl.seeded_flag
443: from okc_subclass_top_line stl,
444: okc_line_styles_v lse,
445: okc_line_style_sources lss,
446: jtf_objects_b jot
447: where
448: jot.object_code = lss.jtot_object_code
449: and lss.lse_id = lse.id
450: and sysdate between lss.start_date and nvl(lss.end_date,sysdate)

Line 464: object_code jtf_objects_b.object_code%type,

460: item_to_price_yn okc_line_styles_v.item_to_price_yn%type,
461: price_basis_yn okc_line_styles_v.price_basis_yn%type,
462: lse_id okc_line_styles_v.id%type,
463: lse_name okc_line_styles_v.name%type,
464: object_code jtf_objects_b.object_code%type,
465: where_clause jtf_objects_b.where_clause%type,
466: from_table jtf_objects_b.from_table%type
467: -- seeded_flag okc_subclass_top_line.seeded_flag%TYPE
468: );

Line 465: where_clause jtf_objects_b.where_clause%type,

461: price_basis_yn okc_line_styles_v.price_basis_yn%type,
462: lse_id okc_line_styles_v.id%type,
463: lse_name okc_line_styles_v.name%type,
464: object_code jtf_objects_b.object_code%type,
465: where_clause jtf_objects_b.where_clause%type,
466: from_table jtf_objects_b.from_table%type
467: -- seeded_flag okc_subclass_top_line.seeded_flag%TYPE
468: );
469:

Line 466: from_table jtf_objects_b.from_table%type

462: lse_id okc_line_styles_v.id%type,
463: lse_name okc_line_styles_v.name%type,
464: object_code jtf_objects_b.object_code%type,
465: where_clause jtf_objects_b.where_clause%type,
466: from_table jtf_objects_b.from_table%type
467: -- seeded_flag okc_subclass_top_line.seeded_flag%TYPE
468: );
469:
470: TYPE line_style_tab IS TABLE OF line_style_rec_type INDEX BY BINARY_INTEGER;

Line 576: ,line_source_table jtf_objects_b.from_table%TYPE

572: --
573: ,line_style okc_line_styles_b.lse_type%TYPE
574: ,line_type okc_line_styles_b.lty_code%TYPE
575: ,line_source_code okc_line_style_sources.jtot_object_code%TYPE
576: ,line_source_table jtf_objects_b.from_table%TYPE
577: --
578: ,item_source_code okc_k_items.jtot_object1_code%TYPE
579: ,item_source_table jtf_objects_b.from_table%TYPE
580: );

Line 579: ,item_source_table jtf_objects_b.from_table%TYPE

575: ,line_source_code okc_line_style_sources.jtot_object_code%TYPE
576: ,line_source_table jtf_objects_b.from_table%TYPE
577: --
578: ,item_source_code okc_k_items.jtot_object1_code%TYPE
579: ,item_source_table jtf_objects_b.from_table%TYPE
580: );
581:
582: TYPE line_info_tab_typ IS TABLE OF line_info_rec_typ INDEX BY BINARY_INTEGER;
583: TYPE line_info_ren_typ_dnr IS TABLE OF okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;

Line 604: ,line_source_code jtf_objects_b.object_code%TYPE

600: ,end_date okc_k_lines_b.end_date%TYPE
601: --
602: ,line_style okc_line_styles_b.lse_type%TYPE
603: ,line_type okc_line_styles_b.lty_code%TYPE
604: ,line_source_code jtf_objects_b.object_code%TYPE
605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --
607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE

Line 605: ,line_source_table jtf_objects_b.from_table%TYPE

601: --
602: ,line_style okc_line_styles_b.lse_type%TYPE
603: ,line_type okc_line_styles_b.lty_code%TYPE
604: ,line_source_code jtf_objects_b.object_code%TYPE
605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --
607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE
609: ,prod_name okx_system_items_v.name%TYPE

Line 610: ,item_source_code jtf_objects_b.object_code%TYPE

606: --
607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE
609: ,prod_name okx_system_items_v.name%TYPE
610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE
612: --
613: ,svc_duration okx_quote_line_detail_v.service_duration%TYPE
614: ,svc_period okx_quote_line_detail_v.service_period%TYPE

Line 611: ,item_source_table jtf_objects_b.from_table%TYPE

607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE
609: ,prod_name okx_system_items_v.name%TYPE
610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE
612: --
613: ,svc_duration okx_quote_line_detail_v.service_duration%TYPE
614: ,svc_period okx_quote_line_detail_v.service_period%TYPE
615: );

Line 1573: jtf_objects_b jot,

1569: okc_k_lines_v cle,
1570: okc_k_items cim,
1571: okc_line_styles_b lse,
1572: okc_line_style_sources lss,
1573: jtf_objects_b jot,
1574: jtf_objects_b jot2,
1575: okc_statuses_b sts,
1576: -- okx_system_items_v sit,
1577: okx_config_items_v cfg

Line 1574: jtf_objects_b jot2,

1570: okc_k_items cim,
1571: okc_line_styles_b lse,
1572: okc_line_style_sources lss,
1573: jtf_objects_b jot,
1574: jtf_objects_b jot2,
1575: okc_statuses_b sts,
1576: -- okx_system_items_v sit,
1577: okx_config_items_v cfg
1578: WHERE