VIEW: APPS.CRP_RESOURCE_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)