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_REQ_LINES_SV dependencies on PO_REQUISITION_LINES

Line 20: FROM po_requisition_lines

16: PROCEDURE lock_row_for_buyer_update (x_rowid IN VARCHAR2)
17: IS
18: CURSOR C IS
19: SELECT *
20: FROM po_requisition_lines
21: WHERE rowid = x_rowid
22: FOR UPDATE of requisition_line_id NOWAIT;
23: Recinfo C%ROWTYPE;
24:

Line 68: FROM po_requisition_lines

64: x_progress := '010';
65:
66: SELECT rowid
67: INTO x_rowid
68: FROM po_requisition_lines
69: WHERE requisition_line_id = x_line_id;
70:
71: -- dbms_output.put_line('After selecting rowid');
72:

Line 93: po_requisition_lines_pkg1.delete_row(x_rowid, x_transferred_to_oe_flag);

89: */
90:
91: x_progress := '030';
92:
93: po_requisition_lines_pkg1.delete_row(x_rowid, x_transferred_to_oe_flag);
94:
95: -- dbms_output.put_line('After call to delete line');
96:
97: EXCEPTION

Line 170: FROM PO_REQUISITION_LINES PORL,

166:
167: X_progress := '010';
168: SELECT COUNT(1)
169: INTO X_row_exists
170: FROM PO_REQUISITION_LINES PORL,
171: PO_LINE_LOCATIONS POLL
172: WHERE PORL.requisition_header_id = X_req_header_id
173: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
174: AND PORL.line_location_id = POLL.line_location_id

Line 217: From po_requisition_lines

213: p_req_line_id NUMBER;
214:
215: Cursor get_req_lines_cur is
216: Select requisition_line_id
217: From po_requisition_lines
218: Where requisition_line_id = nvl(X_req_line_id, requisition_line_id)
219: And requisition_header_id = X_req_header_id
220: And source_type_code = 'INVENTORY';
221:

Line 242: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,

238: --Toju George 08/31/2000
239: --Modified the call to procedure to replace req_num and line_num with ids.
240: /* SELECT COUNT(1)
241: INTO X_row_exists
242: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
243: PO_SYSTEM_PARAMETERS POSP
244: WHERE PORH.requisition_header_id = X_req_header_id
245: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
246: AND PORH.requisition_header_id = PORL.requisition_header_id

Line 254: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,

250: PORL.line_num ) > 0 ;
251: */
252: SELECT COUNT(1)
253: INTO X_row_exists
254: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
255: PO_SYSTEM_PARAMETERS POSP
256: WHERE PORH.requisition_header_id = X_req_header_id
257: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
258: AND PORH.requisition_header_id = PORL.requisition_header_id

Line 326: to compare with quantity_deliverd in po_requisition_lines.

322: ** 1. all document lines - if header_id is passed or,
323: ** 2. one document line - if both header_id and line_id are passed.
324: */
325: /* Bug# 5414478, We were using RCV_SHIPMENT_LINES quantity_received
326: to compare with quantity_deliverd in po_requisition_lines.
327: But in certain cases the Req. line and rcv_shipment_line are
328: in different UOM and were not doing the quantity conversion while
329: comparing quantity. Since we store the quantity_received in
330: po_requisition_lines and it is in the same UOM as quantity_received

Line 330: po_requisition_lines and it is in the same UOM as quantity_received

326: to compare with quantity_deliverd in po_requisition_lines.
327: But in certain cases the Req. line and rcv_shipment_line are
328: in different UOM and were not doing the quantity conversion while
329: comparing quantity. Since we store the quantity_received in
330: po_requisition_lines and it is in the same UOM as quantity_received
331: we are going on quantity_received of po_requisition_lines
332: to do the comparision. */
333: X_progress := '010';
334: SELECT COUNT(1)

Line 331: we are going on quantity_received of po_requisition_lines

