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

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

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

Line 1106: from po_requisition_lines_all prl --

1102: set pli.requisition_line_id= null
1103: where pli.interface_header_id= x_interface_header_id
1104: and exists
1105: (select requisition_line_id
1106: from po_requisition_lines_all prl --
1107: where prl.requisition_line_id= pli.requisition_line_id
1108: and (prl.line_location_id is not null
1109: or prl.cancel_flag='Y'
1110: or prl.closed_code='FINALLY CLOSED'

Line 1118: --bug#2729465, with drawn req lines are deleted from po_requisition_lines

1114: )
1115: );
1116:
1117: l_progress := '070';
1118: --bug#2729465, with drawn req lines are deleted from po_requisition_lines
1119: --table. Hence require a separate update.
1120: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
1121: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1122: p_token => l_progress,

Line 1131: FROM po_requisition_lines_all prl --

1127: SET pli.requisition_line_id= null
1128: WHERE pli.interface_header_id= x_interface_header_id
1129: AND NOT EXISTS
1130: (SELECT requisition_line_id
1131: FROM po_requisition_lines_all prl --
1132: WHERE prl.requisition_line_id= pli.requisition_line_id);
1133:
1134: end if;
1135:

Line 3102: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;

3098: -- Bug 2875346.
3099: l_one_time_att_doc_id fnd_attached_documents.attached_document_id%TYPE;
3100:
3101: --
3102: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
3103: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
3104:
3105: l_return_status VARCHAR2(1);
3106:

Line 3130: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;

3126: l_ship_to_org po_line_locations_all.ship_to_organization_id%TYPE;
3127: l_need_by_date po_line_locations_all.need_by_date%TYPE;
3128: -- oneoff 3201308 end
3129:
3130: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
3131: --
3132:
3133: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE; --
3134:

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

3143: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
3144: l_quantity_temp PO_LINES.QUANTITY%TYPE;
3145: --
3146:
3147: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
3148: l_rate_for_req_fields GL_DAILY_RATES.conversion_rate%TYPE; --
3149:
3150: --
3151: l_po_line_id_tbl po_line_id_tbl;

Line 3178: FROM po_requisition_lines_all prl

3174: THEN
3175: BEGIN
3176: SELECT prl.org_id
3177: INTO l_requesting_ou_id
3178: FROM po_requisition_lines_all prl
3179: WHERE prl.requisition_line_id = interface.requisition_line_id;
3180: EXCEPTION
3181: WHEN OTHERS
3182: THEN

Line 4240: FROM po_requisition_lines_all

4236: -- Changed ELSIF to ELSE
4237: ELSE
4238: l_progress := '400';
4239: SELECT negotiated_by_preparer_flag into l_negotiated_by_preparer_flag
4240: FROM po_requisition_lines_all
4241: WHERE requisition_line_id=interface.requisition_line_id;
4242: END IF;
4243: ELSE
4244: l_progress := '410';

Line 4246: FROM po_requisition_lines_all

4242: END IF;
4243: ELSE
4244: l_progress := '410';
4245: SELECT negotiated_by_preparer_flag into l_negotiated_by_preparer_flag
4246: FROM po_requisition_lines_all
4247: WHERE requisition_line_id=interface.requisition_line_id;
4248: END IF;
4249: EXCEPTION
4250: WHEN others THEN

Line 5292: FROM po_requisition_lines_all --

5288: -- Copy of the requisition header attachements to the purchase
5289: -- order line.
5290: SELECT requisition_header_id
5291: INTO x_requisition_header_id
5292: FROM po_requisition_lines_all --
5293: WHERE requisition_line_id = interface.requisition_line_id;
5294:
5295: l_progress:='660';
5296:

Line 5367: FROM po_requisition_lines_all --

5363: -- Copy of the requisition header attachements to the purchase
5364: -- order line.
5365: SELECT requisition_header_id
5366: INTO x_requisition_header_id
5367: FROM po_requisition_lines_all --
5368: WHERE requisition_line_id = interface.requisition_line_id;
5369:
5370: l_progress:='690';
5371:

Line 5410: FROM po_requisition_lines_all --

5406: x_column1:='NEGREQ';
5407: l_progress:='710';
5408: SELECT requisition_header_id
5409: INTO x_requisition_header_id
5410: FROM po_requisition_lines_all --
5411: WHERE requisition_line_id =interface.requisition_line_id;
5412: else
5413: x_column1:='NEG';
5414: end if;

