eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_INTERFACE_S dependencies on PO_REQUISITION_LINES_ALL

Line 353: g_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --

349: g_number_records_processed number;
350: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE; --
351: g_hdr_requesting_ou_id PO_HEADERS_ALL.org_id%TYPE; --
352: g_rate_for_req_fields NUMBER; --
353: g_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
354:
355: /* Global variable to hold number of req lines
356: ** in the po_lines_interface table. Thie determines
357: ** if we copy project_id, task_id from req to rfq

Line 914: from po_requisition_lines_all prl --

910: set pli.requisition_line_id= null
911: where pli.interface_header_id= x_interface_header_id
912: and exists
913: (select requisition_line_id
914: from po_requisition_lines_all prl --
915: where prl.requisition_line_id= pli.requisition_line_id
916: and (prl.line_location_id is not null
917: or prl.cancel_flag='Y'
918: or prl.closed_code='FINALLY CLOSED'

Line 939: FROM po_requisition_lines_all prl --

935: SET pli.requisition_line_id= null
936: WHERE pli.interface_header_id= x_interface_header_id
937: AND NOT EXISTS
938: (SELECT requisition_line_id
939: FROM po_requisition_lines_all prl --
940: WHERE prl.requisition_line_id= pli.requisition_line_id);
941:
942: end if;
943:

Line 2765: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;

2761: -- Bug 2875346.
2762: l_one_time_att_doc_id fnd_attached_documents.attached_document_id%TYPE;
2763:
2764: --
2765: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
2766: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
2767:
2768: l_return_status VARCHAR2(1);
2769:

Line 2793: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;

2789: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;
2790: l_need_by_date po_line_locations_all.need_by_date%TYPE;
2791: -- oneoff 3201308 end
2792:
2793: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
2794: --
2795:
2796: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE; --
2797:

Line 2810: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --

2806: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
2807: l_quantity_temp PO_LINES.QUANTITY%TYPE;
2808: --
2809:
2810: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
2811: l_rate_for_req_fields GL_DAILY_RATES.conversion_rate%TYPE; --
2812:
2813: --
2814: l_po_line_id_tbl po_line_id_tbl;

Line 2835: FROM po_requisition_lines_all prl

2831: THEN
2832: BEGIN
2833: SELECT prl.org_id
2834: INTO l_requesting_ou_id
2835: FROM po_requisition_lines_all prl
2836: WHERE prl.requisition_line_id = interface.requisition_line_id;
2837: EXCEPTION
2838: WHEN OTHERS
2839: THEN

Line 3866: FROM po_requisition_lines_all

3862: -- Changed ELSIF to ELSE
3863: ELSE
3864: l_progress := '400';
3865: SELECT negotiated_by_preparer_flag into l_negotiated_by_preparer_flag
3866: FROM po_requisition_lines_all
3867: WHERE requisition_line_id=interface.requisition_line_id;
3868: END IF;
3869: ELSE
3870: l_progress := '410';

Line 3872: FROM po_requisition_lines_all

3868: END IF;
3869: ELSE
3870: l_progress := '410';
3871: SELECT negotiated_by_preparer_flag into l_negotiated_by_preparer_flag
3872: FROM po_requisition_lines_all
3873: WHERE requisition_line_id=interface.requisition_line_id;
3874: END IF;
3875: EXCEPTION
3876: WHEN others THEN

Line 4832: FROM po_requisition_lines_all --

4828: -- Copy of the requisition header attachements to the purchase
4829: -- order line.
4830: SELECT requisition_header_id
4831: INTO x_requisition_header_id
4832: FROM po_requisition_lines_all --
4833: WHERE requisition_line_id = interface.requisition_line_id;
4834:
4835: l_progress:='660';
4836:

Line 4907: FROM po_requisition_lines_all --

4903: -- Copy of the requisition header attachements to the purchase
4904: -- order line.
4905: SELECT requisition_header_id
4906: INTO x_requisition_header_id
4907: FROM po_requisition_lines_all --
4908: WHERE requisition_line_id = interface.requisition_line_id;
4909:
4910: l_progress:='690';
4911:

Line 4950: FROM po_requisition_lines_all --

4946: x_column1:='NEGREQ';
4947: l_progress:='710';
4948: SELECT requisition_header_id
4949: INTO x_requisition_header_id
4950: FROM po_requisition_lines_all --
4951: WHERE requisition_line_id =interface.requisition_line_id;
4952: else
4953: x_column1:='NEG';
4954: end if;

Line 5092: UPDATE po_requisition_lines_all --

5088: END IF;
5089:
5090: IF (g_document_type = 'PO') THEN
5091: l_progress:='770';
5092: UPDATE po_requisition_lines_all --
5093: SET line_location_id = x_line_location_id,
5094: --
5095: reqs_in_pool_flag = NULL, --
5096: --

Line 5103: UPDATE po_requisition_lines_all --

5099: last_update_login = interface.last_update_login
5100: WHERE requisition_line_id = interface.requisition_line_id;
5101: ELSE
5102: l_progress := '780';
5103: UPDATE po_requisition_lines_all --
5104: SET on_rfq_flag = 'Y',
5105: last_update_date = interface.last_update_date,
5106: last_updated_by = interface.last_updated_by,
5107: last_update_login = interface.last_update_login

Line 6380: FROM po_requisition_lines_all --

6376: l_progress := '290';
6377: BEGIN
6378: SELECT requisition_header_id
6379: INTO x_p_req_header_id
6380: FROM po_requisition_lines_all --
6381: WHERE requisition_line_id = interface.requisition_line_id;
6382: EXCEPTION
6383: WHEN NO_DATA_FOUND THEN
6384: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 6498: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

6494: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
6495: x_conversion_rate number := 1;
6496:
6497: -- Bug 7661419, No conversion for same currency.
6498: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6499: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6500: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6501: -- Bug 7661419 end
6502: --

Line 6499: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

6495: x_conversion_rate number := 1;
6496:
6497: -- Bug 7661419, No conversion for same currency.
6498: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6499: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6500: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6501: -- Bug 7661419 end
6502: --
6503: --

Line 6500: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

6496:
6497: -- Bug 7661419, No conversion for same currency.
6498: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6499: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6500: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6501: -- Bug 7661419 end
6502: --
6503: --
6504: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;

Line 6608: FROM po_requisition_lines_all pol --

6604: --Even sourcing need to execute this when backed by a req.
6605: Begin
6606: SELECT KANBAN_CARD_ID
6607: INTO x_kanban_card_id
6608: FROM po_requisition_lines_all pol --
6609: WHERE pol.REQUISITION_LINE_ID = interface.requisition_line_id;
6610: Exception
6611: WHEN NO_DATA_FOUND THEN
6612: /* Not all req has kanban id */

