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_ASSIGNMENT_SETS

Line 36: MSC_ASSIGNMENT_SETS MAS,

32: MTP2.ORGANIZATION_CODE TO_ORG,
33: MSI.ITEM_NAME,
34: decode(MSA.ASSIGNMENT_TYPE,3,'Item-Instance',6,'Item-Instance-Organization',9,'Item-Instance-region') ASSIGNMENT_LEVEL
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,

Line 79: MSC_ASSIGNMENT_SETS MAS,

75: MTP2.ORGANIZATION_CODE TO_ORG,
76: MSI.ITEM_NAME,
77: decode(MSA.ASSIGNMENT_TYPE,5,'Category-Instance-Org',8,'Category-Instance-Region') ASSIGNMENT_LEVEL
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,

Line 132: MSC_ASSIGNMENT_SETS MAS,

128: MTP2.ORGANIZATION_CODE TO_ORG,
129: MSI.ITEM_NAME,
130: decode(MSA.ASSIGNMENT_TYPE,3,'Item-Instance',6,'Item-Instance-Organization',9,'Item-Instance-region') ASSIGNMENT_LEVEL
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,

Line 183: MSC_ASSIGNMENT_SETS MAS,

179: MTP2.ORGANIZATION_CODE TO_ORG,
180: MSI.ITEM_NAME,
181: decode(MSA.ASSIGNMENT_TYPE,5,'Category-Instance-Org',8,'Category-Instance-Region') ASSIGNMENT_LEVEL
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,

Line 241: FROM MSC_ASSIGNMENT_SETS MAS,

237: MTP1.ORGANIZATION_CODE FROM_ORG,
238: MTP2.ORGANIZATION_CODE TO_ORG,
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,

Line 293: FROM MSC_ASSIGNMENT_SETS MAS,

289: MTP1.ORGANIZATION_CODE FROM_ORG,
290: MTP2.ORGANIZATION_CODE TO_ORG,
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,

Line 351: FROM msc_assignment_sets mas,

347: select mas.assignment_set_name,
348: mdar.name,
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

Line 378: FROM msc_assignment_sets mas,

374: mdar.name,
375: mtp.organization_code FROM_ORG,
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,

Line 415: FROM msc_assignment_sets mas,

411: mdar.name,
412: mtp.organization_code FROM_ORG,
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,