View: CRP_RESOURCE_V

Product:	CRP - Capacity
Description:	Internal view for performance
Implementation/DBA Data:	APPS.CRP_RESOURCE_V

View Text

SELECT RES.ROWID
, RES.TRANSACTION_ID
, RES.ORGANIZATION_ID
, RES.DESIGNATOR
, RES.DEPARTMENT_ID
, RES.RESOURCE_ID
, RES.ASSEMBLY_ITEM_ID
, RES.SOURCE_TRANSACTION_ID
FROM CRP_RESOURCE_PLAN RES UNION ALL SELECT SUGG.ROWID
, -1
, SUGG.ORGANIZATION_ID
, SUGG.COMPILE_DESIGNATOR
, SUGG.REPETITIVE_LINE
, -1
, SUGG.INVENTORY_ITEM_ID
, SUGG.TRANSACTION_ID
FROM MRP_SUGG_REP_SCHEDULES SUGG UNION ALL SELECT MR.ROWID
, -2
, MR.ORGANIZATION_ID
, MR.COMPILE_DESIGNATOR
, MR.LINE_ID
, -1
, MR.INVENTORY_ITEM_ID
, MR.TRANSACTION_ID
FROM MRP_RECOMMENDATIONS MR
WHERE MR.DISPOSITION_STATUS_TYPE <> 2
AND MR.LINE_ID IS NOT NULL
AND MR.ORDER_TYPE NOT IN (13
, 16
, 4)

Columns