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_TRADING_PARTNERS

Line 42: MSC_TRADING_PARTNERS MTP1,

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
46: AND MSA.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID

Line 43: MSC_TRADING_PARTNERS MTP2

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
46: AND MSA.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
47: AND MSA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 86: MSC_TRADING_PARTNERS MTP1,

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
90: AND NVL(MSA.ORGANIZATION_ID, CAT.ORGANIZATION_ID)

Line 87: MSC_TRADING_PARTNERS MTP2

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
90: AND NVL(MSA.ORGANIZATION_ID, CAT.ORGANIZATION_ID)
91: = CAT.ORGANIZATION_ID

Line 138: MSC_TRADING_PARTNERS MTP1,

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
142: AND MSA.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID

Line 139: MSC_TRADING_PARTNERS MTP2

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
142: AND MSA.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
143: AND MSA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 190: MSC_TRADING_PARTNERS MTP1,

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
194: AND NVL(MSA.ORGANIZATION_ID, CAT.ORGANIZATION_ID)

Line 191: MSC_TRADING_PARTNERS MTP2

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
194: AND NVL(MSA.ORGANIZATION_ID, CAT.ORGANIZATION_ID)
195: = CAT.ORGANIZATION_ID

Line 247: MSC_TRADING_PARTNERS MTP1,

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
251: AND MSA1.SOURCING_RULE_TYPE = 3

Line 248: MSC_TRADING_PARTNERS MTP2

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
251: AND MSA1.SOURCING_RULE_TYPE = 3
252: AND MSA1.ALLOCATION_RULE_ID = MDAR.RULE_ID

Line 300: MSC_TRADING_PARTNERS MTP1,

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
304: AND MSA1.SOURCING_RULE_TYPE = 3

Line 301: MSC_TRADING_PARTNERS MTP2

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
304: AND MSA1.SOURCING_RULE_TYPE = 3
305: AND MSA1.ALLOCATION_RULE_ID = MDAR.RULE_ID

Line 354: msc_trading_partners mtp,

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

Line 381: msc_trading_partners mtp,

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,
385: msc_drp_alloc_receipt_rules mdarr

Line 382: msc_trading_partners mtp2,

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,
385: msc_drp_alloc_receipt_rules mdarr
386: where mas.ASSIGNMENT_SET_NAME= l_assignment_set

Line 418: msc_trading_partners mtp,

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,
422: msc_drp_alloc_rule_dates mdard,

Line 419: msc_trading_partners mtp2,

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,
422: msc_drp_alloc_rule_dates mdard,
423: msc_drp_alloc_receipt_rules mdarr