APPS.AP_RETRO_PRICING_PKG dependencies on MO_GLOBAL

Line 78: WHERE mo_global.check_access(pd.org_id) = 'Y'

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'
81: AND pd.org_id = p_org_id
82: AND pd.vendor_id = DECODE(p_vendor_id, NULL,

Line 111: WHERE mo_global.check_access(pd.org_id) = ''Y''

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'' ' ;
114:
115: IF ( p_org_id is NOT NULL) then

Line 302: WHERE mo_global.check_access(pd.org_id) = 'Y'

298: po_releases_all pr,
299: po_lines_all pl,
300: po_line_locations_all pll,
301: ap_invoices_interface aii
302: WHERE mo_global.check_access(pd.org_id) = 'Y'
303: AND pd.po_header_id = ph.po_header_id
304: AND pd.po_release_id = pr.po_release_id(+)
305: AND pd.po_line_id = pl.po_line_id
306: AND pd.line_location_id = pll.line_location_id

Line 535: WHERE mo_global.check_access(pd.org_id) = 'Y'

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'
538: AND pd.vendor_id = DECODE(p_vendor_id, NULL,
539: pd.vendor_id, p_vendor_id)