327: But in certain cases the Req. line and rcv_shipment_line are
328: in different UOM and were not doing the quantity conversion while
329: comparing quantity. Since we store the quantity_received in
330: po_requisition_lines and it is in the same UOM as quantity_received
331: we are going on quantity_received of po_requisition_lines
332: to do the comparision. */
333: X_progress := '010';
334: SELECT COUNT(1)
335: INTO X_row_exists

Line 336: FROM PO_REQUISITION_LINES PORL

332: to do the comparision. */
333: X_progress := '010';
334: SELECT COUNT(1)
335: INTO X_row_exists
336: FROM PO_REQUISITION_LINES PORL
337: WHERE PORL.requisition_header_id = X_req_header_id
338: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
339: AND PORL.source_type_code = 'INVENTORY'
340: AND nvl(PORL.cancel_flag, 'N') = 'N'

Line 384: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;

380: X_req_control_error_rc IN OUT NOCOPY VARCHAR2,
381: X_oe_installed_flag IN VARCHAR2) IS
382:
383: X_progress VARCHAR2(3) := NULL;
384: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
385: X_order_source_id po_system_parameters.order_source_id%TYPE;
386:
387: BEGIN
388:

Line 431: UPDATE PO_REQUISITION_LINES

427: ** 1. all document lines - if header_id is passed or,
428: ** 2. one document line - if both header_id and line_id are passed.
429: */
430: X_progress := '010';
431: UPDATE PO_REQUISITION_LINES
432: SET cancel_flag = 'I',
433: quantity_cancelled = NVL(X_quantity_cancelled, quantity_cancelled),
434: reqs_in_pool_flag = NULL, --
435: last_update_login = fnd_global.login_id,

Line 479: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;

475: X_oe_installed_flag IN VARCHAR2,
476: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
477:
478: X_progress VARCHAR2(3) := NULL;
479: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;

Line 480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;

476: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
477:
478: X_progress VARCHAR2(3) := NULL;
479: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;

Line 481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;

477:
478: X_progress VARCHAR2(3) := NULL;
479: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;

Line 482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;

478: X_progress VARCHAR2(3) := NULL;
479: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
486: X_terminal_performed NUMBER(1) := 0; --

Line 483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;

479: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
486: X_terminal_performed NUMBER(1) := 0; --
487: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;

Line 484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;

480: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
486: X_terminal_performed NUMBER(1) := 0; --
487: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
488:

Line 485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;

481: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
482: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
486: X_terminal_performed NUMBER(1) := 0; --
487: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
488:
489: BEGIN

Line 561: UPDATE PO_REQUISITION_LINES

557: quantity_cancelled = nvl(X_quantity_cancelled, quantity_cancelled) to
558: quantity_cancelled = nvl(X_quantity_cancelled, decode(X_cancel_flag,'Y',quantity,quantity_cancelled))
559: */
560:
561: UPDATE PO_REQUISITION_LINES
562: SET cancel_flag = nvl(X_cancel_flag, cancel_flag),
563: cancel_date = nvl(X_cancel_date, cancel_date),
564: cancel_reason = nvl(X_cancel_reason, cancel_reason),
565: closed_code = nvl(X_closed_code, closed_code),

Line 589: FROM po_requisition_lines PORL

585: UPDATE PO_REQ_DISTRIBUTIONS
586: SET req_line_quantity = 0
587: WHERE requisition_line_id IN
588: (SELECT requisition_line_id
589: FROM po_requisition_lines PORL
590: WHERE PORL.requisition_header_id = X_req_header_id
591: AND nvl(PORL.cancel_flag,'N') = 'Y'
592: AND PORL.source_type_code = 'VENDOR'
593: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id));

Line 650: FROM po_line_locations s, po_requisition_lines rl

646: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
647: rl.requisition_header_id, rl.requisition_line_id
648: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
649: L_req_header_id, l_req_line_id
650: FROM po_line_locations s, po_requisition_lines rl
651: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
652: AND s.po_header_id = X_entity_id;
653: --
654:

Line 655: UPDATE po_requisition_lines_all -- Bug 3592153

