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_ROUTINGS_V

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

View Text

SELECT BOR.ROUTING_SEQUENCE_ID
, BOR.ASSEMBLY_ITEM_ID
, BOR.ROUTING_TYPE
, BOR.ROUTING_COMMENT
, BOR.PRIORITY
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, BOR.PROJECT_ID
, BOR.TASK_ID
, BOR.LINE_ID
, BOR.COMPLETION_SUBINVENTORY
, BOR.COMPLETION_LOCATOR_ID
, BOR.COMMON_ROUTING_SEQUENCE_ID
, BOR.CFM_ROUTING_FLAG
, BOR.MIXED_MODEL_MAP_FLAG
, BOR.TOTAL_PRODUCT_CYCLE_TIME
, BOR.CTP_FLAG
, BOR.ORGANIZATION_ID
, MP.RN RN3
, MSIK.RN RN2
, BOR.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_OPR_RTNS_SN BOR
WHERE BOR.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = BOR.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID= BOR.ASSEMBLY_ITEM_ID

Columns

Name
ROUTING_SEQUENCE_ID
ASSEMBLY_ITEM_ID
ROUTING_TYPE
ROUTING_COMMENT
PRIORITY
ALTERNATE_ROUTING_DESIGNATOR
PROJECT_ID
TASK_ID
LINE_ID
COMPLETION_SUBINVENTORY
COMPLETION_LOCATOR_ID
COMMON_ROUTING_SEQUENCE_ID
CFM_ROUTING_FLAG
MIXED_MODEL_MAP_FLAG
TOTAL_PRODUCT_CYCLE_TIME
CTP_FLAG
ORGANIZATION_ID
RN3
RN2
RN1