DBA Data[Home] [Help]

APPS.MSC_DRP_SRC_ALLOC_RULES dependencies on MSC_SOURCING_RULES

Line 40: MSC_SOURCING_RULES MSR,

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

Line 83: MSC_SOURCING_RULES MSR,

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

Line 136: MSC_SOURCING_RULES MSR,

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

Line 187: MSC_SOURCING_RULES MSR,

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

Line 272: MSC_SR_RECEIPT_ORG MSRO, MSC_SOURCING_RULES MSR

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

Line 329: MSC_SR_RECEIPT_ORG MSRO, MSC_SOURCING_RULES MSR

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