DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on PER_JOBS_VL

Line 206: l_job_name PER_JOBS_VL.name%TYPE;

202: --
203: l_value_basis PO_REQUISITION_LINES.order_type_lookup_code%TYPE;
204: l_req_line_id PO_REQUISITION_LINES.requisition_line_id%TYPE;
205: l_amount PO_REQUISITION_LINES.amount%TYPE;
206: l_job_name PER_JOBS_VL.name%TYPE;
207: l_job_long_description PO_REQUISITION_LINES.job_long_description%TYPE;
208: l_has_price_diff_flag VARCHAR2(1);
209: l_bid_start_price PO_REQUISITION_LINES.unit_price%TYPE;
210: l_po_agreed_amount PO_REQUISITION_LINES.amount%TYPE;

Line 563: per_jobs_vl PJ,

559: l_job_long_description, --
560: l_from_org_id */ --
561: from po_requisition_lines_all rl, --
562: mtl_system_items_kfv msi,
563: per_jobs_vl PJ,
564: PO_SESSION_GT psg --
565: where requisition_line_id = psg.key --
566: and rl.item_id = msi.inventory_item_id(+)
567: and nvl(msi.organization_id, rl.destination_organization_id) =