651: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
652: AND s.po_header_id = X_entity_id;
653: --
654:
655: UPDATE po_requisition_lines_all -- Bug 3592153
656: SET line_location_id = NULL,
657: reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
658: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
659: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 676: FROM po_line_locations s, po_requisition_lines rl

672: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
673: rl.requisition_header_id, rl.requisition_line_id
674: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
675: L_req_header_id, l_req_line_id
676: FROM po_line_locations s, po_requisition_lines rl
677: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
678: AND s.po_release_id = X_entity_id;
679: --
680:

Line 681: UPDATE po_requisition_lines_all -- Bug 3592153

677: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
678: AND s.po_release_id = X_entity_id;
679: --
680:
681: UPDATE po_requisition_lines_all -- Bug 3592153
682: SET line_location_id = NULL,
683: reqs_in_pool_flag = 'Y', -- Bug 2781027
684: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
685: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 701: FROM po_line_locations s, po_requisition_lines rl

697: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
698: rl.requisition_header_id, rl.requisition_line_id
699: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
700: L_req_header_id, l_req_line_id
701: FROM po_line_locations s, po_requisition_lines rl
702: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
703: AND s.po_line_id = X_entity_id;
704: --
705:

Line 706: UPDATE po_requisition_lines_all -- Bug 3592153

702: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
703: AND s.po_line_id = X_entity_id;
704: --
705:
706: UPDATE po_requisition_lines_all -- Bug 3592153
707: SET line_location_id = NULL,
708: reqs_in_pool_flag = 'Y', -- Bug 2781027
709: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
710: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 726: FROM po_line_locations s, po_requisition_lines rl

722: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id,
723: rl.requisition_header_id, rl.requisition_line_id
724: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id,
725: L_req_header_id, l_req_line_id
726: FROM po_line_locations s, po_requisition_lines rl
727: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
728: AND s.line_location_id = X_entity_id;
729: --
730:

Line 731: UPDATE po_requisition_lines_all -- Bug 3592153

727: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
728: AND s.line_location_id = X_entity_id;
729: --
730:
731: UPDATE po_requisition_lines_all -- Bug 3592153
732: SET line_location_id = NULL,
733: reqs_in_pool_flag = 'Y', -- Bug 2781027
734: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
735: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 1017: FROM po_requisition_lines prl

1013: x_progress := '010';
1014:
1015: SELECT count(*)
1016: INTO x_inv_count
1017: FROM po_requisition_lines prl
1018: WHERE prl.requisition_header_id = x_req_hdr_id
1019: AND prl.source_type_code = 'INVENTORY';
1020:
1021: -- dbms_output.put_line ('x_inv_count: ' ||to_char(x_inv_count));

Line 1115: UPDATE po_requisition_lines_all prl

1111: -- be placed on a purchasing document; those that fail all
1112: -- the above criteria can.
1113: --
1114: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL
1115: UPDATE po_requisition_lines_all prl
1116: SET prl.reqs_in_pool_flag =
1117: CASE
1118: WHEN NVL(prl.cancel_flag,'N') = 'Y'
1119: OR NVL(prl.closed_code,'OPEN') = 'FINALLY CLOSED'

Line 1143: FROM PO_REQUISITION_LINES_ALL SUB

1139: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1140: WHERE
1141: PRL.Requisition_Line_ID in (
1142: SELECT SUB.Requisition_Line_ID
1143: FROM PO_REQUISITION_LINES_ALL SUB
1144: WHERE SUB.Requisition_Header_Id = x_req_header_id
1145: AND x_req_line_id IS NULL
1146: UNION ALL
1147: SELECT SUB2.Requisition_Line_ID

Line 1148: FROM PO_REQUISITION_LINES_ALL SUB2

1144: WHERE SUB.Requisition_Header_Id = x_req_header_id
1145: AND x_req_line_id IS NULL
1146: UNION ALL
1147: SELECT SUB2.Requisition_Line_ID
1148: FROM PO_REQUISITION_LINES_ALL SUB2
1149: WHERE SUB2.Requisition_Line_Id = x_req_line_id
1150: );
1151:
1152: ELSE