APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on PO_RESCHEDULE_INTERFACE

Line 16: old_qty po_reschedule_interface.orig_quantity%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: );
20:

Line 17: old_need_by_date po_reschedule_interface.orig_need_by_date%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: );
20:
21:

Line 564: FROM po_reschedule_interface resc,

560: null,
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

Line 923: from po_reschedule_interface

919:
920: cursor interface(v_process_id in number) is
921: select distinct auction_header_id,
922: auction_display_number
923: from po_reschedule_interface
924: where auction_header_id is not null
925: and process_id = v_process_id;
926:
927: x_auction_num varchar2(60);