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_ROUTING_OPERATIONS_V

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

View Text

SELECT BOS.OPERATION_SEQUENCE_ID
, BOR.ROUTING_SEQUENCE_ID
, BOS.OPERATION_SEQ_NUM
, BOS.OPERATION_DESCRIPTION
, BOS.EFFECTIVITY_DATE
, BOS.DISABLE_DATE
, BOS.OPTION_DEPENDENT_FLAG
, BOS.OPERATION_TYPE
, BOS.MINIMUM_TRANSFER_QUANTITY
, BOS.YIELD
, BOS.DEPARTMENT_ID
, BOS.OPERATION_LEAD_TIME_PERCENT
, BOS.CUMULATIVE_YIELD
, BOS.REVERSE_CUMULATIVE_YIELD
, BOS.NET_PLANNING_PERCENT
, BD.ORGANIZATION_ID
, BD.DEPARTMENT_CODE
, BSO.OPERATION_CODE STANDARD_OPERATION_CODE
, MP.RN RN4
, MSIK.RN RN3
, BOR.RN RN2
, BOS.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_STD_OPRS_SN BSO
, MRP_AP_DEPTS_SN BD
, MRP_AP_OPR_RTNS_SN BOR
, MRP_AP_OPR_SEQS_SN BOS
WHERE BD.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = BOR.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID= BOR.ASSEMBLY_ITEM_ID
AND BD.DEPARTMENT_ID= BOS.DEPARTMENT_ID
AND BSO.STANDARD_OPERATION_ID(+)= BOS.STANDARD_OPERATION_ID
AND BOR.COMMON_ROUTING_SEQUENCE_ID= BOS.ROUTING_SEQUENCE_ID

Columns

Name
OPERATION_SEQUENCE_ID
ROUTING_SEQUENCE_ID
OPERATION_SEQ_NUM
OPERATION_DESCRIPTION
EFFECTIVITY_DATE
DISABLE_DATE
OPTION_DEPENDENT_FLAG
OPERATION_TYPE
MINIMUM_TRANSFER_QUANTITY
YIELD
DEPARTMENT_ID
OPERATION_LEAD_TIME_PERCENT
CUMULATIVE_YIELD
REVERSE_CUMULATIVE_YIELD
NET_PLANNING_PERCENT
ORGANIZATION_ID
DEPARTMENT_CODE
STANDARD_OPERATION_CODE
RN4
RN3
RN2
RN1