APPS.PA_EXPENDITURE_INQUIRY dependencies on PO_VENDORS

Line 80: from po_vendors vend,

76: cdl.system_reference2,
77: vend.vendor_name,
78: vend.segment1,
79: cdl.burden_sum_rejection_code
80: from po_vendors vend,
81: PA_COST_DIST_LINES_ALL_BAS cdl
82: where cdl.expenditure_item_id = p_expenditure_item_id
83: and cdl.line_num (+) = 1
84: /* Added the getNumericString wrapper over systeem_reference1 for bug3158748 */

Line 88: l_vendor_id po_vendors.vendor_id%type;

84: /* Added the getNumericString wrapper over systeem_reference1 for bug3158748 */
85: and pa_utils4.getNumericString(cdl.system_reference1) = vend.vendor_id (+) ;
86: /* Start: Added temp variables for bug 7283824 */
87: l_exp_id pa_expenditure_items_all.expenditure_id%type;
88: l_vendor_id po_vendors.vendor_id%type;
89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;
90: l_vendor_name po_vendors.vendor_name%type;
91: l_vendor_number po_vendors.segment1%type;
92: l_burden_sum_rej_code pa_cost_dist_lines_all_bas.burden_sum_rejection_code%type;

Line 90: l_vendor_name po_vendors.vendor_name%type;

86: /* Start: Added temp variables for bug 7283824 */
87: l_exp_id pa_expenditure_items_all.expenditure_id%type;
88: l_vendor_id po_vendors.vendor_id%type;
89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;
90: l_vendor_name po_vendors.vendor_name%type;
91: l_vendor_number po_vendors.segment1%type;
92: l_burden_sum_rej_code pa_cost_dist_lines_all_bas.burden_sum_rejection_code%type;
93: /* End: Added temp variables for bug 7283824 */
94:

Line 91: l_vendor_number po_vendors.segment1%type;

87: l_exp_id pa_expenditure_items_all.expenditure_id%type;
88: l_vendor_id po_vendors.vendor_id%type;
89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;
90: l_vendor_name po_vendors.vendor_name%type;
91: l_vendor_number po_vendors.segment1%type;
92: l_burden_sum_rej_code pa_cost_dist_lines_all_bas.burden_sum_rejection_code%type;
93: /* End: Added temp variables for bug 7283824 */
94:
95: BEGIN

Line 135: from po_vendors po

131: expenditure_item_id=p_expenditure_item_id;
132:
133: select po.vendor_id,po.vendor_name,po.segment1
134: into x_vendor_id,x_vendor_name,x_vendor_number
135: from po_vendors po
136: where
137: po.vendor_id=(select vendor_id from pa_expenditures_all exp where expenditure_id=l_exp_id);
138:
139: end if;