APPS.PO_CLM_UPG_PVT dependencies on PO_LINES_DRAFT_ALL

Line 211: FROM po_lines_draft_all pola

207: , l_temp_entity_name_tbl
208: , l_temp_entity_pk2_tbl
209: , l_temp_entity_pk3_tbl
210: , l_temp_entity_pk4_tbl
211: FROM po_lines_draft_all pola
212: WHERE pola.draft_id= l_draft_id_tbl(i);
213:
214: -- update tables
215: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update Lines Start');

Line 340: -- PO_LINES_DRAFT_ALL.OLD_AMOUNT

336: );
337:
338:
339: --update PO_HEADERS_DRAFT_ALL.OLD_AMOUNT_LIMIT
340: -- PO_LINES_DRAFT_ALL.OLD_AMOUNT
341: -- PO_LINE_LOCATIONS_DRAFT_ALL.OLD_AMOUNT
342: -- PO_DISTRIBUTIONS_DRAFT_ALL.OLD_AMOUNT_ORDERED
343: -- PO_DRAFTS.AGENT_ID
344:

Line 352: UPDATE PO_LINES_DRAFT_ALL phd

348: WHERE phb.po_header_id=phd.po_header_id)
349: WHERE phd.draft_id=l_draft_id_tbl(i);
350: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_HEADERS_DRAFT_ALL'||SQL%ROWCOUNT);
351:
352: UPDATE PO_LINES_DRAFT_ALL phd
353: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
354: FROM PO_LINES_ALL phb
355: WHERE phb.po_line_id= phd.po_line_id)
356: WHERE phd.draft_id=l_draft_id_tbl(i);

Line 357: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINES_DRAFT_ALL'||SQL%ROWCOUNT);

353: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
354: FROM PO_LINES_ALL phb
355: WHERE phb.po_line_id= phd.po_line_id)
356: WHERE phd.draft_id=l_draft_id_tbl(i);
357: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINES_DRAFT_ALL'||SQL%ROWCOUNT);
358:
359: UPDATE PO_LINE_LOCATIONS_DRAFT_ALL phd
360: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
361: FROM PO_LINE_LOCATIONS_ALL phb