Line 6875: FROM po_requisition_lines_all PRL

6871: SELECT PRL.currency_code,
6872: Nvl(PRL.rate,1)
6873: INTO x_req_currency_code,
6874: x_req_rate
6875: FROM po_requisition_lines_all PRL
6876: WHERE PRL.requisition_line_id = INTERFACE.requisition_line_id;
6877:
6878: EXCEPTION
6879: WHEN OTHERS THEN

Line 7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

7939:
7940: -- Bug 3463242 START
7941: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
7942: --
7943: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
7944: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
7945: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
7946: l_amount PO_LINES_INTERFACE.amount%TYPE;
7947: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;

Line 8010: PO_REQUISITION_LINES_ALL prl, --

8006: -- Bug 3463242 END
8007: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8008: PO_LINES_INTERFACE pli,
8009: PO_HEADERS_INTERFACE phi,
8010: PO_REQUISITION_LINES_ALL prl, --
8011: MTL_PARAMETERS mp,
8012: HR_ORGANIZATION_INFORMATION hoi,
8013: PO_LINE_TYPES_B plt -- Bug 3463242
8014: WHERE phi.interface_header_id = p_interface_header_id

Line 8458: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

8454: l_precision FND_CURRENCIES.precision%TYPE;
8455: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
8456: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
8457:
8458: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

Line 8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;

8456: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
8457:
8458: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
8464: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419

Line 8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;

8457:
8458: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
8464: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
8465:

Line 8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

8458: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
8464: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
8465:
8466: BEGIN

Line 8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;

8459: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
8464: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
8465:
8466: BEGIN
8467:

Line 8464: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419

8460: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
8461: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
8462: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
8463: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
8464: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
8465:
8466: BEGIN
8467:
8468: l_progress:='000'; PO_DEBUG.debug_begin(l_log_head);

Line 8500: FROM po_requisition_lines_all PRL

8496: SELECT PRL.currency_code,
8497: Nvl(PRL.rate,1)
8498: INTO l_req_currency_code,
8499: l_req_rate
8500: FROM po_requisition_lines_all PRL
8501: WHERE PRL.requisition_line_id = p_requisition_line_id;
8502:
8503: IF ( l_req_currency_code = p_po_currency_code ) THEN
8504: x_quantity := round ( x_quantity/l_req_rate, nvl(l_ext_precision, 15) );

Line 8539: FROM po_requisition_lines_all PRL,

8535: , l_req_unit_price
8536: , l_req_currency_unit_price
8537: , l_req_amount
8538: , l_req_currency_amount
8539: FROM po_requisition_lines_all PRL,
8540: financials_system_params_all FSP,
8541: gl_sets_of_books GSB
8542: WHERE PRL.requisition_line_id = p_requisition_line_id
8543: AND nvl(PRL.org_id, -99) = nvl(FSP.org_id, -99)

