APPS.MSC_DRP_SRC_ALLOC_RULES dependencies on MSC_DRP_ALLOC_RECEIPT_RULES

Line 162: MSC_DRP_ALLOC_RECEIPT_RULES MDARR

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)
166: AND MSA1.ALLOCATION_RULE_ID = MDAR.RULE_ID

Line 219: MSC_DRP_ALLOC_RECEIPT_RULES MDARR

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)
223: AND MSA1.ALLOCATION_RULE_ID = MDAR.RULE_ID

Line 246: MSC_DRP_ALLOC_RECEIPT_RULES MDARR,

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
250: AND MAS.ASSIGNMENT_SET_ID = MSA1.ASSIGNMENT_SET_ID

Line 299: MSC_DRP_ALLOC_RECEIPT_RULES MDARR,

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
302: WHERE MAS.ASSIGNMENT_SET_NAME= l_assignment_set
303: AND MAS.ASSIGNMENT_SET_ID = MSA1.ASSIGNMENT_SET_ID

Line 366: and msa.organization_id not in (select to_organization_id from msc_drp_alloc_receipt_rules mdarr

362: and mtp.partner_type=3
363: and msa.sr_instance_id = l_instance_id
364: and mdard.rule_id = mdar.rule_id
365: and nvl(mdard.disable_date, sysdate) >= sysdate
366: and msa.organization_id not in (select to_organization_id from msc_drp_alloc_receipt_rules mdarr
367: where mdarr.time_phase_id = mdard.time_phase_id
368: and mdarr.sr_instance_id = msa.sr_instance_id
369: );
370:

Line 385: msc_drp_alloc_receipt_rules mdarr

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
388: and msa.allocation_rule_id = mdar.rule_id
389: and msa.organization_id = mtp.sr_tp_id

Line 423: msc_drp_alloc_receipt_rules mdarr

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
426: and msa.allocation_rule_id = mdar.rule_id
427: and msa.organization_id = mtp.sr_tp_id