APPS.AP_RETRO_PRICING_PKG dependencies on PO_AP_RETROACTIVE_DIST_V

Line 76: FROM po_ap_retroactive_dist_v pd,

72: CURSOR vendor IS
73: SELECT DISTINCT pd.vendor_id,
74: pv.segment1, -- supplier number
75: pv.vendor_name
76: FROM po_ap_retroactive_dist_v pd,
77: po_vendors pv
78: WHERE mo_global.check_access(pd.org_id) = 'Y'
79: AND pd.vendor_id = pv.vendor_id
80: AND pd.invoice_adjustment_flag = 'R'

Line 109: FROM po_ap_retroactive_dist_v pd,

105:
106: sql_stmt := 'SELECT DISTINCT pd.vendor_id,
107: pv.segment1, -- supplier number
108: pv.vendor_name
109: FROM po_ap_retroactive_dist_v pd,
110: po_vendors pv
111: WHERE mo_global.check_access(pd.org_id) = ''Y''
112: AND pd.vendor_id = pv.vendor_id
113: AND pd.invoice_adjustment_flag = ''R'' ' ;

Line 296: FROM po_ap_retroactive_dist_v pd,

292: pd.po_release_id,
293: pr.release_num,
294: pd.price_override,
295: aii.invoice_id
296: FROM po_ap_retroactive_dist_v pd,
297: po_headers_all ph,
298: po_releases_all pr,
299: po_lines_all pl,
300: po_line_locations_all pll,

Line 533: FROM po_ap_retroactive_dist_v pd,

529: l_org_id_list id_list_type;
530:
531: CURSOR orgs IS
532: SELECT DISTINCT pd.org_id
533: FROM po_ap_retroactive_dist_v pd,
534: po_vendors pv
535: WHERE mo_global.check_access(pd.org_id) = 'Y'
536: AND pd.vendor_id = pv.vendor_id
537: AND pd.invoice_adjustment_flag = 'R'

Line 666: UPDATE PO_AP_RETROACTIVE_DIST_V

662: IF p_resubmit_flag <> 'Y' THEN
663:
664: FORALL i in 1..l_po_line_loc_id_list.COUNT
665:
666: UPDATE PO_AP_RETROACTIVE_DIST_V
667: SET invoice_adjustment_flag = 'S'
668: WHERE line_location_id = l_po_line_loc_id_list(i);
669:
670: END IF;