APPS.PO_NEGOTIATIONS_SV1 dependencies on PER_JOBS_VL

Line 361: l_job_name PER_JOBS_VL.name%TYPE;

357: --
358: l_value_basis PO_REQUISITION_LINES.order_type_lookup_code%TYPE;
359: l_req_line_id PO_REQUISITION_LINES.requisition_line_id%TYPE;
360: l_amount PO_REQUISITION_LINES.amount%TYPE;
361: l_job_name PER_JOBS_VL.name%TYPE;
362: l_job_long_description PO_REQUISITION_LINES.job_long_description%TYPE;
363: l_has_price_diff_flag VARCHAR2(1);
364: l_bid_start_price PO_REQUISITION_LINES.unit_price%TYPE;
365: l_po_agreed_amount PO_REQUISITION_LINES.amount%TYPE;

Line 862: per_jobs_vl PJ,

858: l_job_long_description, --
859: l_from_org_id */ --
860: from po_requisition_lines_all rl, --
861: mtl_system_items_kfv msi,
862: per_jobs_vl PJ,
863: PO_SESSION_GT psg --
864: where requisition_line_id = psg.key --
865: and rl.item_id = msi.inventory_item_id(+)
866: and coalesce(msi.organization_id, rl.destination_organization_id,-1) =

Line 2447: l_job_name PER_JOBS_VL.name%TYPE;

2443: l_neg_outcome Varchar2(40);
2444: l_value_basis PO_REQUISITION_LINES.order_type_lookup_code%TYPE;
2445: l_req_line_id PO_REQUISITION_LINES.requisition_line_id%TYPE;
2446: l_amount PO_REQUISITION_LINES.amount%TYPE;
2447: l_job_name PER_JOBS_VL.name%TYPE;
2448: l_job_long_description PO_REQUISITION_LINES.job_long_description%TYPE;
2449: l_has_price_diff_flag VARCHAR2(1);
2450: l_bid_start_price PO_REQUISITION_LINES.unit_price%TYPE;
2451: l_po_agreed_amount PO_REQUISITION_LINES.amount%TYPE;

Line 2753: per_jobs_vl PJ,

2749: decode(rl.CONTRACT_TYPE, null, null, ''IDC_NA''),
2750: rl.UDA_TEMPLATE_ID --
2751: from po_requisition_lines_all rl, --
2752: mtl_system_items_kfv msi,
2753: per_jobs_vl PJ,
2754: PO_SESSION_GT psg --
2755: where requisition_line_id = psg.key --
2756: and rl.item_id = msi.inventory_item_id(+)
2757: and coalesce(msi.organization_id, rl.destination_organization_id,-1) =