[Home] [Help]
635: -- Do not include Inventory Organizations in relationship records.
636: and mst.partner_type <> 3
637: MINUS
638: select subject_id, object_id, relationship_type
639: from msc_company_relationships;
640:
641: a_subject_id number_arr;
642: a_object_id number_arr;
643: a_relationship_type number_arr;
659: -- Do this step only if some data is fetched in earlier step
660: IF a_subject_id.COUNT > 0 THEN
661: BEGIN
662: FORALL i IN 1..a_subject_id.COUNT
663: INSERT INTO msc_company_relationships
664: ( RELATIONSHIP_ID ,
665: SUBJECT_ID ,
666: OBJECT_ID ,
667: RELATIONSHIP_TYPE ,
686:
687: LOG_MESSAGE('========================================');
688: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
689: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
690: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
691: LOG_MESSAGE(FND_MESSAGE.GET);
692:
693: LOG_MESSAGE(SQLERRM);
694: ROLLBACK;
694: ROLLBACK;
695: END;
696: COMMIT;
697: --Bug 5155944: Analysing the table to improve performance
698: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_RELATIONSHIPS');
699: END IF;
700:
701: END CREATE_NEW_RELATIONSHIPS;
702:
1672: mcr.relationship_id
1673: from msc_trading_partners mtp,
1674: msc_tp_id_lid mtil,
1675: msc_company_id_lid mcil,
1676: msc_company_relationships mcr
1677: where mtp.partner_id = mtil.tp_id
1678: and mtil.sr_instance_id = p_instance_id
1679: and mtil.sr_tp_id = mcil.sr_company_id
1680: and mtil.sr_instance_id = mcil.sr_instance_id