APPS.PO_CLM_UPG_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 263: FROM PO_DISTRIBUTIONS_DRAFT_ALL pod

259: , l_temp_entity_name_tbl
260: , l_temp_entity_pk2_tbl
261: , l_temp_entity_pk3_tbl
262: , l_temp_entity_pk4_tbl
263: FROM PO_DISTRIBUTIONS_DRAFT_ALL pod
264: WHERE pod.draft_id= l_draft_id_tbl(i);
265:
266: -- update tables
267: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update DISTRIBUTION Start');

Line 342: -- PO_DISTRIBUTIONS_DRAFT_ALL.OLD_AMOUNT_ORDERED

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
346: SET phd.OLD_AMOUNT_LIMIT = ( SELECT phb.AMOUNT_LIMIT

Line 366: UPDATE PO_DISTRIBUTIONS_DRAFT_ALL phd

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
369: WHERE phb.po_distribution_id= phd.po_distribution_id)
370: WHERE phd.draft_id=l_draft_id_tbl(i);

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

367: SET phd.OLD_AMOUNT_ORDERED = ( SELECT phb.AMOUNT_ORDERED
368: FROM PO_DISTRIBUTIONS_ALL phb
369: WHERE phb.po_distribution_id= phd.po_distribution_id)
370: WHERE phd.draft_id=l_draft_id_tbl(i);
371: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DISTRIBUTIONS_DRAFT_ALL'||SQL%ROWCOUNT);
372:
373: UPDATE PO_DRAFTS phd
374: SET phd.AGENT_ID = ( SELECT phb.AGENT_ID
375: FROM PO_HEADERS_ALL phb