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 563: FROM po_reschedule_interface resc,

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

Line 920: from po_reschedule_interface

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