APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 635: OE_ORDER_HEADERS_ALL oe

631: p_org_id number,p_order_type_id number,p_book_order_flag varchar2) IS
632: SELECT nvl(max(edt.order_header_id),-999)
633: FROM CS_ESTIMATE_DETAILS edt,
634: CS_TXN_BILLING_OETXN_ALL tb,
635: OE_ORDER_HEADERS_ALL oe
636: WHERE edt.incident_id = p_incident_id AND
637: edt.currency_code = p_currency_code AND
638: nvl(edt.invoice_to_org_id,-999) = nvl(p_invoice_to_org_id,-999) AND
639: nvl(edt.ship_to_org_id,-999) = nvl(p_ship_to_org_id,-999) AND

Line 663: FROM oe_order_headers_all

659:
660: -- Get the PO from Order_Header
661: Cursor Cust_Po(p_order_header_id number) is
662: SELECT nvl(cust_po_number,'-999')
663: FROM oe_order_headers_all
664: WHERE header_id = p_order_header_id;
665:
666: -- Get the Modifier_header_id
667: CURSOR Get_Modifier_Header(p_list_line_id number) is

Line 772: FROM oe_order_headers_all

768: l_ctrl_source VARCHAR2(30);
769: --
770: CURSOR get_order_status(p_order_header_id number) IS
771: SELECT booked_flag
772: FROM oe_order_headers_all
773: WHERE header_id = p_order_header_id;
774:
775:
776: CURSOR Get_party_number is