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.POS_PRODUCT_SERVICE_UTL_PKG dependencies on MTL_CATEGORIES_B

Line 30: segment1 mtl_categories_b.segment1%TYPE

26: TYPE product_segment_table IS
27: TABLE OF product_segment_record INDEX BY BINARY_INTEGER;
28:
29: TYPE category_segment_record IS RECORD (
30: segment1 mtl_categories_b.segment1%TYPE
31: , segment2 mtl_categories_b.segment2%TYPE
32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE

Line 31: , segment2 mtl_categories_b.segment2%TYPE

27: TABLE OF product_segment_record INDEX BY BINARY_INTEGER;
28:
29: TYPE category_segment_record IS RECORD (
30: segment1 mtl_categories_b.segment1%TYPE
31: , segment2 mtl_categories_b.segment2%TYPE
32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE

Line 32: , segment3 mtl_categories_b.segment3%TYPE

28:
29: TYPE category_segment_record IS RECORD (
30: segment1 mtl_categories_b.segment1%TYPE
31: , segment2 mtl_categories_b.segment2%TYPE
32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE

Line 33: , segment4 mtl_categories_b.segment4%TYPE

29: TYPE category_segment_record IS RECORD (
30: segment1 mtl_categories_b.segment1%TYPE
31: , segment2 mtl_categories_b.segment2%TYPE
32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE

Line 34: , segment5 mtl_categories_b.segment5%TYPE

30: segment1 mtl_categories_b.segment1%TYPE
31: , segment2 mtl_categories_b.segment2%TYPE
32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE

Line 35: , segment6 mtl_categories_b.segment6%TYPE

31: , segment2 mtl_categories_b.segment2%TYPE
32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE

Line 36: , segment7 mtl_categories_b.segment7%TYPE

32: , segment3 mtl_categories_b.segment3%TYPE
33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE

Line 37: , segment8 mtl_categories_b.segment8%TYPE

33: , segment4 mtl_categories_b.segment4%TYPE
34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE

Line 38: , segment9 mtl_categories_b.segment9%TYPE

34: , segment5 mtl_categories_b.segment5%TYPE
35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE

Line 39: , segment10 mtl_categories_b.segment10%TYPE

35: , segment6 mtl_categories_b.segment6%TYPE
36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE

Line 40: , segment11 mtl_categories_b.segment11%TYPE

36: , segment7 mtl_categories_b.segment7%TYPE
37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE

Line 41: , segment12 mtl_categories_b.segment12%TYPE

37: , segment8 mtl_categories_b.segment8%TYPE
38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE

Line 42: , segment13 mtl_categories_b.segment13%TYPE

38: , segment9 mtl_categories_b.segment9%TYPE
39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE

Line 43: , segment14 mtl_categories_b.segment14%TYPE

39: , segment10 mtl_categories_b.segment10%TYPE
40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE

Line 44: , segment15 mtl_categories_b.segment15%TYPE

40: , segment11 mtl_categories_b.segment11%TYPE
41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE
48: , segment19 mtl_categories_b.segment19%TYPE

Line 45: , segment16 mtl_categories_b.segment16%TYPE

41: , segment12 mtl_categories_b.segment12%TYPE
42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE
48: , segment19 mtl_categories_b.segment19%TYPE
49: , segment20 mtl_categories_b.segment20%TYPE

Line 46: , segment17 mtl_categories_b.segment17%TYPE

42: , segment13 mtl_categories_b.segment13%TYPE
43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE
48: , segment19 mtl_categories_b.segment19%TYPE
49: , segment20 mtl_categories_b.segment20%TYPE
50: );

Line 47: , segment18 mtl_categories_b.segment18%TYPE

43: , segment14 mtl_categories_b.segment14%TYPE
44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE
48: , segment19 mtl_categories_b.segment19%TYPE
49: , segment20 mtl_categories_b.segment20%TYPE
50: );
51:

Line 48: , segment19 mtl_categories_b.segment19%TYPE

44: , segment15 mtl_categories_b.segment15%TYPE
45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE
48: , segment19 mtl_categories_b.segment19%TYPE
49: , segment20 mtl_categories_b.segment20%TYPE
50: );
51:
52: -- private package constants

Line 49: , segment20 mtl_categories_b.segment20%TYPE

45: , segment16 mtl_categories_b.segment16%TYPE
46: , segment17 mtl_categories_b.segment17%TYPE
47: , segment18 mtl_categories_b.segment18%TYPE
48: , segment19 mtl_categories_b.segment19%TYPE
49: , segment20 mtl_categories_b.segment20%TYPE
50: );
51:
52: -- private package constants
53: g_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';

Line 668: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||

664: x_has_subcategory := 'N';
665: RETURN;
666: END IF;
667:
668: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||
669: ' mtl_category_set_valid_cats mcsvc, pos_sup_products_services psps where ' ||
670: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
671: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
672: ' and mcb.category_id = mcsvc.category_id ' ||

Line 772: l_segment_value mtl_categories_b.segment1%TYPE;

768: PROCEDURE get_concatenated_description (
769: p_segments IN category_segment_record
770: , x_description OUT NOCOPY VARCHAR2 )
771: IS
772: l_segment_value mtl_categories_b.segment1%TYPE;
773: l_parent_segment_value mtl_categories_b.segment1%TYPE;
774: l_result VARCHAR2(3000);
775: BEGIN
776: assert_init();

Line 773: l_parent_segment_value mtl_categories_b.segment1%TYPE;

769: p_segments IN category_segment_record
770: , x_description OUT NOCOPY VARCHAR2 )
771: IS
772: l_segment_value mtl_categories_b.segment1%TYPE;
773: l_parent_segment_value mtl_categories_b.segment1%TYPE;
774: l_result VARCHAR2(3000);
775: BEGIN
776: assert_init();
777: --dbms_output.put_line('count ' || g_product_segment_count);

Line 946: l_query := 'select psps.vendor_id, mcb.category_id from mtl_categories_b mcb, ' ||

942: IS
943: l_query VARCHAR2(4000);
944: BEGIN
945: assert_init();
946: l_query := 'select psps.vendor_id, mcb.category_id from mtl_categories_b mcb, ' ||
947: ' mtl_category_set_valid_cats mcsvc, pos_sup_products_services psps where ' ||
948: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
949: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
950: ' and mcb.category_id = mcsvc.category_id and (';

Line 1445: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||

1441: x_has_subcategory := 'N';
1442: RETURN;
1443: END IF;
1444:
1445: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||
1446: ' mtl_category_set_valid_cats mcsvc, pos_product_service_requests ppsr where ' ||
1447: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
1448: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
1449: ' and mcb.category_id = mcsvc.category_id ' ||