APPS.AP_RETRO_PRICING_PKG dependencies on MO_GLOBAL

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

75: pv.segment1, -- supplier number
76: pv.vendor_name
77: FROM po_ap_retroactive_dist_v pd,
78: po_vendors pv
79: WHERE mo_global.check_access(pd.org_id) = 'Y'
80: AND pd.vendor_id = pv.vendor_id
81: AND pd.invoice_adjustment_flag = 'R'
82: AND pd.org_id = p_org_id
83: AND pd.vendor_id = DECODE(p_vendor_id, NULL,

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

108: pv.segment1, -- supplier number
109: pv.vendor_name
110: FROM po_ap_retroactive_dist_v pd,
111: po_vendors pv
112: WHERE mo_global.check_access(pd.org_id) = ''Y''
113: AND pd.vendor_id = pv.vendor_id
114: AND pd.invoice_adjustment_flag = ''R'' ' ;
115:
116: IF ( p_org_id is NOT NULL) then

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

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

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

541: CURSOR orgs IS
542: SELECT DISTINCT pd.org_id
543: FROM po_ap_retroactive_dist_v pd,
544: po_vendors pv
545: WHERE mo_global.check_access(pd.org_id) = 'Y'
546: AND pd.vendor_id = pv.vendor_id
547: AND pd.invoice_adjustment_flag = 'R'
548: AND pd.vendor_id = DECODE(p_vendor_id, NULL,
549: pd.vendor_id, p_vendor_id)