[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 |