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.RCV_QUANTITIES_S dependencies on MTL_SUPPLY

Line 2565: from mtl_supply

2561: Enter Receipt form */
2562:
2563: select nvl(sum(decode(supply_type_code,'RECEIVING',quantity,0)),0)
2564: into l_quantity
2565: from mtl_supply
2566: where po_distribution_id = p_po_distribution_id;
2567:
2568: /* GMUDGAL - 04-FEB-98 - Bug #610897
2569: ** Here the problem was that if the shipment has been received

Line 2571: ** balance mtl_supply so the above select will raise no_data_found.

2567:
2568: /* GMUDGAL - 04-FEB-98 - Bug #610897
2569: ** Here the problem was that if the shipment has been received
2570: ** within tolerance then in the C code we are removing the
2571: ** balance mtl_supply so the above select will raise no_data_found.
2572: ** We now select from po_distributions the quantity yet to be
2573: ** delivered so that after exploding the distributions we don't
2574: ** see zero quantities
2575: ** Also see 624832.

Line 2858: FROM mtl_supply

2854: SELECT quantity,
2855: unit_of_measure
2856: INTO p_available_quantity,
2857: p_unit_of_measure
2858: FROM mtl_supply
2859: WHERE supply_type_code = 'RECEIVING'
2860: AND supply_source_id = p_transaction_id
2861: AND po_distribution_id = p_po_distribution_id;
2862:

Line 3360: FROM mtl_supply

3356: SELECT quantity,
3357: unit_of_measure
3358: INTO x_available_quantity,
3359: x_unit_of_measure
3360: FROM mtl_supply
3361: WHERE supply_type_code = 'SHIPMENT'
3362: AND supply_source_id = p_shipment_line_id
3363: AND po_distribution_id = p_distribution_id;
3364: