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.

[Home] [Help]

View: MRP_AP_SR_ASSIGNMENTS_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MSA.ASSIGNMENT_ID
, MSA.ASSIGNMENT_SET_TYPE
, MSA.SOURCING_RULE_ID
, MSA.SOURCING_RULE_TYPE
, MSA.ASSIGNMENT_SET_ID
, MSA.INVENTORY_ITEM_ID
, MSA.ORGANIZATION_ID
, MSA.CATEGORY_ID
, MSA.CATEGORY_SET_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_NAME
, MSA.CUSTOMER_ID
, MSA.SHIP_TO_SITE_ID
, NVL(MC.RN
, 0) RN2
, MSA.RN RN1
FROM MTL_CATEGORIES_KFV MCK
, MRP_AP_CATG_SN MC
, MRP_AP_SR_ASGNS_SN MSA
WHERE MCK.CATEGORY_ID(+)= MSA.CATEGORY_ID
AND MC.CATEGORY_ID(+)= MSA.CATEGORY_ID

Columns

Name
ASSIGNMENT_ID
ASSIGNMENT_SET_TYPE
SOURCING_RULE_ID
SOURCING_RULE_TYPE
ASSIGNMENT_SET_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
CATEGORY_ID
CATEGORY_SET_ID
CATEGORY_NAME
CUSTOMER_ID
SHIP_TO_SITE_ID
RN2
RN1