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

Line 5: req_line_id po_requisition_lines.requisition_line_id%TYPE,

1: PACKAGE BODY po_negotiation_req_notif AS
2: /* $Header: POXNEG2B.pls 120.0 2005/06/02 00:27:09 appldev noship $*/
3:
4: TYPE line_record IS RECORD (
5: req_line_id po_requisition_lines.requisition_line_id%TYPE,
6: line_num po_requisition_lines.line_num%TYPE,
7: neg_line_num po_requisition_lines.auction_line_number%TYPE,
8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,

Line 6: line_num po_requisition_lines.line_num%TYPE,

2: /* $Header: POXNEG2B.pls 120.0 2005/06/02 00:27:09 appldev noship $*/
3:
4: TYPE line_record IS RECORD (
5: req_line_id po_requisition_lines.requisition_line_id%TYPE,
6: line_num po_requisition_lines.line_num%TYPE,
7: neg_line_num po_requisition_lines.auction_line_number%TYPE,
8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,

Line 7: neg_line_num po_requisition_lines.auction_line_number%TYPE,

3:
4: TYPE line_record IS RECORD (
5: req_line_id po_requisition_lines.requisition_line_id%TYPE,
6: line_num po_requisition_lines.line_num%TYPE,
7: neg_line_num po_requisition_lines.auction_line_number%TYPE,
8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,

Line 10: item_desc po_requisition_lines.item_description%TYPE,

6: line_num po_requisition_lines.line_num%TYPE,
7: neg_line_num po_requisition_lines.auction_line_number%TYPE,
8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
14: cancel_flag po_requisition_lines.cancel_flag%TYPE,

Line 11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,

7: neg_line_num po_requisition_lines.auction_line_number%TYPE,
8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
14: cancel_flag po_requisition_lines.cancel_flag%TYPE,
15: closed_code po_requisition_lines.closed_code%TYPE,

Line 12: quantity po_requisition_lines.quantity%TYPE,

8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
14: cancel_flag po_requisition_lines.cancel_flag%TYPE,
15: closed_code po_requisition_lines.closed_code%TYPE,
16: old_qty po_reschedule_interface.orig_quantity%TYPE,

Line 13: need_by_date po_requisition_lines.need_by_date%TYPE,

9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
14: cancel_flag po_requisition_lines.cancel_flag%TYPE,
15: closed_code po_requisition_lines.closed_code%TYPE,
16: old_qty po_reschedule_interface.orig_quantity%TYPE,
17: old_need_by_date po_reschedule_interface.orig_need_by_date%TYPE

Line 14: cancel_flag po_requisition_lines.cancel_flag%TYPE,

10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
14: cancel_flag po_requisition_lines.cancel_flag%TYPE,
15: closed_code po_requisition_lines.closed_code%TYPE,
16: old_qty po_reschedule_interface.orig_quantity%TYPE,
17: old_need_by_date po_reschedule_interface.orig_need_by_date%TYPE
18: ,auction_header_id po_requisition_lines.auction_header_id%TYPE --Bug 4107528

Line 15: closed_code po_requisition_lines.closed_code%TYPE,

11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
14: cancel_flag po_requisition_lines.cancel_flag%TYPE,
15: closed_code po_requisition_lines.closed_code%TYPE,
16: old_qty po_reschedule_interface.orig_quantity%TYPE,
17: old_need_by_date po_reschedule_interface.orig_need_by_date%TYPE
18: ,auction_header_id po_requisition_lines.auction_header_id%TYPE --Bug 4107528
19: );

Line 18: ,auction_header_id po_requisition_lines.auction_header_id%TYPE --Bug 4107528

14: cancel_flag po_requisition_lines.cancel_flag%TYPE,
15: closed_code po_requisition_lines.closed_code%TYPE,
16: old_qty po_reschedule_interface.orig_quantity%TYPE,
17: old_need_by_date po_reschedule_interface.orig_need_by_date%TYPE
18: ,auction_header_id po_requisition_lines.auction_header_id%TYPE --Bug 4107528
19: );
20:
21:
22: /*============================================================================

Line 293: FROM po_requisition_lines rql,

289: rql.closed_code,
290: null,
291: null
292: ,rql.auction_header_id --Bug 4107528
293: FROM po_requisition_lines rql,
294: po_requisition_headers_all rqh, --
295: mtl_system_items_kfv msi
296: WHERE rql.requisition_header_id = rqh.requisition_header_id
297: and rql.requisition_header_id = v_document_id

Line 322: FROM po_requisition_lines rql,

318: rql.closed_code,
319: null,
320: null
321: ,rql.auction_header_id --Bug 4107528
322: FROM po_requisition_lines rql,
323: po_requisition_headers_all rqh, --
324: mtl_system_items_kfv msi
325: WHERE rql.requisition_header_id = rqh.requisition_header_id
326: and rql.requisition_line_id = v_document_id

Line 564: po_requisition_lines rql,

560: resc.orig_quantity,
561: resc.orig_need_by_date
562: ,rql.auction_header_id --Bug 4107528
563: FROM po_reschedule_interface resc,
564: po_requisition_lines rql,
565: po_requisition_headers_all rqh, --
566: mtl_system_items_kfv msi
567: WHERE resc.auction_display_number = v_negotiation_num
568: and resc.process_id = v_process_id

Line 591: FROM po_requisition_lines rql,

587: null,
588: null,
589: null
590: ,rql.auction_header_id --Bug 4107528
591: FROM po_requisition_lines rql,
592: po_requisition_headers_all rqh, --
593: mtl_system_items_kfv msi
594: WHERE rql.requisition_header_id = rqh.requisition_header_id
595: and rql.requisition_header_id = v_document_id

Line 897: from po_requisition_lines

893:
894: cursor c1(x_doc_id in number) is
895: select auction_header_id,
896: auction_display_number
897: from po_requisition_lines
898: where requisition_line_id = x_doc_id
899: AND at_sourcing_flag = 'Y'; --
900:
901: cursor c2(x_doc_id in number) is

Line 904: from po_requisition_lines

900:
901: cursor c2(x_doc_id in number) is
902: select distinct auction_header_id ,
903: auction_display_number
904: from po_requisition_lines
905: where requisition_header_id = x_doc_id
906: AND at_sourcing_flag = 'Y' --
907: and (cancel_flag = 'Y' or closed_code = 'FINALLY CLOSED')
908: and (trunc(cancel_date) = trunc(sysdate) or trunc(closed_date) = trunc(sysdate));

Line 913: from po_requisition_lines

909:
910: cursor c3(x_doc_id in number) is
911: select distinct auction_header_id ,
912: auction_display_number
913: from po_requisition_lines
914: where requisition_header_id = x_doc_id
915: AND at_sourcing_flag = 'Y'; --
916:
917: cursor interface(v_process_id in number) is