DBA Data[Home] [Help]

APPS.MSC_DRP_SRC_ALLOC_RULES dependencies on MSC_SYSTEM_ITEMS

Line 41: MSC_SYSTEM_ITEMS MSI,

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
45: AND MAS.ASSIGNMENT_SET_ID = MSA.ASSIGNMENT_SET_ID

Line 85: MSC_SYSTEM_ITEMS MSI,

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
88: WHERE MAS.ASSIGNMENT_SET_NAME= l_assignment_set
89: AND MAS.ASSIGNMENT_SET_ID = MSA.ASSIGNMENT_SET_ID

Line 137: MSC_SYSTEM_ITEMS MSI,

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
141: AND MAS.ASSIGNMENT_SET_ID = MSA.ASSIGNMENT_SET_ID

Line 189: MSC_SYSTEM_ITEMS MSI,

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
192: WHERE MAS.ASSIGNMENT_SET_NAME= l_assignment_set
193: AND MAS.ASSIGNMENT_SET_ID = MSA.ASSIGNMENT_SET_ID

Line 245: MSC_SYSTEM_ITEMS MSI,

241: FROM MSC_ASSIGNMENT_SETS MAS,
242: MSC_SR_ASSIGNMENTS MSA1,
243: MSC_DRP_ALLOC_RULES MDAR,
244: MSC_DRP_ALLOC_RULE_DATES MDARD,
245: MSC_SYSTEM_ITEMS MSI,
246: MSC_DRP_ALLOC_RECEIPT_RULES MDARR,
247: MSC_TRADING_PARTNERS MTP1,
248: MSC_TRADING_PARTNERS MTP2
249: WHERE MAS.ASSIGNMENT_SET_NAME= l_assignment_set

Line 297: MSC_SYSTEM_ITEMS MSI,

293: FROM MSC_ASSIGNMENT_SETS MAS,
294: MSC_SR_ASSIGNMENTS MSA1,
295: MSC_DRP_ALLOC_RULES MDAR,
296: MSC_DRP_ALLOC_RULE_DATES MDARD,
297: MSC_SYSTEM_ITEMS MSI,
298: MSC_ITEM_CATEGORIES CAT,
299: MSC_DRP_ALLOC_RECEIPT_RULES MDARR,
300: MSC_TRADING_PARTNERS MTP1,
301: MSC_TRADING_PARTNERS MTP2

Line 383: msc_system_items msi,

379: msc_sr_assignments msa,
380: msc_drp_alloc_rules mdar,
381: msc_trading_partners mtp,
382: msc_trading_partners mtp2,
383: msc_system_items msi,
384: msc_drp_alloc_rule_dates mdard,
385: msc_drp_alloc_receipt_rules mdarr
386: where mas.ASSIGNMENT_SET_NAME= l_assignment_set
387: and mas.assignment_set_id=msa.assignment_set_id

Line 421: msc_system_items msi,

417: msc_drp_alloc_rules mdar,
418: msc_trading_partners mtp,
419: msc_trading_partners mtp2,
420: MSC_ITEM_CATEGORIES CAT,
421: msc_system_items msi,
422: msc_drp_alloc_rule_dates mdard,
423: msc_drp_alloc_receipt_rules mdarr
424: where mas.ASSIGNMENT_SET_NAME= l_assignment_set
425: and mas.assignment_set_id=msa.assignment_set_id