DBA Data[Home] [Help]

APPS.MSC_DRP_SRC_ALLOC_RULES dependencies on MSC_SR_RECEIPT_ORG

Line 39: MSC_SR_RECEIPT_ORG MSRO,

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,
43: MSC_TRADING_PARTNERS MTP2

Line 82: MSC_SR_RECEIPT_ORG MSRO,

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,
86: MSC_TRADING_PARTNERS MTP1,

Line 135: MSC_SR_RECEIPT_ORG MSRO,

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,
139: MSC_TRADING_PARTNERS MTP2

Line 186: MSC_SR_RECEIPT_ORG MSRO,

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,
190: MSC_TRADING_PARTNERS MTP1,

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