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_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_REQUISITION_HEADERS

Line 270: l_document_id po_requisition_headers.requisition_header_id%TYPE;

266: max_seqno number;
267: l_item_type wf_items.item_type%TYPE;
268: l_item_key wf_items.item_key%TYPE;
269:
270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;
273: l_document_type po_lookup_codes.displayed_field%TYPE;
274: l_document_number po_requisition_headers.segment1%TYPE;

Line 271: l_org_id po_requisition_headers.org_id%TYPE;

267: l_item_type wf_items.item_type%TYPE;
268: l_item_key wf_items.item_key%TYPE;
269:
270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;
273: l_document_type po_lookup_codes.displayed_field%TYPE;
274: l_document_number po_requisition_headers.segment1%TYPE;
275: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 274: l_document_number po_requisition_headers.segment1%TYPE;

270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;
273: l_document_type po_lookup_codes.displayed_field%TYPE;
274: l_document_number po_requisition_headers.segment1%TYPE;
275: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
276: l_change_request_group_id number;
277:
278: l_old_req_amount VARCHAR2(30);

Line 448: l_document_id po_requisition_headers.requisition_header_id%TYPE;

444: l_item_key wf_items.item_key%TYPE;
445:
446: l_change_request_group_id number;
447:
448: l_document_id po_requisition_headers.requisition_header_id%TYPE;
449: l_org_id po_requisition_headers.org_id%TYPE;
450: l_document_subtype po_lookup_codes.displayed_field%TYPE;
451: l_document_type po_lookup_codes.displayed_field%TYPE;
452: l_document_number po_requisition_headers.segment1%TYPE;

Line 449: l_org_id po_requisition_headers.org_id%TYPE;

445:
446: l_change_request_group_id number;
447:
448: l_document_id po_requisition_headers.requisition_header_id%TYPE;
449: l_org_id po_requisition_headers.org_id%TYPE;
450: l_document_subtype po_lookup_codes.displayed_field%TYPE;
451: l_document_type po_lookup_codes.displayed_field%TYPE;
452: l_document_number po_requisition_headers.segment1%TYPE;
453: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 452: l_document_number po_requisition_headers.segment1%TYPE;

448: l_document_id po_requisition_headers.requisition_header_id%TYPE;
449: l_org_id po_requisition_headers.org_id%TYPE;
450: l_document_subtype po_lookup_codes.displayed_field%TYPE;
451: l_document_type po_lookup_codes.displayed_field%TYPE;
452: l_document_number po_requisition_headers.segment1%TYPE;
453: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
454:
455: l_old_req_amount VARCHAR2(30);
456: l_old_tax_amount VARCHAR2(30);

Line 619: l_req_status po_requisition_headers.authorization_status%TYPE;

615: l_max_lines NUMBER := 0;
616:
617: l_document VARCHAR2(32000) := '';
618:
619: l_req_status po_requisition_headers.authorization_status%TYPE;
620:
621: l_req_line_msg VARCHAR2(2000) := '';
622:
623: l_currency_code fnd_currencies.currency_code%TYPE;

Line 1131: l_req_status po_requisition_headers.authorization_status%TYPE;

1127: l_max_lines NUMBER := 0;
1128:
1129: l_document VARCHAR2(32000) := '';
1130:
1131: l_req_status po_requisition_headers.authorization_status%TYPE;
1132:
1133: l_req_line_msg VARCHAR2(2000) := '';
1134:
1135: l_currency_code fnd_currencies.currency_code%TYPE;

Line 2215: PO_REQUISITION_HEADERS_ALL PRH, --

2211: begin
2212: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
2213: INTO l_so_number, l_status_code, l_line_id
2214: from PO_REQUISITION_LINES PRL,
2215: PO_REQUISITION_HEADERS_ALL PRH, --
2216: OE_ORDER_HEADERS_ALL OOH,
2217: OE_ORDER_LINES_ALL OOL,
2218: PO_SYSTEM_PARAMETERS PSP
2219: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID