APPS.PO_CLM_UPG_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 237: FROM PO_LINE_LOCATIONS_DRAFT_ALL polla

233: , l_temp_entity_name_tbl
234: , l_temp_entity_pk2_tbl
235: , l_temp_entity_pk3_tbl
236: , l_temp_entity_pk4_tbl
237: FROM PO_LINE_LOCATIONS_DRAFT_ALL polla
238: WHERE polla.draft_id= l_draft_id_tbl(i);
239:
240: -- update tables
241: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update SHIPMENT Start');

Line 341: -- PO_LINE_LOCATIONS_DRAFT_ALL.OLD_AMOUNT

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:
345: UPDATE PO_HEADERS_DRAFT_ALL phd

Line 359: UPDATE PO_LINE_LOCATIONS_DRAFT_ALL phd

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
362: WHERE phb.line_location_id= phd.line_location_id)
363: WHERE phd.draft_id=l_draft_id_tbl(i);

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

360: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
361: FROM PO_LINE_LOCATIONS_ALL phb
362: WHERE phb.line_location_id= phd.line_location_id)
363: WHERE phd.draft_id=l_draft_id_tbl(i);
364: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINE_LOCATIONS_DRAFT_ALL'||SQL%ROWCOUNT);
365:
366: UPDATE PO_DISTRIBUTIONS_DRAFT_ALL phd
367: SET phd.OLD_AMOUNT_ORDERED = ( SELECT phb.AMOUNT_ORDERED
368: FROM PO_DISTRIBUTIONS_ALL phb