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_RCO_VALIDATION_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 398: l_req_num po_requisition_headers_all.segment1%TYPE;

394: l_old_quantity NUMBER;
395: l_new_quantity NUMBER;
396: l_req_user_id NUMBER;
397: l_req_header_id NUMBER;
398: l_req_num po_requisition_headers_all.segment1%TYPE;
399: l_requester_id NUMBER;
400: l_matching_basis po_requisition_lines_all.matching_basis%TYPE;
401: l_old_amount NUMBER;
402: l_new_amount NUMBER;

Line 1574: FROM po_requisition_headers_all

1570: -- validate_change_request API set's org id context
1571: -- to the PO document's org, we need to set it back
1572: SELECT org_id
1573: INTO l_req_org_id
1574: FROM po_requisition_headers_all
1575: WHERE requisition_header_id = p_req_hdr_id;
1576:
1577: -- set org context back to req's org
1578: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --

Line 2139: l_req_num po_requisition_headers_all.segment1%TYPE;

2135: l_non_recoverable_tax NUMBER;
2136: l_po_request_level po_change_requests.request_level%TYPE;
2137: l_req_request_level po_change_requests.request_level%TYPE;
2138: l_req_header_id NUMBER;
2139: l_req_num po_requisition_headers_all.segment1%TYPE;
2140: l_req_line_number NUMBER;
2141: l_req_dist_number NUMBER;
2142: l_new_functional_price NUMBER;
2143: l_old_curr_unit_price NUMBER;

Line 2248: po_requisition_headers_all prha,

2244: po_lines_all pla,
2245: po_line_locations_all plla,
2246: po_req_distributions_all prda,
2247: po_requisition_lines_all prla,
2248: po_requisition_headers_all prha,
2249: po_distributions_all pda
2250: WHERE
2251: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2252: AND prda.requisition_line_id = prla.requisition_line_id

Line 2328: po_requisition_headers_all prha

2324: po_headers_all pha,
2325: po_lines_all pla,
2326: po_line_locations_all plla,
2327: po_requisition_lines_all prla,
2328: po_requisition_headers_all prha
2329: WHERE
2330: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id
2331: AND prla.line_location_id = plla.line_location_id
2332: AND plla.po_line_id = pla.po_line_id

Line 2420: po_requisition_headers_all prha

2416: po_line_locations_all plla,
2417: po_distributions_all pda,
2418: po_req_distributions_all prda,
2419: po_requisition_lines_all prla,
2420: po_requisition_headers_all prha
2421: WHERE
2422: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2423: AND prda.distribution_id = pda.req_distribution_id
2424: AND pda.line_location_id = plla.line_location_id

Line 2501: po_requisition_headers_all prha

2497: po_releases_all pra,
2498: po_lines_all pla,
2499: po_line_locations_all plla,
2500: po_requisition_lines_all prla,
2501: po_requisition_headers_all prha
2502: WHERE
2503: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id
2504: AND prla.line_location_id = plla.line_location_id
2505: AND plla.po_release_id = pra.po_release_id

Line 2802: po_requisition_headers_all prha

2798: l_transferred_to_oe_flag,
2799: l_cancelled
2800: FROM
2801: po_requisition_lines_all prla,
2802: po_requisition_headers_all prha
2803: WHERE
2804: prla.requisition_line_id = p_req_line_id AND
2805: prla.requisition_header_id = prha.requisition_header_id;
2806:

Line 2860: po_requisition_headers_all prha

2856: l_req_change_pending_flag,
2857: l_modified_by_agent
2858: FROM
2859: po_requisition_lines_all prla,
2860: po_requisition_headers_all prha
2861: WHERE
2862: prla.requisition_line_id = p_req_line_id AND
2863: prla.requisition_header_id = prha.requisition_header_id;
2864: END IF;

Line 3332: po_requisition_headers_all prha

3328: l_destination_type_code,
3329: l_transferred_to_oe_flag
3330: FROM
3331: po_requisition_lines_all prla,
3332: po_requisition_headers_all prha
3333: WHERE
3334: prla.requisition_line_id = p_req_line_id AND
3335: prla.requisition_header_id = prha.requisition_header_id;
3336:

Line 3929: l_req_num po_requisition_headers_all.segment1%TYPE;

3925: p_grp_id IN NUMBER)
3926: IS
3927: l_api_name VARCHAR2(50) := 'Save_ReqCancel';
3928: l_chn_req_id NUMBER;
3929: l_req_num po_requisition_headers_all.segment1%TYPE;
3930: l_req_line_num NUMBER;
3931: l_req_user_id NUMBER;
3932: l_line_loc_id NUMBER;
3933: l_po_header_id NUMBER;

Line 3981: po_requisition_headers_all prha,

3977: l_req_quantity,
3978: l_req_date,
3979: l_req_currency_price
3980: FROM
3981: po_requisition_headers_all prha,
3982: po_requisition_lines_all prla
3983: WHERE prla.requisition_line_id = p_cancel_table.req_line_id(i)
3984: AND prla.requisition_header_id = prha.requisition_header_id;
3985:

Line 4120: l_req_num po_requisition_headers_all.segment1%TYPE;

4116: --l_FC_Tbl po_fcin_type;
4117: l_req_dist_id NUMBER;
4118: l_req_line_id NUMBER;
4119: l_req_hdr_id NUMBER;
4120: l_req_num po_requisition_headers_all.segment1%TYPE;
4121: l_po_num po_headers_all.segment1%TYPE;
4122: l_header_id NUMBER;
4123: l_release_id NUMBER;
4124: l_line_id NUMBER;

