DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on PO_LINE_LOCATIONS_ALL

Line 3495: -- Insert the rows from po_line_locations_all

3491: IF PG_DEBUG <> 0 THEN
3492: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_line: ' || 'No of records inserted in lines = '||to_char(sql%rowcount),1);
3493: END IF;
3494:
3495: -- Insert the rows from po_line_locations_all
3496:
3497: -- Modified by Renga Kannan on 04/16/2002
3498: -- Added ship_to_location_id in the interface table.
3499:

Line 3583: from po_line_locations_all poll,

3579: poll.attribute15,
3580: sysdate
3581: -- p_price*poll.price_discount/100
3582: -- price_discount
3583: from po_line_locations_all poll,
3584: po_lines_all pol
3585: where pol.po_line_id = p_doc_line_id
3586: and pol.po_line_id = poll.po_line_id;
3587: