DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on PO_VENDORS

Line 78: po_vendors pv

74: SELECT DISTINCT pd.vendor_id,
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

Line 111: po_vendors pv

107: sql_stmt := 'SELECT DISTINCT pd.vendor_id,
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:

Line 544: po_vendors pv

540:
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,