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.MRPP_CMERGE_FCST dependencies on MSC_FORM_QUERY

Line 772: from msc_form_query m, ra_customer_merges r

768: m.number7 sourcing_rule_type,
769: nvl(m.number8, -23453) inventory_item_id,
770: nvl(m.number9, -23453) category_id,
771: count(*)
772: from msc_form_query m, ra_customer_merges r
773: where m.number5 = r.duplicate_id
774: and m.number6 = r.duplicate_site_id
775: and m.query_id = q_id
776: and r.process_flag = 'N'

Line 797: l_assignment_set_id msc_form_query.number2%type;

793:
794: l_last_fetch BOOLEAN := FALSE;
795: l_count NUMBER;
796:
797: l_assignment_set_id msc_form_query.number2%type;
798: l_assignment_type msc_form_query.number3%type;
799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;

Line 798: l_assignment_type msc_form_query.number3%type;

794: l_last_fetch BOOLEAN := FALSE;
795: l_count NUMBER;
796:
797: l_assignment_set_id msc_form_query.number2%type;
798: l_assignment_type msc_form_query.number3%type;
799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;

Line 799: l_organization_id msc_form_query.number4%type;

795: l_count NUMBER;
796:
797: l_assignment_set_id msc_form_query.number2%type;
798: l_assignment_type msc_form_query.number3%type;
799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;
803: l_customer_id ra_customer_merges.customer_id%type;

Line 800: l_sourcing_rule_type msc_form_query.number7%type;

796:
797: l_assignment_set_id msc_form_query.number2%type;
798: l_assignment_type msc_form_query.number3%type;
799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;
803: l_customer_id ra_customer_merges.customer_id%type;
804: l_customer_site_id ra_customer_merges.customer_site_id%type;

Line 801: l_inventory_item_id msc_form_query.number8%type;

797: l_assignment_set_id msc_form_query.number2%type;
798: l_assignment_type msc_form_query.number3%type;
799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;
803: l_customer_id ra_customer_merges.customer_id%type;
804: l_customer_site_id ra_customer_merges.customer_site_id%type;
805:

Line 802: l_category_id msc_form_query.number9%type;

798: l_assignment_type msc_form_query.number3%type;
799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;
803: l_customer_id ra_customer_merges.customer_id%type;
804: l_customer_site_id ra_customer_merges.customer_site_id%type;
805:
806: q_id number;

Line 818: select msc_form_query_s.nextval

814: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
815: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
816:
817: /* Fix for bug 1292873, part 2. */
818: select msc_form_query_s.nextval
819: into q_id
820: from dual;
821:
822: insert into msc_form_query

Line 822: insert into msc_form_query

818: select msc_form_query_s.nextval
819: into q_id
820: from dual;
821:
822: insert into msc_form_query
823: (query_id, last_update_date, last_updated_by, creation_date,
824: created_by,
825: number1,
826: number2,

Line 883: from msc_form_query

879: and nvl(inventory_item_id, -23453) = rec.inventory_item_id
880: and nvl(category_id, -23453) = rec.category_id
881: and assignment_id in (
882: select number1
883: from msc_form_query
884: where query_id = q_id
885: );
886: end if;
887: