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]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_RESERVATIONS

Line 2984: from mtl_reservations where reservation_id = l_new_reservation_id;

2980: l_req_line_detail_id := p_req_line_detail_id;
2981:
2982: -- check how much reserved
2983: select reservation_quantity into l_total_reserved_qty
2984: from mtl_reservations where reservation_id = l_new_reservation_id;
2985:
2986: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2988: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2994: FROM mtl_reservations mr,

2990: end if;
2991:
2992: SELECT nvl(SUM(mr.reservation_quantity), 0)
2993: INTO l_already_res_qty
2994: FROM mtl_reservations mr,
2995: csp_req_line_details cd
2996: WHERE mr.reservation_id = cd.source_id
2997: AND cd.source_type = 'RES'
2998: AND cd.requirement_line_id = l_requirement_line_id

Line 3346: from mtl_reservations where reservation_id = l_reservation_id;

3342: ,p_source_id => l_reservation_id );
3343: end if;
3344:
3345: select reservation_quantity into l_total_reserved_qty
3346: from mtl_reservations where reservation_id = l_reservation_id;
3347:
3348: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3349: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3350: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3356: FROM mtl_reservations mr,

3352: end if;
3353:
3354: SELECT nvl(SUM(mr.reservation_quantity), 0)
3355: INTO l_already_res_qty
3356: FROM mtl_reservations mr,
3357: csp_requirement_lines cl,
3358: csp_req_line_details cd
3359: WHERE mr.reservation_id = cd.source_id
3360: AND cd.source_type = 'RES'