[Home] [Help]
552: -- Do not include Inventory Organizations in relationship records.
553: and mst.partner_type <> 3
554: MINUS
555: select subject_id, object_id, relationship_type
556: from msc_company_relationships;
557:
558: a_subject_id number_arr;
559: a_object_id number_arr;
560: a_relationship_type number_arr;
576: -- Do this step only if some data is fetched in earlier step
577: IF a_subject_id.COUNT > 0 THEN
578: BEGIN
579: FORALL i IN 1..a_subject_id.COUNT
580: INSERT INTO msc_company_relationships
581: ( RELATIONSHIP_ID ,
582: SUBJECT_ID ,
583: OBJECT_ID ,
584: RELATIONSHIP_TYPE ,
603:
604: LOG_MESSAGE('========================================');
605: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPANY_REL_ERR');
606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREARE_NEW_RELATIONSHIPS');
607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_RELATIONSHIPS');
608: LOG_MESSAGE(FND_MESSAGE.GET);
609:
610: LOG_MESSAGE(SQLERRM);
611: ROLLBACK;
611: ROLLBACK;
612: END;
613: COMMIT;
614: --Bug 5155944: Analysing the table to improve performance
615: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_RELATIONSHIPS');
616: END IF;
617:
618: END CREATE_NEW_RELATIONSHIPS;
619:
1589: mcr.relationship_id
1590: from msc_trading_partners mtp,
1591: msc_tp_id_lid mtil,
1592: msc_company_id_lid mcil,
1593: msc_company_relationships mcr
1594: where mtp.partner_id = mtil.tp_id
1595: and mtil.sr_instance_id = p_instance_id
1596: and mtil.sr_tp_id = mcil.sr_company_id
1597: and mtil.sr_instance_id = mcil.sr_instance_id