APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 601: OE_ORDER_HEADERS_ALL oe

597: p_org_id number,p_order_type_id number,p_book_order_flag varchar2) IS
598: SELECT nvl(max(edt.order_header_id),-999)
599: FROM CS_ESTIMATE_DETAILS edt,
600: CS_TXN_BILLING_OETXN_ALL tb,
601: OE_ORDER_HEADERS_ALL oe
602: WHERE edt.incident_id = p_incident_id AND
603: edt.currency_code = p_currency_code AND
604: nvl(edt.invoice_to_org_id,-999) = nvl(p_invoice_to_org_id,-999) AND
605: nvl(edt.ship_to_org_id,-999) = nvl(p_ship_to_org_id,-999) AND

Line 629: FROM oe_order_headers_all

625:
626: -- Get the PO from Order_Header
627: Cursor Cust_Po(p_order_header_id number) is
628: SELECT nvl(cust_po_number,'-999')
629: FROM oe_order_headers_all
630: WHERE header_id = p_order_header_id;
631:
632: -- Get the Modifier_header_id
633: CURSOR Get_Modifier_Header(p_list_line_id number) is

Line 738: FROM oe_order_headers_all

734: l_ctrl_source VARCHAR2(30);
735: --
736: CURSOR get_order_status(p_order_header_id number) IS
737: SELECT booked_flag
738: FROM oe_order_headers_all
739: WHERE header_id = p_order_header_id;
740:
741: --srini
742: CURSOR Get_party_number is