Line 9240: po_requisition_lines_all prl, --

9236: prl.drop_ship_flag, --
9237: prl.vmi_flag -- VMI FPH
9238: FROM po_lines_interface pli,
9239: po_headers_interface phi,
9240: po_requisition_lines_all prl, --
9241: po_line_types plt,
9242: po_lines_all pol --
9243: WHERE pli.interface_line_id = pli2.interface_line_id
9244: AND pli.interface_header_id = phi.interface_header_id

Line 9435: po_requisition_lines_all prl, --

9431: nvl(pli.contractor_last_name, prl.candidate_last_name)
9432: --
9433: FROM po_lines_interface pli,
9434: po_headers_interface phi,
9435: po_requisition_lines_all prl, --
9436: po_line_types plt
9437: WHERE pli.interface_line_id = pli2.interface_line_id
9438: AND pli.interface_header_id = phi.interface_header_id
9439: AND phi.interface_header_id = x_interface_header_id

Line 9579: FROM po_requisition_lines_all prl, --

9575: decode(pli.consigned_flag,'Y',null,
9576: prd.oke_contract_line_id),
9577: decode(pli.consigned_flag,'Y',null,
9578: prd.oke_contract_deliverable_id)
9579: FROM po_requisition_lines_all prl, --
9580: po_req_distributions_all prd, --
9581: po_lines_interface pli,
9582: po_headers_interface phi
9583: WHERE prd.requisition_line_id = prl.requisition_line_id

Line 9881: x_note_to_receiver po_requisition_lines_all.note_to_receiver%type;

9877: x_transaction_reason_code varchar2(25);
9878: x_need_by_date date;
9879: --togeorge 09/27/2000
9880: --added note to receiver and oke variables.
9881: x_note_to_receiver po_requisition_lines_all.note_to_receiver%type;
9882: x_oke_contract_header_id number;
9883: x_oke_contract_version_id number;
9884: x_vendor_product_num varchar2(30); --Bug# 1763933
9885: x_deliver_to_location_id number;

Line 10079: FROM po_requisition_lines_all prl -- Bug 3903445

10075: SET pli.shipment_num = 1,
10076: pli.line_num =
10077: (
10078: SELECT prl.line_num
10079: FROM po_requisition_lines_all prl -- Bug 3903445
10080: WHERE prl.requisition_line_id = pli.requisition_line_id
10081: )
10082: WHERE pli.interface_header_id = x_interface_header_id
10083: AND pli.line_num is null

Line 10275: FROM po_requisition_lines_all prl

10271:
10272: UPDATE po_lines_interface pli
10273: SET pli.shipment_num =
10274: ( SELECT prl.line_num
10275: FROM po_requisition_lines_all prl
10276: WHERE prl.requisition_line_id = pli.requisition_line_id )
10277: WHERE pli.interface_header_id = x_interface_header_id
10278: AND pli.shipment_num IS NULL;
10279:

Line 11060: , po_requisition_lines_all prl

11056:
11057: SELECT min(pli.line_num)
11058: INTO x_po_line_num
11059: FROM po_lines_interface pli
11060: , po_requisition_lines_all prl
11061: , po_line_types_b PLT --
11062: WHERE pli.interface_header_id = x_interface_header_id
11063: AND pli.line_num is not null
11064: AND prl.requisition_line_id <> x_requisition_line_id

Line 11998: PO_REQUISITION_LINES_ALL PRL, --

11994:
11995: SELECT PLL.shipment_num
11996: INTO x_po_shipment_num
11997: FROM PO_LINE_LOCATIONS_ALL PLL, --
11998: PO_REQUISITION_LINES_ALL PRL, --
11999: PO_SYSTEM_PARAMETERS_ALL PSP --
12000: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
12001: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12002: AND rtrim(nvl(PLL.note_to_receiver,'99')) = rtrim(nvl(x_note_to_receiver,'99'))

Line 12069: PO_REQUISITION_LINES_ALL PRL, --

12065:
12066: SELECT PLL.shipment_num
12067: INTO x_po_shipment_num
12068: FROM PO_LINE_LOCATIONS_ALL PLL, --
12069: PO_REQUISITION_LINES_ALL PRL, --
12070: PO_SYSTEM_PARAMETERS_ALL PSP --
12071: WHERE PLL.PO_LINE_ID = x_po_line_id
12072: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12073: --Bug4599140 (included the following OR condition so that the SQL works correctly

Line 12301: po_requisition_lines_all prl, --

12297: 'SHOP FLOOR','Y')
12298: INTO x_receipt_required_flag
12299: FROM po_lines_interface pli,
12300: po_headers_interface phi,
12301: po_requisition_lines_all prl, --
12302: mtl_system_items msi,
12303: po_line_types plt,
12304: po_vendors pov,
12305: po_system_parameters_all psp, --