Line 4231: po_requisition_headers_all prha

4227: FROM
4228: po_req_distributions_all prda,
4229: po_requisition_lines_all prla,
4230: po_change_requests pcr,
4231: po_requisition_headers_all prha
4232: WHERE
4233: prha.requisition_header_id = prla.requisition_header_id AND
4234: prla.requisition_line_id = prda.requisition_line_id AND
4235: pcr.document_line_id = prla.requisition_line_id AND

Line 5001: po_requisition_headers_all prh --

4997: INTO
4998: l_req_line_id,
4999: l_req_header_id
5000: FROM po_requisition_lines prl,
5001: po_requisition_headers_all prh --
5002: WHERE prl.requisition_line_id = p_req_line_id AND
5003: prh.requisition_header_id = prl.requisition_header_id AND
5004: (NOT EXISTS
5005: (SELECT 'so line is not cancelled'

Line 5008: po_requisition_headers_all PORH, --

5004: (NOT EXISTS
5005: (SELECT 'so line is not cancelled'
5006: FROM
5007: po_requisition_lines PORL,
5008: po_requisition_headers_all PORH, --
5009: po_system_parameters POSP
5010: WHERE
5011: PORL.requisition_line_id = p_req_line_id AND
5012: PORL.requisition_header_id = PORH.requisition_header_id AND

Line 5168: po_requisition_headers_all prh --

5164: INTO
5165: l_req_line_id,
5166: l_req_header_id
5167: FROM po_requisition_lines prl,
5168: po_requisition_headers_all prh --
5169: WHERE prl.requisition_line_id = p_req_line_id AND
5170: prh.requisition_header_id = prl.requisition_header_id ;
5171:
5172: l_progress := '002';

Line 5367: l_req_num po_requisition_headers_all.segment1%TYPE;

5363: p_grp_id IN NUMBER)
5364: IS
5365: l_api_name VARCHAR2(50) := 'Save_IReqCancel';
5366: l_chn_req_id NUMBER;
5367: l_req_num po_requisition_headers_all.segment1%TYPE;
5368: l_req_line_num NUMBER;
5369: l_req_user_id NUMBER;
5370: l_line_loc_id NUMBER;
5371: l_po_header_id NUMBER;

Line 5435: po_requisition_headers_all prha,

5431: l_req_price,
5432: l_req_quantity,
5433: l_req_date
5434: FROM
5435: po_requisition_headers_all prha,
5436: po_requisition_lines_all prla
5437: WHERE prla.requisition_line_id = p_cancel_table.req_line_id(i)
5438: AND prla.requisition_header_id = prha.requisition_header_id;
5439:

Line 5668: po_requisition_headers_all prha,

5664: l_old_amount,
5665: l_preparer_id
5666: FROM
5667: po_requisition_lines_all prla,
5668: po_requisition_headers_all prha,
5669: po_req_distributions_all prda
5670: WHERE
5671: prha.requisition_header_id = p_req_hdr_id
5672: AND prha.requisition_header_id = prla.requisition_header_id

Line 5963: FROM po_requisition_headers_all

5959: x_preparer_display_name varchar2(360);
5960: BEGIN
5961:
5962: SELECT preparer_id into l_preparer_id
5963: FROM po_requisition_headers_all
5964: WHERE requisition_header_id = p_req_hdr_id;
5965:
5966: WF_DIRECTORY.GetUserName( 'PER',
5967: l_preparer_id,

Line 6227: l_req_num po_requisition_headers_all.segment1%TYPE;

6223:
6224: l_req_dist_id NUMBER;
6225: l_req_line_id NUMBER;
6226: l_req_hdr_id NUMBER;
6227: l_req_num po_requisition_headers_all.segment1%TYPE;
6228: l_budget_account_id NUMBER;
6229: l_gl_date DATE;
6230: l_old_quantity NUMBER;
6231: l_old_tax NUMBER;

Line 6323: po_requisition_headers_all prha

6319: FROM
6320: po_req_distributions_all prda,
6321: po_requisition_lines_all prla,
6322: po_change_requests pcr,
6323: po_requisition_headers_all prha
6324: WHERE
6325: prha.requisition_header_id = prla.requisition_header_id AND
6326: prla.requisition_line_id = prda.requisition_line_id AND
6327: pcr.document_line_id = prla.requisition_line_id AND

Line 6810: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

6806:
6807: /*Procedure Call_Process_Order_for_IReq -- Specification definition
6808: ( P_API_Version IN NUMBER
6809: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
6810: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
6811: , P_Mode IN VARCHAR2
6812: , P_Cancel_ISO IN BOOLEAN DEFAULT FALSE
6813: , P_Cancel_ISO_lines IN BOOLEAN DEFAULT FALSE
6814: , P_New_Request_Date IN DATE DEFAULT NULL

Line 6838: ,po_requisition_headers_all poh --Bug 14280643

6834: FROM oe_order_lines_all oel
6835: ,oe_order_headers_all oeh
6836: ,wsh_delivery_details w
6837: ,po_requisition_lines_all pol
6838: ,po_requisition_headers_all poh --Bug 14280643
6839: WHERE
6840: oel.header_id = oeh.header_id
6841: AND oel.line_id = w.source_line_id
6842: AND w.source_code = 'OE'