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.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_SR_ASSIGNMENTS

Line 747: UPDATE MSC_SR_ASSIGNMENTS

743: END IF;
744:
745: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
746:
747: UPDATE MSC_SR_ASSIGNMENTS
748: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
749: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
750: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
751: WHERE SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 808: UPDATE MSC_SR_ASSIGNMENTS msa

804: BEGIN
805:
806: FORALL j IN lb_SR_ASSIGNMENT_ID.FIRST..lb_SR_ASSIGNMENT_ID.LAST
807:
808: UPDATE MSC_SR_ASSIGNMENTS msa
809: SET msa.ASSIGNMENT_TYPE = lb_ASSIGNMENT_TYPE(j),
810: msa.SOURCING_RULE_ID = lb_SOURCING_RULE_ID(j),
811: msa.SOURCING_RULE_TYPE = lb_SOURCING_RULE_TYPE(j),
812: msa.INVENTORY_ITEM_ID = lb_INVENTORY_ITEM_ID(j),

Line 837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

833:
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
841: RAISE;

Line 850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
854: END IF;

Line 866: INTO MSC_SR_ASSIGNMENTS

862: BEGIN
863:
864:
865: INSERT /*+ APPEND */
866: INTO MSC_SR_ASSIGNMENTS
867: ( ASSIGNMENT_ID,
868: SR_ASSIGNMENT_ID,
869: ASSIGNMENT_SET_ID,
870: ASSIGNMENT_TYPE,

Line 889: MSC_SR_ASSIGNMENTS_S.NEXTVAL,

885: LAST_UPDATED_BY,
886: CREATION_DATE,
887: CREATED_BY)
888: SELECT
889: MSC_SR_ASSIGNMENTS_S.NEXTVAL,
890: mssa.SR_ASSIGNMENT_ID,
891: mas.ASSIGNMENT_SET_ID,
892: mssa.ASSIGNMENT_TYPE,
893: msr.SOURCING_RULE_ID,

Line 953: from MSC_SR_ASSIGNMENTS msa2

949: OR
950: mssa.assignment_type not in (2,3,5,6)
951: )
952: AND not exists (select 1
953: from MSC_SR_ASSIGNMENTS msa2
954: where msa2.SR_Assignment_ID = mssa.SR_Assignment_ID
955: AND msa2.SR_Assignment_Instance_ID = mssa.SR_Assignment_Instance_ID
956: AND msa2.collected_flag = MSC_UTIL.SYS_YES);
957:

Line 966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
970: RAISE;

Line 979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
983: END IF;

Line 990: DELETE MSC_SR_ASSIGNMENTS

986:
987:
988: COMMIT;
989:
990: DELETE MSC_SR_ASSIGNMENTS
991: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
992: AND SR_ASSIGNMENT_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
993: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
994:

Line 999: msc_analyse_tables_pk.analyse_table( 'MSC_SR_ASSIGNMENTS');

995: COMMIT;
996:
997: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
998:
999: msc_analyse_tables_pk.analyse_table( 'MSC_SR_ASSIGNMENTS');
1000:
1001: END IF;
1002:
1003: --/* it's removed due to bug 1219661

Line 5559: ||' from MSC_SR_ASSIGNMENTS MSA,'

5555: lv_sql_stmt :=
5556: ' UPDATE MSC_ORG_AGGR_IBUC MOAI '
5557: ||' set MOAI.SUPPLYING_ORG_ID =('
5558: ||' select MSSO.SOURCE_ORGANIZATION_ID'
5559: ||' from MSC_SR_ASSIGNMENTS MSA,'
5560: ||' MSC_SOURCING_RULES MSR,'
5561: ||' MSC_SR_RECEIPT_ORG MSRO,'
5562: ||' MSC_SR_SOURCE_ORG MSSO'
5563: ||' WHERE MSA.ASSIGNMENT_SET_ID = :lv_assign_set_id'

Line 5568: ||' AND NOT EXISTS (SELECT 1 FROM MSC_SR_ASSIGNMENTS MSA2'

5564: ||' AND ( (msa.assignment_type=9 AND MSA.REGION_ID = MOAI.REGION_ID AND'
5565: ||' MSA.SR_INSTANCE_ID = MOAI.SR_INSTANCE_ID AND MOAI.INVENTORY_ITEM_ID = msa.INVENTORY_ITEM_ID)'
5566: ||' OR'
5567: ||' (MSA.ASSIGNMENT_TYPE =7 AND MSA.REGION_ID = MOAI.REGION_ID AND MSA.SR_INSTANCE_ID = MOAI.SR_INSTANCE_ID'
5568: ||' AND NOT EXISTS (SELECT 1 FROM MSC_SR_ASSIGNMENTS MSA2'
5569: ||' WHERE MSA2.ASSIGNMENT_SET_ID = :lv_assign_set_id and MSA2.ASSIGNMENT_TYPE =9'
5570: ||' AND MSA2.REGION_ID = MOAI.REGION_ID AND MSA2.SR_INSTANCE_ID=MOAI.sr_instance_id'
5571: ||' AND MOAI.INVENTORY_item_id = msa2.inventory_item_id)))'
5572: ||' AND MSR.SR_INSTANCE_ID = MSA.SR_INSTANCE_ID'