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

Line 398: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

394: /* The req line has been deleted since it was queried up. */
395: x_result:=-1;
396: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
397: /*
398: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
399: WHERE prh.requisition_header_id = prl.requisition_header_id
400: AND prl.requisition_line_id = t_req_lines(i);
401:
402: fnd_message.set_token('REQ_NUM', x_req_num);

Line 415: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

411: if (SQLCODE=-54)
412: THEN
413: x_result:=-1;
414: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
415: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
416: WHERE prh.requisition_header_id = prl.requisition_header_id
417: AND prl.requisition_line_id = t_req_lines(i);
418:
419: fnd_message.set_token('REQ_NUM', x_req_num);

Line 437: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

433: then
434: /* The req line has been auto created already. */
435: x_result:=-1;
436: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
437: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
438: WHERE prh.requisition_header_id = prl.requisition_header_id
439: AND prl.requisition_line_id = t_req_lines(i);
440:
441: fnd_message.set_token('REQ_NUM', x_req_num);

Line 453: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

449: elsif (x_cancel_flag = 'Y') then
450: /* The req line has been cancelled. */
451: x_result:=-1;
452: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
453: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
454: WHERE prh.requisition_header_id = prl.requisition_header_id
455: AND prl.requisition_line_id = t_req_lines(i);
456:
457: fnd_message.set_token('REQ_NUM', x_req_num);

Line 469: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

465: elsif (x_closed_code = 'FINALLY CLOSED') then
466: /* The req line has been auto created already. */
467: x_result:=-1;
468: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
469: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
470: WHERE prh.requisition_header_id = prl.requisition_header_id
471: AND prl.requisition_line_id = t_req_lines(i);
472:
473: fnd_message.set_token('REQ_NUM', x_req_num);

Line 512: po_requisition_headers_all prh

508: prl.item_id,
509: prl.category_id,
510: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
511: FROM po_requisition_lines_all prl,
512: po_requisition_headers_all prh
513: WHERE prh.requisition_header_id = prl.requisition_header_id
514: AND prl.requisition_line_id = t_req_lines(i);
515:
516:

Line 615: from po_requisition_headers_all --

611: /* begin
612: x_progress := '006';
613: select segment1
614: into x_req_num
615: from po_requisition_headers_all --
616: where requisition_header_id=x_req_header_id;
617: exception
618: when others then
619: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);

Line 893: from po_requisition_headers_all prha

889: or source_type_code = 'INVENTORY'
890: or NVL(line_location_id, -999) <> -999
891: or exists
892: (select 'Req Header auth_status is not approved or contractor_status is pending'
893: from po_requisition_headers_all prha
894: where prha.requisition_header_id = prla.requisition_header_id
895: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
896: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
897: THEN null

Line 926: from po_requisition_headers_all prha

922: or source_type_code = 'INVENTORY'
923: or NVL(line_location_id, -999) <> -999
924: or exists
925: (select 'Req Header auth_status is not approved or contractor_status is pending'
926: from po_requisition_headers_all prha
927: where prha.requisition_header_id = prla.requisition_header_id
928: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
929: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
930: THEN null

Line 1092: from po_requisition_headers_all prha

1088: and source_type_code <> 'INVENTORY'
1089: and NVL(line_location_id, -999) = -999
1090: and not exists
1091: (select 'Req Header auth_status is not approved or contractor_status is pending'
1092: from po_requisition_headers_all prha
1093: where prha.requisition_header_id = prla.requisition_header_id
1094: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
1095: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING'));
1096: --

Line 1118: from po_requisition_headers_all prha

1114: and source_type_code <> 'INVENTORY'
1115: and NVL(line_location_id, -999) = -999
1116: and not exists
1117: (select 'Req Header auth_status is not approved or contractor_status is pending'
1118: from po_requisition_headers_all prha
1119: where prha.requisition_header_id = prla.requisition_header_id
1120: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
1121: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING'));
1122: --