Line 5547: p_message => 'Create_line: Before update of po_requisition_lines');

5543:
5544: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
5545: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
5546: p_token => l_progress,
5547: p_message => 'Create_line: Before update of po_requisition_lines');
5548: END IF;
5549:
5550: IF (g_document_type = 'PO') THEN
5551: l_progress:='770';

Line 5552: UPDATE po_requisition_lines_all --

5548: END IF;
5549:
5550: IF (g_document_type = 'PO') THEN
5551: l_progress:='770';
5552: UPDATE po_requisition_lines_all --
5553: SET line_location_id = x_line_location_id,
5554: --
5555: reqs_in_pool_flag = NULL, --
5556: --

Line 5563: UPDATE po_requisition_lines_all --

5559: last_update_login = interface.last_update_login
5560: WHERE requisition_line_id = interface.requisition_line_id;
5561: ELSE
5562: l_progress := '780';
5563: UPDATE po_requisition_lines_all --
5564: SET on_rfq_flag = 'Y',
5565: last_update_date = interface.last_update_date,
5566: last_updated_by = interface.last_updated_by,
5567: last_update_login = interface.last_update_login

Line 5736: x_tax_status_indicator po_requisition_lines.tax_status_indicator%type;

5732: x_tax_user_override_flag VARCHAR2(1);
5733: --FRKHAN 1/12/99
5734: x_country_of_origin_code VARCHAR2(2);
5735: x_tax_status VARCHAR2(10);
5736: x_tax_status_indicator po_requisition_lines.tax_status_indicator%type;
5737: --FRKHAN 12/2/99 BUG 1084816
5738: l_encode VARCHAR2(2000);
5739: x_po_uom varchar2(25):=null;
5740: x_temp_uom varchar2(25):=null;

Line 6958: FROM po_requisition_lines_all --

6954: l_progress := '290';
6955: BEGIN
6956: SELECT requisition_header_id
6957: INTO x_p_req_header_id
6958: FROM po_requisition_lines_all --
6959: WHERE requisition_line_id = interface.requisition_line_id;
6960: EXCEPTION
6961: WHEN NO_DATA_FOUND THEN
6962: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 7076: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

7072: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
7073: x_conversion_rate number := 1;
7074:
7075: -- Bug 7661419, No conversion for same currency.
7076: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7077: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
7078: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7079: -- Bug 7661419 end
7080: --

Line 7077: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

7073: x_conversion_rate number := 1;
7074:
7075: -- Bug 7661419, No conversion for same currency.
7076: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7077: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
7078: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7079: -- Bug 7661419 end
7080: --
7081: --

Line 7078: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

7074:
7075: -- Bug 7661419, No conversion for same currency.
7076: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7077: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
7078: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7079: -- Bug 7661419 end
7080: --
7081: --
7082: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;

Line 7186: FROM po_requisition_lines_all pol --

7182: --Even sourcing need to execute this when backed by a req.
7183: Begin
7184: SELECT KANBAN_CARD_ID
7185: INTO x_kanban_card_id
7186: FROM po_requisition_lines_all pol --
7187: WHERE pol.REQUISITION_LINE_ID = interface.requisition_line_id;
7188: Exception
7189: WHEN NO_DATA_FOUND THEN
7190: /* Not all req has kanban id */

Line 7453: FROM po_requisition_lines_all PRL

7449: SELECT PRL.currency_code,
7450: Nvl(PRL.rate,1)
7451: INTO x_req_currency_code,
7452: x_req_rate
7453: FROM po_requisition_lines_all PRL
7454: WHERE PRL.requisition_line_id = INTERFACE.requisition_line_id;
7455:
7456: EXCEPTION
7457: WHEN OTHERS THEN

Line 8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

8546:
8547: -- Bug 3463242 START
8548: l_req_line_id PO_LINES_INTERFACE.requisition_line_id%TYPE;
8549: --
8550: l_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
8551: l_unit_price PO_LINES_INTERFACE.unit_price%TYPE;
8552: l_base_unit_price PO_LINES_INTERFACE.base_unit_price%TYPE;
8553: l_amount PO_LINES_INTERFACE.amount%TYPE;
8554: l_quantity_dummy PO_LINES_INTERFACE.quantity%TYPE;

Line 8617: PO_REQUISITION_LINES_ALL prl, --

8613: -- Bug 3463242 END
8614: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8615: PO_LINES_INTERFACE pli,
8616: PO_HEADERS_INTERFACE phi,
8617: PO_REQUISITION_LINES_ALL prl, --
8618: MTL_PARAMETERS mp,
8619: HR_ORGANIZATION_INFORMATION hoi,
8620: PO_LINE_TYPES_B plt -- Bug 3463242
8621: WHERE phi.interface_header_id = p_interface_header_id

Line 9065: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

9061: l_precision FND_CURRENCIES.precision%TYPE;
9062: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
9063: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
9064:
9065: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

Line 9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;

9063: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
9064:
9065: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
9071: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419

Line 9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;

9064:
9065: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
9071: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
9072:

Line 9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

9065: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
9071: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
9072:
9073: BEGIN

Line 9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;

9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
9071: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
9072:
9073: BEGIN
9074:

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

9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
9071: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE; -- Bug 7661419
9072:
9073: BEGIN
9074:
9075: l_progress:='000'; PO_DEBUG.debug_begin(l_log_head);

Line 9112: FROM po_requisition_lines_all PRL

9108: SELECT PRL.currency_code,
9109: Nvl(PRL.rate,1)
9110: INTO l_req_currency_code,
9111: l_req_rate
9112: FROM po_requisition_lines_all PRL
9113: WHERE PRL.requisition_line_id = p_requisition_line_id;
9114:
9115: IF ( l_req_currency_code = p_po_currency_code ) THEN
9116: x_quantity := round ( x_quantity/l_req_rate, nvl(l_ext_precision, 15) );

Line 9151: FROM po_requisition_lines_all PRL,

9147: , l_req_unit_price
9148: , l_req_currency_unit_price
9149: , l_req_amount
9150: , l_req_currency_amount
9151: FROM po_requisition_lines_all PRL,
9152: financials_system_params_all FSP,
9153: gl_sets_of_books GSB
9154: WHERE PRL.requisition_line_id = p_requisition_line_id
9155: AND nvl(PRL.org_id, -99) = nvl(FSP.org_id, -99)

Line 9859: po_requisition_lines_all prl, --

9855: prl.drop_ship_flag, --
9856: prl.vmi_flag -- VMI FPH
9857: FROM po_lines_interface pli,
9858: po_headers_interface phi,
9859: po_requisition_lines_all prl, --
9860: po_line_types plt,
9861: po_lines_all pol --
9862: WHERE pli.interface_line_id = pli2.interface_line_id
9863: AND pli.interface_header_id = phi.interface_header_id

Line 10063: po_requisition_lines_all prl, --

10059: --
10060: ,pol.supplier_part_auxid --13876074
10061: FROM po_lines_interface pli,
10062: po_headers_interface phi,
10063: po_requisition_lines_all prl, --
10064: po_line_types plt
10065: ,po_lines_all pol --13876074
10066: WHERE pli.interface_line_id = pli2.interface_line_id
10067: AND pli.interface_header_id = phi.interface_header_id

Line 10209: FROM po_requisition_lines_all prl, --

10205: decode(pli.consigned_flag,'Y',null,
10206: prd.oke_contract_line_id),
10207: decode(pli.consigned_flag,'Y',null,
10208: prd.oke_contract_deliverable_id)
10209: FROM po_requisition_lines_all prl, --
10210: po_req_distributions_all prd, --
10211: po_lines_interface pli,
10212: po_headers_interface phi
10213: WHERE prd.requisition_line_id = prl.requisition_line_id

Line 10512: x_note_to_receiver po_requisition_lines_all.note_to_receiver%type;

10508: x_transaction_reason_code varchar2(25);
10509: x_need_by_date date;
10510: --togeorge 09/27/2000
10511: --added note to receiver and oke variables.
10512: x_note_to_receiver po_requisition_lines_all.note_to_receiver%type;
10513: x_oke_contract_header_id number;
10514: x_oke_contract_version_id number;
10515: x_vendor_product_num varchar2(30); --Bug# 1763933
10516: x_deliver_to_location_id number;

Line 10710: FROM po_requisition_lines_all prl -- Bug 3903445

10706: SET pli.shipment_num = 1,
10707: pli.line_num =
10708: (
10709: SELECT prl.line_num
10710: FROM po_requisition_lines_all prl -- Bug 3903445
10711: WHERE prl.requisition_line_id = pli.requisition_line_id
10712: )
10713: WHERE pli.interface_header_id = x_interface_header_id
10714: AND pli.line_num is null

