eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_DRP_SRC_ALLOC_RULES dependencies on MSC_DRP_ALLOC_RULE_DATES

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 244: MSC_DRP_ALLOC_RULE_DATES MDARD,

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

Line 296: MSC_DRP_ALLOC_RULE_DATES MDARD,

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

Line 355: msc_drp_alloc_rule_dates mdard

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

Line 384: msc_drp_alloc_rule_dates mdard,

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

Line 422: msc_drp_alloc_rule_dates mdard,

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