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 3139: from mtl_supply

3135: Enter Receipt form */
3136:
3137: select nvl(sum(decode(supply_type_code,'RECEIVING',quantity,0)),0)
3138: into l_quantity
3139: from mtl_supply
3140: where po_distribution_id = p_po_distribution_id;
3141:
3142: /* GMUDGAL - 04-FEB-98 - Bug #610897
3143: ** Here the problem was that if the shipment has been received

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

3141:
3142: /* GMUDGAL - 04-FEB-98 - Bug #610897
3143: ** Here the problem was that if the shipment has been received
3144: ** within tolerance then in the C code we are removing the
3145: ** balance mtl_supply so the above select will raise no_data_found.
3146: ** We now select from po_distributions the quantity yet to be
3147: ** delivered so that after exploding the distributions we don't
3148: ** see zero quantities
3149: ** Also see 624832.

Line 3670: FROM mtl_supply

3666: SELECT quantity,
3667: unit_of_measure
3668: INTO p_available_quantity,
3669: p_unit_of_measure
3670: FROM mtl_supply
3671: WHERE supply_type_code = 'RECEIVING'
3672: AND supply_source_id = p_transaction_id
3673: AND po_distribution_id = p_po_distribution_id;
3674:

Line 4210: FROM mtl_supply

4206: SELECT quantity,
4207: unit_of_measure
4208: INTO x_available_quantity,
4209: x_unit_of_measure
4210: FROM mtl_supply
4211: WHERE supply_type_code = 'SHIPMENT'
4212: AND supply_source_id = p_shipment_line_id
4213: AND po_distribution_id = p_distribution_id;
4214: