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_DRP_SRC_ALLOC_RULES dependencies on MSC_SR_SOURCE_ORG

Line 38: MSC_SR_SOURCE_ORG MSSO,

34: decode(MSA.ASSIGNMENT_TYPE,3,'Item-Instance',6,'Item-Instance-Organization',9,'Item-Instance-region') ASSIGNMENT_LEVEL
35: FROM
36: MSC_ASSIGNMENT_SETS MAS,
37: MSC_SR_ASSIGNMENTS MSA,
38: MSC_SR_SOURCE_ORG MSSO,
39: MSC_SR_RECEIPT_ORG MSRO,
40: MSC_SOURCING_RULES MSR,
41: MSC_SYSTEM_ITEMS MSI,
42: MSC_TRADING_PARTNERS MTP1,

Line 81: MSC_SR_SOURCE_ORG MSSO,

77: decode(MSA.ASSIGNMENT_TYPE,5,'Category-Instance-Org',8,'Category-Instance-Region') ASSIGNMENT_LEVEL
78: FROM
79: MSC_ASSIGNMENT_SETS MAS,
80: MSC_SR_ASSIGNMENTS MSA,
81: MSC_SR_SOURCE_ORG MSSO,
82: MSC_SR_RECEIPT_ORG MSRO,
83: MSC_SOURCING_RULES MSR,
84: MSC_ITEM_CATEGORIES CAT,
85: MSC_SYSTEM_ITEMS MSI,

Line 134: MSC_SR_SOURCE_ORG MSSO,

130: decode(MSA.ASSIGNMENT_TYPE,3,'Item-Instance',6,'Item-Instance-Organization',9,'Item-Instance-region') ASSIGNMENT_LEVEL
131: FROM
132: MSC_ASSIGNMENT_SETS MAS,
133: MSC_SR_ASSIGNMENTS MSA,
134: MSC_SR_SOURCE_ORG MSSO,
135: MSC_SR_RECEIPT_ORG MSRO,
136: MSC_SOURCING_RULES MSR,
137: MSC_SYSTEM_ITEMS MSI,
138: MSC_TRADING_PARTNERS MTP1,

Line 185: MSC_SR_SOURCE_ORG MSSO,

181: decode(MSA.ASSIGNMENT_TYPE,5,'Category-Instance-Org',8,'Category-Instance-Region') ASSIGNMENT_LEVEL
182: FROM
183: MSC_ASSIGNMENT_SETS MAS,
184: MSC_SR_ASSIGNMENTS MSA,
185: MSC_SR_SOURCE_ORG MSSO,
186: MSC_SR_RECEIPT_ORG MSRO,
187: MSC_SOURCING_RULES MSR,
188: MSC_ITEM_CATEGORIES CAT,
189: MSC_SYSTEM_ITEMS MSI,

Line 271: AND NOT EXISTS (SELECT 1 FROM MSC_SR_ASSIGNMENTS MSA, MSC_SR_SOURCE_ORG MSSO,

267: AND MDARR.SR_INSTANCE_ID = MTP2.SR_INSTANCE_ID
268: AND MTP2.PARTNER_TYPE=3
269: AND MSA1.ORGANIZATION_ID <> MDARR.TO_ORGANIZATION_ID
270: AND MSA1.SR_INSTANCE_ID= l_instance_id
271: AND NOT EXISTS (SELECT 1 FROM MSC_SR_ASSIGNMENTS MSA, MSC_SR_SOURCE_ORG MSSO,
272: MSC_SR_RECEIPT_ORG MSRO, MSC_SOURCING_RULES MSR
273: WHERE MSA.ASSIGNMENT_SET_ID = MSA1.ASSIGNMENT_SET_ID
274: AND MSA.SR_INSTANCE_ID = MSA1.SR_INSTANCE_ID
275: AND MSA.SOURCING_RULE_ID = MSR.SOURCING_RULE_ID

Line 328: AND NOT EXISTS (SELECT 1 FROM MSC_SR_ASSIGNMENTS MSA, MSC_SR_SOURCE_ORG MSSO,

324: AND MDARR.SR_INSTANCE_ID = MTP2.SR_INSTANCE_ID
325: AND MTP2.PARTNER_TYPE=3
326: AND MSA1.ORGANIZATION_ID <> MDARR.TO_ORGANIZATION_ID
327: AND MSA1.SR_INSTANCE_ID= l_instance_id
328: AND NOT EXISTS (SELECT 1 FROM MSC_SR_ASSIGNMENTS MSA, MSC_SR_SOURCE_ORG MSSO,
329: MSC_SR_RECEIPT_ORG MSRO, MSC_SOURCING_RULES MSR
330: WHERE MSA.ASSIGNMENT_SET_ID = MSA1.ASSIGNMENT_SET_ID
331: AND MSA.SR_INSTANCE_ID = MSA1.SR_INSTANCE_ID
332: AND MSA.SOURCING_RULE_ID = MSR.SOURCING_RULE_ID