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.

APPS.CHV_LOAD_ORDERS dependencies on MRP_RECOMMENDATIONS

Line 321: -- Quantity in mrp_recommendations is always represented in primary uom.

317: X_transaction_id NUMBER;
318:
319: -- The new quantity represents the planned orders. The Quantity in Process
320: -- represents planned orders that have been implemented from the workbench.
321: -- Quantity in mrp_recommendations is always represented in primary uom.
322: -- This coresponds to recrods in the requisition interface table waiting
323: -- for req import to process them. From the email I sent earlier this
324: -- week: In order to get the unimplemented quantity of planned orders you
325: -- should use: NVL(firm_quantity, new_order_quantity) -

Line 340: from mrp_recommendations mrp

336: CURSOR C1 is select transaction_id,
337: nvl(firm_date,new_dock_date),
338: NVL(firm_quantity, new_order_quantity) -
339: (NVL(quantity_in_process,0) + nvl(implemented_quantity,0) )
340: from mrp_recommendations mrp
341: where mrp.organization_id = x_organization_id
342: and mrp.source_vendor_id = x_vendor_id
343: and x_vendor_site_id =
344: (select distinct pvs.vendor_site_id