View: MRPFV_BILL_OF_RESOURCES

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPFV_BILL_OF_RESOURCES

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, BI.BILL_OF_RESOURCES
, BI.DESCRIPTION
, BI.DISABLE_DATE
, '_DF:CRP:CRP_BILLS_OF_RESOURCES:BI'
, BI.ORGANIZATION_ID
, BI.LAST_UPDATE_DATE
, BI.LAST_UPDATED_BY
, BI.CREATION_DATE
, BI.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, CRP_BILLS_OF_RESOURCES BI
WHERE BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns