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:

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:
53: -- private package constants

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

691: x_has_subcategory := 'N';
692: RETURN;
693: END IF;
694:
695: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||
696: ' mtl_category_set_valid_cats mcsvc, pos_sup_products_services psps where ' ||
697: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
698: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
699: ' and mcb.category_id = mcsvc.category_id ' ||

Line 806: l_segment_value mtl_categories_b.segment1%TYPE;

802: PROCEDURE get_concatenated_description (
803: p_segments IN category_segment_record
804: , x_description OUT NOCOPY VARCHAR2 )
805: IS
806: l_segment_value mtl_categories_b.segment1%TYPE;
807: l_parent_segment_value mtl_categories_b.segment1%TYPE;
808: l_result VARCHAR2(3000);
809: BEGIN
810: assert_init();

Line 807: l_parent_segment_value mtl_categories_b.segment1%TYPE;

803: p_segments IN category_segment_record
804: , x_description OUT NOCOPY VARCHAR2 )
805: IS
806: l_segment_value mtl_categories_b.segment1%TYPE;
807: l_parent_segment_value mtl_categories_b.segment1%TYPE;
808: l_result VARCHAR2(3000);
809: BEGIN
810: assert_init();
811: --dbms_output.put_line('count ' || g_product_segment_count);

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

976: IS
977: l_query VARCHAR2(4000);
978: BEGIN
979: assert_init();
980: l_query := 'select psps.vendor_id, mcb.category_id from mtl_categories_b mcb, ' ||
981: ' mtl_category_set_valid_cats mcsvc, pos_sup_products_services psps where ' ||
982: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
983: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
984: ' and mcb.category_id = mcsvc.category_id and (';

Line 1067: mtl_categories_b mcb,

1063: l_tbl_sql := 'SELECT ffvl.flex_value,
1064: ffvl.description,
1065: ffvl.flex_value_id
1066: FROM fnd_flex_values_vl ffvl,
1067: mtl_categories_b mcb,
1068: mtl_category_set_valid_cats mcsvc
1069: WHERE ffvl.flex_value_set_id = '|| p_curr_seg_val_id ||
1070: ' AND mcb.category_id = mcsvc.category_id
1071: and (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'')

Line 1125: mtl_categories_b mcb,

1121:
1122: l_sql := 'select ffvl.flex_value,
1123: ffvl.flex_value_id
1124: from fnd_flex_values_vl ffvl,
1125: mtl_categories_b mcb,
1126: mtl_category_set_valid_cats mcsvc
1127: where ffvl.flex_value_set_id = ' || p_parent_seg_val_id || ' AND
1128: mcb.category_id = mcsvc.category_id
1129: and (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'')

Line 1148: mtl_categories_b mcb1,

1144: l_tbl_sql := 'SELECT ffvl2.flex_value,
1145: ffvl2.description,
1146: ffvl2.flex_value_id
1147: FROM fnd_flex_values_vl ffvl2,
1148: mtl_categories_b mcb1,
1149: mtl_category_set_valid_cats mcsvc1
1150: WHERE ffvl2.flex_value_set_id = ' || p_curr_seg_val_id || ' and
1151: mcb1.category_id = mcsvc1.category_id AND
1152: (mcb1.supplier_enabled_flag is null or mcb1.supplier_enabled_flag = ''Y'' or mcb1.supplier_enabled_flag = ''y'') and

Line 1216: from mtl_categories_b mcb, mtl_category_set_valid_cats mcsvc,(SELECT '||p_meaning||' description, '||

1212: IF(p_where_clause IS not null ) then
1213: -- Bug 9126584 (FP 9056630). Added spaces to construct the query string properly.
1214: l_tbl_sql := 'select distinct mcb.'||p_column_name || ' value,
1215: x.description description
1216: from mtl_categories_b mcb, mtl_category_set_valid_cats mcsvc,(SELECT '||p_meaning||' description, '||
1217: l_valorid_col||' value '||
1218: ' FROM '||p_table_name||' '||
1219: p_where_clause||
1220: ') x where mcb.' || p_column_name ||' is not null

Line 1233: from mtl_categories_b mcb, mtl_category_set_valid_cats mcsvc,'||'(SELECT '||p_meaning||' description, '||

1229:
1230: ELSE
1231: l_tbl_sql := 'select distinct mcb.' ||p_column_name ||' value,
1232: x.description description
1233: from mtl_categories_b mcb, mtl_category_set_valid_cats mcsvc,'||'(SELECT '||p_meaning||' description, '||
1234: l_valorid_col||' value '||
1235: ' FROM '||p_table_name|| ') x where mcb.' || p_column_name ||' is not null
1236: and (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y''
1237: or mcb.supplier_enabled_flag = ''y'')

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

1617: x_has_subcategory := 'N';
1618: RETURN;
1619: END IF;
1620:
1621: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||
1622: ' mtl_category_set_valid_cats mcsvc, pos_product_service_requests ppsr where ' ||
1623: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
1624: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
1625: ' and mcb.category_id = mcsvc.category_id ' ||