VIEW: APPS.MRPFV_BILL_OF_RESOURCE_ITEMS

Source

View Text - Preformatted

SELECT para.ORGANIZATION_CODE ,org.NAME ,bill.BILL_OF_RESOURCES ,'_KF:INV:MSTK:ITEM' ,'_DF:CRP:CRP_BILL_OF_RESOURCE_ITEMS:BILL' ,bill.organization_id ,bill.inventory_item_id ,bill.LAST_UPDATE_DATE ,bill.LAST_UPDATED_BY ,bill.CREATION_DATE ,bill.CREATED_BY FROM MTL_PARAMETERS PARA ,HR_ALL_ORGANIZATION_UNITS ORG ,MTL_SYSTEM_ITEMS ITEM ,CRP_BILLS_OF_RESOURCES BILLRES ,CRP_BILL_OF_RESOURCE_ITEMS BILL WHERE PARA.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND ITEM.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND ITEM.INVENTORY_ITEM_ID = BILL.INVENTORY_ITEM_ID AND BILLRES.ORGANIZATION_ID = BILL.ORGANIZATION_ID AND BILLRES.BILL_OF_RESOURCES = BILL.BILL_OF_RESOURCES AND '_SEC:BILL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PARA.ORGANIZATION_CODE
, ORG.NAME
, BILL.BILL_OF_RESOURCES
, '_KF:INV:MSTK:ITEM'
, '_DF:CRP:CRP_BILL_OF_RESOURCE_ITEMS:BILL'
, BILL.ORGANIZATION_ID
, BILL.INVENTORY_ITEM_ID
, BILL.LAST_UPDATE_DATE
, BILL.LAST_UPDATED_BY
, BILL.CREATION_DATE
, BILL.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SYSTEM_ITEMS ITEM
, CRP_BILLS_OF_RESOURCES BILLRES
, CRP_BILL_OF_RESOURCE_ITEMS BILL
WHERE PARA.ORGANIZATION_ID = BILL.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = BILL.ORGANIZATION_ID
AND ITEM.ORGANIZATION_ID = BILL.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = BILL.INVENTORY_ITEM_ID
AND BILLRES.ORGANIZATION_ID = BILL.ORGANIZATION_ID
AND BILLRES.BILL_OF_RESOURCES = BILL.BILL_OF_RESOURCES
AND '_SEC:BILL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY