440: jot.where_clause,
441: jot.from_table
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
454: and stl.scs_code = b_scs_code;
455:
456:
457: TYPE line_style_rec_type IS RECORD(
458: lty_code okc_line_styles_v.lty_code%type,
459: priced_yn okc_line_styles_v.priced_yn%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,
455:
456:
457: TYPE line_style_rec_type IS RECORD(
458: lty_code okc_line_styles_v.lty_code%type,
459: priced_yn okc_line_styles_v.priced_yn%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,
456:
457: TYPE line_style_rec_type IS RECORD(
458: lty_code okc_line_styles_v.lty_code%type,
459: priced_yn okc_line_styles_v.priced_yn%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,
457: TYPE line_style_rec_type IS RECORD(
458: lty_code okc_line_styles_v.lty_code%type,
459: priced_yn okc_line_styles_v.priced_yn%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,
458: lty_code okc_line_styles_v.lty_code%type,
459: priced_yn okc_line_styles_v.priced_yn%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
459: priced_yn okc_line_styles_v.priced_yn%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