Line 10906: FROM po_requisition_lines_all prl

10902:
10903: UPDATE po_lines_interface pli
10904: SET pli.shipment_num =
10905: ( SELECT prl.line_num
10906: FROM po_requisition_lines_all prl
10907: WHERE prl.requisition_line_id = pli.requisition_line_id )
10908: WHERE pli.interface_header_id = x_interface_header_id
10909: AND pli.shipment_num IS NULL;
10910:

Line 11697: , po_requisition_lines_all prl

11693:
11694: SELECT min(pli.line_num)
11695: INTO x_po_line_num
11696: FROM po_lines_interface pli
11697: , po_requisition_lines_all prl
11698: , po_line_types_b PLT --
11699: WHERE pli.interface_header_id = x_interface_header_id
11700: AND pli.line_num is not null
11701: AND prl.requisition_line_id <> x_requisition_line_id

Line 12411: FROM po_requisition_lines_all

12407: -- Check whether the Req has been created from wip.
12408:
12409: SELECT 'Y'
12410: INTO l_flag
12411: FROM po_requisition_lines_all
12412: WHERE requisition_line_id = p_req_line_id
12413: AND wip_entity_id IS NOT NULL;
12414:
12415:

Line 12720: PO_REQUISITION_LINES_ALL PRL, --

12716:
12717: SELECT PLL.shipment_num
12718: INTO x_po_shipment_num
12719: FROM PO_LINE_LOCATIONS_ALL PLL, --
12720: PO_REQUISITION_LINES_ALL PRL, --
12721: PO_SYSTEM_PARAMETERS_ALL PSP --
12722: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
12723: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12724: AND rtrim(nvl(PLL.note_to_receiver,'99')) = rtrim(nvl(x_note_to_receiver,'99'))

Line 12791: PO_REQUISITION_LINES_ALL PRL, --

