DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on PO_LINES_ALL

Line 2527: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um

2523: SELECT rcv.po_line_id
2524: , rcv.po_header_id
2525: INTO l_line_id
2526: , l_header_id
2527: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um
2528: WHERE rcv.transaction_id = p_transaction_id
2529: AND rcv.po_line_id = pol.po_line_id
2530: AND rcv.unit_of_measure = um.unit_of_measure;
2531:

Line 3263: FROM po_lines_all

3259: , inv_ic_order_pub.g_proc_line.auction_display_number
3260: , inv_ic_order_pub.g_proc_line.auction_line_number
3261: , inv_ic_order_pub.g_proc_line.bid_number
3262: , inv_ic_order_pub.g_proc_line.bid_line_number
3263: FROM po_lines_all
3264: WHERE po_line_id = p_line_id;
3265:
3266: print_debug('after selecting from po_lines_all ');
3267: print_debug('item_id = ' || inv_ic_order_pub.g_proc_line.item_id || ' organization_id = ' || inv_ic_order_pub.g_proc_line.org_id);

Line 3266: print_debug('after selecting from po_lines_all ');

3262: , inv_ic_order_pub.g_proc_line.bid_line_number
3263: FROM po_lines_all
3264: WHERE po_line_id = p_line_id;
3265:
3266: print_debug('after selecting from po_lines_all ');
3267: print_debug('item_id = ' || inv_ic_order_pub.g_proc_line.item_id || ' organization_id = ' || inv_ic_order_pub.g_proc_line.org_id);
3268: inv_ic_order_pub.g_proc_line.ic_receiving_org_id := p_to_org_id;
3269: inv_ic_order_pub.g_proc_line.ic_procuring_org_id := p_from_org_id;
3270: /* Bug Fix: 4324982*/