DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on PO_VENDORS

Line 77: po_vendors pv

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'
81: AND pd.org_id = p_org_id

Line 110: po_vendors pv

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'' ' ;
114:

Line 534: po_vendors pv

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