Line 12363: PO_REQUISITION_LINES_ALL PRL, --

12359: ,PLI.requisition_line_id
12360: INTO x_po_shipment_num
12361: ,x_req_line_to_check
12362: FROM PO_LINES_INTERFACE PLI,
12363: PO_REQUISITION_LINES_ALL PRL, --
12364: --bug 1942696 hr_location changes to reflect the new view
12365: MTL_SYSTEM_ITEMS MSI ,
12366: PO_LINE_TYPES PLT ,
12367: PO_SYSTEM_PARAMETERS_ALL PSP , --

Line 12485: PO_REQUISITION_LINES_ALL PRL, --

12481: */
12482: SELECT PLI.shipment_num
12483: INTO x_po_shipment_num
12484: FROM PO_LINES_INTERFACE PLI,
12485: PO_REQUISITION_LINES_ALL PRL, --
12486: MTL_SYSTEM_ITEMS MSI ,
12487: PO_LINE_TYPES PLT ,
12488: PO_SYSTEM_PARAMETERS_ALL PSP , --
12489: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

Line 12612: PO_REQUISITION_LINES_ALL PRL, --

12608: l_progress:='190';
12609: SELECT PLI.shipment_num
12610: INTO x_po_shipment_num
12611: FROM PO_LINES_INTERFACE PLI,
12612: PO_REQUISITION_LINES_ALL PRL, --
12613: --bug 1942696 hr_location changes to reflect the new view
12614: MTL_SYSTEM_ITEMS MSI ,
12615: PO_LINE_TYPES PLT ,
12616: PO_SYSTEM_PARAMETERS_ALL PSP , --

Line 13029: po_requisition_lines_all prl --

13025: x_allow_different_uoms IN VARCHAR2 -- Bug 2707576
13026: ) IS
13027: SELECT MIN(pol.line_num)
13028: FROM po_lines_all pol,
13029: po_requisition_lines_all prl --
13030: WHERE pol.po_header_id = p_po_header_id
13031: AND prl.requisition_line_id = p_requisition_line_id
13032: AND NVL(pol.cancel_flag,'N') = 'N'
13033: AND NVL(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 13101: po_requisition_lines_all prl --

13097: x_allow_different_uoms IN VARCHAR2 -- Bug 2707576
13098: ) IS
13099: SELECT MIN(pol.line_num)
13100: FROM po_lines_all pol,
13101: po_requisition_lines_all prl --
13102: WHERE pol.po_header_id = p_po_header_id
13103: AND prl.requisition_line_id = p_requisition_line_id
13104: AND NVL(pol.cancel_flag,'N') = 'N'
13105: AND NVL(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 13175: from po_requisition_lines_all --

13171: WHERE NVL(org_id, -99) = NVL(p_purchasing_ou_id, -99); --
13172:
13173: select item_id
13174: into x_item_id
13175: from po_requisition_lines_all --
13176: where requisition_line_id = x_requisition_line_id;
13177:
13178: if x_item_id is not null then
13179: SELECT msi.revision_qty_control_code

Line 14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;

14020: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:
14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14025: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14026: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
14027:
14028: l_tax_name AP_TAX_CODES.name%TYPE;

Line 14025: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;

14021: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:
14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14025: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14026: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
14027:
14028: l_tax_name AP_TAX_CODES.name%TYPE;
14029: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;

Line 14026: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;

14022: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14023:
14024: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14025: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14026: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
14027:
14028: l_tax_name AP_TAX_CODES.name%TYPE;
14029: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;
14030: l_tax_type AP_TAX_CODES.tax_type%TYPE;

Line 14354: FROM po_requisition_lines_all prl

14350: INTO l_req_tax_code_id
14351: , l_req_tax_user_override_flag
14352: , l_req_tax_status_indicator
14353: , g_line_requesting_ou_id
14354: FROM po_requisition_lines_all prl
14355: WHERE prl.requisition_line_id = interface.requisition_line_id;
14356:
14357: l_tax_code_id := l_req_tax_code_id;
14358:

Line 14997: , po_requisition_lines_all prl

14993: END)
14994: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
14995: FROM po_line_locations_all poll
14996: , po_req_distributions_all prd
14997: , po_requisition_lines_all prl
14998: WHERE poll.po_line_id = p_po_line_id
14999: AND prd.requisition_line_id = p_req_line_id
15000: AND prl.requisition_line_id = prd.requisition_line_id
15001: AND poll.payment_type <> 'ADVANCE';