12787:
12788: SELECT PLL.shipment_num
12789: INTO x_po_shipment_num
12790: FROM PO_LINE_LOCATIONS_ALL PLL, --
12791: PO_REQUISITION_LINES_ALL PRL, --
12792: PO_SYSTEM_PARAMETERS_ALL PSP --
12793: WHERE PLL.PO_LINE_ID = x_po_line_id
12794: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
12795: --Bug4599140 (included the following OR condition so that the SQL works correctly

Line 12994: Also added po_requisition_lines to the join to get the destination_type_code

12990: Accrue on Recepit Flag when grouping the shipments. Modified this logic .
12991: This part of the code gets the current Accrue on Receipt flag which will
12992: be compared with the other records in the interface table to see if
12993: they can be grouped together .
12994: Also added po_requisition_lines to the join to get the destination_type_code
12995: also added the outer join on po_vendors
12996: */
12997: /* Bug # 2224446, Autocreate was not grouping Req. lines when two req.
12998: with the same line details was entered. This happened when they don't

Line 13023: po_requisition_lines_all prl, --

13019: 'SHOP FLOOR','Y')
13020: INTO x_receipt_required_flag
13021: FROM po_lines_interface pli,
13022: po_headers_interface phi,
13023: po_requisition_lines_all prl, --
13024: mtl_system_items msi,
13025: po_line_types plt,
13026: po_vendors pov,
13027: po_system_parameters_all psp, --

Line 13085: PO_REQUISITION_LINES_ALL PRL, --

13081: ,PLI.requisition_line_id
13082: INTO x_po_shipment_num
13083: ,x_req_line_to_check
13084: FROM PO_LINES_INTERFACE PLI,
13085: PO_REQUISITION_LINES_ALL PRL, --
13086: --bug 1942696 hr_location changes to reflect the new view
13087: MTL_SYSTEM_ITEMS MSI ,
13088: PO_LINE_TYPES PLT ,
13089: PO_SYSTEM_PARAMETERS_ALL PSP , --

Line 13207: PO_REQUISITION_LINES_ALL PRL, --

13203: */
13204: SELECT PLI.shipment_num
13205: INTO x_po_shipment_num
13206: FROM PO_LINES_INTERFACE PLI,
13207: PO_REQUISITION_LINES_ALL PRL, --
13208: MTL_SYSTEM_ITEMS MSI ,
13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --
13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

Line 13334: PO_REQUISITION_LINES_ALL PRL, --

13330: l_progress:='190';
13331: SELECT PLI.shipment_num
13332: INTO x_po_shipment_num
13333: FROM PO_LINES_INTERFACE PLI,
13334: PO_REQUISITION_LINES_ALL PRL, --
13335: --bug 1942696 hr_location changes to reflect the new view
13336: MTL_SYSTEM_ITEMS MSI ,
13337: PO_LINE_TYPES PLT ,
13338: PO_SYSTEM_PARAMETERS_ALL PSP , --

Line 13852: po_requisition_lines_all prl --

13848: x_allow_different_uoms IN VARCHAR2 -- Bug 2707576
13849: ) IS
13850: SELECT MIN(pol.line_num)
13851: FROM po_lines_all pol,
13852: po_requisition_lines_all prl --
13853: WHERE pol.po_header_id = p_po_header_id
13854: AND prl.requisition_line_id = p_requisition_line_id
13855: AND NVL(pol.cancel_flag,'N') = 'N'
13856: AND NVL(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 13966: po_requisition_lines_all prl --

13962: x_allow_different_uoms IN VARCHAR2 -- Bug 2707576
13963: ) IS
13964: SELECT MIN(pol.line_num)
13965: FROM po_lines_all pol,
13966: po_requisition_lines_all prl --
13967: WHERE pol.po_header_id = p_po_header_id
13968: AND prl.requisition_line_id = p_requisition_line_id
13969: AND NVL(pol.cancel_flag,'N') = 'N'
13970: AND NVL(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 14077: from po_requisition_lines_all --

14073: WHERE NVL(org_id, -99) = NVL(p_purchasing_ou_id, -99); --
14074:
14075: select item_id
14076: into x_item_id
14077: from po_requisition_lines_all --
14078: where requisition_line_id = x_requisition_line_id;
14079:
14080: if x_item_id is not null then
14081: SELECT msi.revision_qty_control_code

Line 14537: FROM po_lines_interface PLI, po_requisition_lines PRL

14533: END IF;
14534:
14535: SELECT count(*)
14536: INTO l_num_config_id_lines
14537: FROM po_lines_interface PLI, po_requisition_lines PRL
14538: WHERE PLI.interface_header_id = p_interface_header_id
14539: AND PLI.requisition_line_id = PRL.requisition_line_id -- JOIN
14540: AND PRL.supplier_ref_number IS NOT NULL;
14541:

Line 14930: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;

14926: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
14927: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14928: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14929:
14930: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14931: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14932: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
14933:
14934: l_tax_name AP_TAX_CODES.name%TYPE;

Line 14931: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;

14927: l_payitem_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
14928: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14929:
14930: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14931: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14932: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
14933:
14934: l_tax_name AP_TAX_CODES.name%TYPE;
14935: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;

Line 14932: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;

14928: l_payitem_price PO_LINE_LOCATIONS_ALL.price_override%TYPE;
14929:
14930: l_req_tax_code_id PO_REQUISITION_LINES_ALL.tax_code_id%TYPE;
14931: l_req_tax_user_override_flag PO_REQUISITION_LINES_ALL.tax_user_override_flag%TYPE;
14932: l_req_tax_status_indicator PO_REQUISITION_LINES_ALL.tax_status_indicator%TYPE;
14933:
14934: l_tax_name AP_TAX_CODES.name%TYPE;
14935: l_tax_code_id AP_TAX_CODES.tax_id%TYPE;
14936: l_tax_type AP_TAX_CODES.tax_type%TYPE;

Line 15262: FROM po_requisition_lines_all prl

15258: INTO l_req_tax_code_id
15259: , l_req_tax_user_override_flag
15260: , l_req_tax_status_indicator
15261: , g_line_requesting_ou_id
15262: FROM po_requisition_lines_all prl
15263: WHERE prl.requisition_line_id = interface.requisition_line_id;
15264:
15265: l_tax_code_id := l_req_tax_code_id;
15266:

Line 15906: , po_requisition_lines_all prl

15902: END)
15903: ,nvl2(g_calculate_tax_flag, 'CREATE', null) --
15904: FROM po_line_locations_all poll
15905: , po_req_distributions_all prd
15906: , po_requisition_lines_all prl
15907: WHERE poll.po_line_id = p_po_line_id
15908: AND prd.requisition_line_id = p_req_line_id
15909: AND prl.requisition_line_id = prd.requisition_line_id
15910: AND poll.payment_type <> 'ADVANCE';