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.2 2010/10/08 10:44:24 dashah ship $*/
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.2 2010/10/08 10:44:24 dashah ship $*/
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 565: po_requisition_lines rql,

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

Line 592: FROM po_requisition_lines rql,

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

Line 900: from po_requisition_lines

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

Line 907: from po_requisition_lines

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

Line 916: from po_requisition_lines

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