APPS.POA_SAVINGS_NP dependencies on POA_EDW_PO_DIST_INC

Line 80: FROM poa_edw_po_dist_inc inc,

76: , psc.ship_to_organization_id
77: , to_number(hro.org_information3) org_information3
78: , nvl(pod.rate_date,pod.creation_date) rate_date
79: , phc.rate_type
80: FROM poa_edw_po_dist_inc inc,
81: po_distributions_all pod
82: , po_line_locations_all psc
83: , po_lines_all plc
84: , po_doc_style_headers style

Line 177: (SELECT primary_key FROM poa_edw_po_dist_inc WHERE batch_id = p_batch_no);

173: x_progress := '015';
174:
175: DELETE FROM poa_bis_savings poa
176: WHERE distribution_transaction_id IN
177: (SELECT primary_key FROM poa_edw_po_dist_inc WHERE batch_id = p_batch_no);
178:
179: /* Insert rows for POs created for one-time items in which no blankets
180: * exists (non-contracts)
181: */

Line 322: FROM poa_edw_po_dist_inc inc,

318: , fnd_global.conc_request_id
319: , fnd_global.prog_appl_id
320: , fnd_global.conc_program_id
321: , p_start_time
322: FROM poa_edw_po_dist_inc inc,
323: gl_sets_of_books gl
324: , po_distributions_all pod
325: , po_doc_style_headers style
326: , po_line_locations_all psc

Line 503: FROM poa_edw_po_dist_inc inc,

499: , fnd_global.conc_request_id
500: , fnd_global.prog_appl_id
501: , fnd_global.conc_program_id
502: , p_start_time
503: FROM poa_edw_po_dist_inc inc,
504: gl_sets_of_books gl
505: , po_distributions_all pod
506: , po_line_locations_all psc
507: , po_lines_all plc