DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on PO_LINES_ALL

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

2431: SELECT rcv.po_line_id
2432: , rcv.po_header_id
2433: INTO l_line_id
2434: , l_header_id
2435: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um
2436: WHERE rcv.transaction_id = p_transaction_id
2437: AND rcv.po_line_id = pol.po_line_id
2438: AND rcv.unit_of_measure = um.unit_of_measure;
2439:

Line 3162: FROM po_lines_all

3158: , inv_ic_order_pub.g_proc_line.auction_display_number
3159: , inv_ic_order_pub.g_proc_line.auction_line_number
3160: , inv_ic_order_pub.g_proc_line.bid_number
3161: , inv_ic_order_pub.g_proc_line.bid_line_number
3162: FROM po_lines_all
3163: WHERE po_line_id = p_line_id;
3164:
3165: print_debug('after selecting from po_lines_all ');
3166: 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 3165: print_debug('after selecting from po_lines_all ');

3161: , inv_ic_order_pub.g_proc_line.bid_line_number
3162: FROM po_lines_all
3163: WHERE po_line_id = p_line_id;
3164:
3165: print_debug('after selecting from po_lines_all ');
3166: print_debug('item_id = ' || inv_ic_order_pub.g_proc_line.item_id || ' organization_id = ' || inv_ic_order_pub.g_proc_line.org_id);
3167: inv_ic_order_pub.g_proc_line.ic_receiving_org_id := p_to_org_id;
3168: inv_ic_order_pub.g_proc_line.ic_procuring_org_id := p_from_org_id;
3169: /* Bug Fix: 4324982*/