DBA Data[Home] [Help]

APPS.MSC_DRP_SRC_ALLOC_RULES dependencies on MSC_DRP_ALLOC_RULES

Line 161: select 1 from MSC_SR_ASSIGNMENTS MSA1, MSC_DRP_ALLOC_RULES MDAR, MSC_DRP_ALLOC_RULE_DATES MDARD,

157: AND MSA.SR_INSTANCE_ID= MTP2.SR_INSTANCE_ID
158: AND MTP2.PARTNER_TYPE=3
159: AND MSA.SR_INSTANCE_ID=l_instance_id
160: AND NOT EXISTS (
161: select 1 from MSC_SR_ASSIGNMENTS MSA1, MSC_DRP_ALLOC_RULES MDAR, MSC_DRP_ALLOC_RULE_DATES MDARD,
162: MSC_DRP_ALLOC_RECEIPT_RULES MDARR
163: WHERE MSA1.ASSIGNMENT_SET_ID = MAS.ASSIGNMENT_SET_ID
164: AND MSA1.SOURCING_RULE_TYPE = 3
165: AND (MSA1.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID OR MSA1.INVENTORY_ITEM_ID is null)

Line 218: select 1 from MSC_SR_ASSIGNMENTS MSA1, MSC_DRP_ALLOC_RULES MDAR, MSC_DRP_ALLOC_RULE_DATES MDARD,

214: AND MSA.SR_INSTANCE_ID= MTP2.SR_INSTANCE_ID
215: AND MTP2.PARTNER_TYPE=3
216: AND MSA.SR_INSTANCE_ID=l_instance_id
217: AND NOT EXISTS (
218: select 1 from MSC_SR_ASSIGNMENTS MSA1, MSC_DRP_ALLOC_RULES MDAR, MSC_DRP_ALLOC_RULE_DATES MDARD,
219: MSC_DRP_ALLOC_RECEIPT_RULES MDARR
220: WHERE MSA1.ASSIGNMENT_SET_ID = MAS.ASSIGNMENT_SET_ID
221: AND MSA1.SOURCING_RULE_TYPE = 3
222: AND (MSA1.CATEGORY_NAME = CAT.CATEGORY_NAME OR MSA1.CATEGORY_NAME is null)

Line 243: MSC_DRP_ALLOC_RULES MDAR,

239: MSI.ITEM_NAME,
240: decode(MSA1.ASSIGNMENT_TYPE,6,'Item-Instance-Org') ASSIGNMENT_LEVEL
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,

Line 295: MSC_DRP_ALLOC_RULES MDAR,

291: MSI.ITEM_NAME,
292: decode(MSA1.ASSIGNMENT_TYPE,5,'Category-Instance-Org') ASSIGNMENT_LEVEL
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,

Line 353: msc_drp_alloc_rules mdar,

349: mtp.organization_code FROM_ORG,
350: decode(msa.assignment_type, 4, 'Instance-Org', 5, 'Category-Instance-Org', 6, 'Item-Instance-Org') ASSIGNMENT_LEVEL
351: FROM msc_assignment_sets mas,
352: msc_sr_assignments msa,
353: msc_drp_alloc_rules mdar,
354: msc_trading_partners mtp,
355: msc_drp_alloc_rule_dates mdard
356: where mas.ASSIGNMENT_SET_NAME= l_assignment_set
357: and mas.assignment_set_id=msa.assignment_set_id

Line 380: msc_drp_alloc_rules mdar,

376: mtp2.organization_code TO_ORG,
377: msi.item_name
378: FROM msc_assignment_sets mas,
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,

Line 417: msc_drp_alloc_rules mdar,

413: mtp2.organization_code TO_ORG,
414: msi.item_name
415: FROM msc_assignment_sets mas,
416: msc_sr_assignments msa,
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,