eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_I2_NEW_PO_REQ_V

Product:	MRP - Master Scheduling/MRP
Description:	A Rhythm view supporting information regarding new Purchase Orders created
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PMV.INVENTORY_ITEM_ID
, PMV.ORGANIZATION_ID
, PBP.QUANTITY
, PBP.NEED_DATE - PMV.POSTPROCESSING_LEADTIME
, 'I2'
, 'INVENTORY'
, LOC.LOCATION_ID
, HR.EMPLOYEE_ID
, HR.EMPLOYEE_ID
, NULL
, 'APPROVED'
, PMV.UOM
, PMV.ORGANIZATION_ID
, 'Y'
FROM HR_LOCATIONS LOC
, HR_ORGANIZATION_UNITS PER
, FND_USER FND
, HR_EMPLOYEES_CURRENT_V HR
, MRP_I2_PART_MASTER_V PMV
, MRP_I2_PROC_BY_PART PBP
WHERE PMV.PART_NUMBER = PBP.PART_NUMBER
AND PMV.ORGANIZATION_ID = PBP.ORGANIZATION_ID
AND MRP_I2_ERP.GET_START_DATE(PMV.ORGANIZATION_ID) + PMV.PLANNING_TIME_FENCE >= PBP.RELEASE_DATE
AND PER.ORGANIZATION_ID = PBP.ORGANIZATION_ID
AND FND.USER_ID = TO_NUMBER(FND_GLOBAL.USER_ID)
AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
AND LOC.LOCATION_ID=PER.LOCATION_ID

Columns

Name
ITEM_ID
ORGANIZATION_ID
QUANTITY
NEED_BY_DATE
INTERFACE_SOURCE_CODE
DESTINATION_TYPE_CODE
DELIVER_TO_LOCATION_ID
DELIVER_TO_REQUESTOR_ID
PREPARER_ID
SOURCE_TYPE_CODE
AUTHORIZATION_STATUS
UOM_CODE
DESTINATION_ORGANIZATON_ID
AUTOSOURCE_CODE