APPS.POA_SAVINGS_NP dependencies on PO_LINE_LOCATIONS_ALL

Line 53: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;

49:
50: e_error EXCEPTION;
51: l_start_time DATE;
52: l_end_time DATE;
53: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
54: v_ship_to_ou NUMBER;
55: v_rate_date DATE;
56: v_edw_global_rate_type edw_local_system_parameters.rate_type%type;
57: v_edw_global_currency_code EDW_LOCAL_SYSTEM_PARAMETERS.warehouse_currency_code%type;

Line 82: , po_line_locations_all psc

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
85: , po_headers_all phc
86: , po_headers_all ga

Line 326: , po_line_locations_all psc

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
327: , po_lines_all plc
328: , po_headers_all phc
329: , po_headers_all ga
330: WHERE inc.primary_key = pod.PO_DISTRIBUTION_ID

Line 506: , po_line_locations_all psc

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
508: , po_headers_all phc
509: , po_headers_all ga
510: , po_doc_style_headers style

Line 826: , po_line_locations_all psc

822: v_approved_date,
823: v_Currency_Conv_Rate
824: FROM gl_sets_of_books gl
825: , po_distributions_all pod
826: , po_line_locations_all psc
827: , po_lines_all plc
828: , po_headers_all phc
829: WHERE pod.po_distribution_id = p_po_distribution_id
830: and pod.line_location_id = psc.line_location_id