APPS.MSC_X_HZ_PLAN dependencies on MSC_FORM_QUERY

Line 2727: -- insert all the items of the category into temp table msc_form_query.

2723:
2724: BEGIN
2725:
2726:
2727: -- insert all the items of the category into temp table msc_form_query.
2728: -- store all the item ids in number1 column of msc_form_query temp table.
2729: if (v_category is not null) then
2730: select msc_form_query_s.nextval into l_query_id from dual;
2731: OPEN category_items(v_category);

Line 2728: -- store all the item ids in number1 column of msc_form_query temp table.

2724: BEGIN
2725:
2726:
2727: -- insert all the items of the category into temp table msc_form_query.
2728: -- store all the item ids in number1 column of msc_form_query temp table.
2729: if (v_category is not null) then
2730: select msc_form_query_s.nextval into l_query_id from dual;
2731: OPEN category_items(v_category);
2732: LOOP

Line 2730: select msc_form_query_s.nextval into l_query_id from dual;

2726:
2727: -- insert all the items of the category into temp table msc_form_query.
2728: -- store all the item ids in number1 column of msc_form_query temp table.
2729: if (v_category is not null) then
2730: select msc_form_query_s.nextval into l_query_id from dual;
2731: OPEN category_items(v_category);
2732: LOOP
2733: FETCH category_items into l_item_id;
2734: EXIT WHEN category_items%NOTFOUND;

Line 2735: INSERT INTO msc_form_query

2731: OPEN category_items(v_category);
2732: LOOP
2733: FETCH category_items into l_item_id;
2734: EXIT WHEN category_items%NOTFOUND;
2735: INSERT INTO msc_form_query
2736: (
2737: QUERY_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,
2738: DATE1,DATE2,DATE3,DATE4,DATE5,DATE6,DATE7,DATE8,NUMBER1,NUMBER2,NUMBER3,NUMBER4,NUMBER5,
2739: NUMBER6,NUMBER7,NUMBER8,NUMBER9,NUMBER10,NUMBER11,NUMBER12,NUMBER13,NUMBER14,NUMBER15,

Line 2923: l_statement := l_statement || ' and inventory_item_id in (select number1 from msc_form_query where query_id = ' || l_query_id || ')';

2919: end if;
2920: end if;
2921:
2922: if (v_category is not null) then
2923: l_statement := l_statement || ' and inventory_item_id in (select number1 from msc_form_query where query_id = ' || l_query_id || ')';
2924: end if;
2925:
2926: l_statement := l_statement || ' ORDER BY ITEM_NAME ' || arg_item_sort || ' , REL ,';
2927: l_statement := l_statement || 'PUBLISHER_ORDER_TYPE,PUBLISHER_NAME,PUBLISHER_SITE_NAME,';