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,
43: MSC_TRADING_PARTNERS MTP2
44: WHERE MAS.ASSIGNMENT_SET_NAME= l_assignment_set
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,
86: MSC_TRADING_PARTNERS MTP1,
87: MSC_TRADING_PARTNERS MTP2
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,
139: MSC_TRADING_PARTNERS MTP2
140: WHERE MAS.ASSIGNMENT_SET_NAME= l_assignment_set
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,
190: MSC_TRADING_PARTNERS MTP1,
191: MSC_TRADING_PARTNERS MTP2
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
276: AND MSA.SOURCING_RULE_ID = MSRO.SOURCING_RULE_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
333: AND MSA.SOURCING_RULE_ID = MSRO.SOURCING_RULE_ID