FND Design Data [Home] [Help]

View: MRP_AP_CRP_RESOURCE_HOURS_V

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

SELECT X.TRANSACTION_ID
, X.BILL_OF_RESOURCES
, X.ORGANIZATION_ID
, X.ASSEMBLY_ITEM_ID
, X.SOURCE_ITEM_ID
, X.RESOURCE_ID
, X.RESOURCE_DEPARTMENT_HOURS
, X.OPERATION_SEQUENCE_ID
, X.OPERATION_SEQ_NUM
, X.RESOURCE_SEQ_NUM
, X.SETBACK_DAYS
, X.DEPARTMENT_ID
, X.LINE_ID
, X.ASSEMBLY_USAGE
, X.ORIGINATION_TYPE
, X.RESOURCE_UNITS
, X.BASIS
, X.RN RN3
, Y.RN RN2
, MP.RN RN1
FROM ( SELECT NVL(BASE_ITEM_ID
, INVENTORY_ITEM_ID) ITEM_ID
, ORGANIZATION_ID ORG_ID
, MAX(RN) RN
FROM MRP_AP_SYS_ITEMS_SN MSIK GROUP BY NVL(BASE_ITEM_ID
, INVENTORY_ITEM_ID)
, ORGANIZATION_ID) Y
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_RES_HRS_SN X
WHERE X.ASSEMBLY_ITEM_ID = Y.ITEM_ID
AND X.ORGANIZATION_ID = Y.ORG_ID
AND MP.ORGANIZATION_ID= X.ORGANIZATION_ID

Columns

Name
TRANSACTION_ID
BILL_OF_RESOURCES
ORGANIZATION_ID
ASSEMBLY_ITEM_ID
SOURCE_ITEM_ID
RESOURCE_ID
RESOURCE_DEPARTMENT_HOURS
OPERATION_SEQUENCE_ID
OPERATION_SEQ_NUM
RESOURCE_SEQ_NUM
SETBACK_DAYS
DEPARTMENT_ID
LINE_ID
ASSEMBLY_USAGE
ORIGINATION_TYPE
RESOURCE_UNITS
BASIS
RN3
RN2
RN1