DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 384: OE_ORDER_HEADERS_ALL OH,

380:
381: Select csi.last_oe_agreement_id Product_agreement_id
382: ,oh.transactional_curr_code Original_order_currency_code
383: From CSI_ITEM_INSTANCES Csi,
384: OE_ORDER_HEADERS_ALL OH,
385: OE_ORDER_LINES_ALL OL
386: Where csi.instance_id = p_id
387: And csi.last_oe_order_line_id = ol.line_id
388: And oh.header_id = ol.header_id;

Line 463: From OE_Order_Headers_ALL OH,

459: -- Cursor added to derive the sold to org id in order to get
460: -- the GCD rules for sold to customer
461: Cursor l_Ord_Hdr_csr(p_line_id NUMBER) Is
462: Select OH.SOLD_TO_ORG_ID
463: From OE_Order_Headers_ALL OH,
464: OE_ORDER_LINES_ALL OL
465: Where OH.Header_id = OL.Header_id
466: AND OL.line_id = p_line_id;
467:

Line 711: -- Update Oe_Order_Headers_all

707: */
708:
709: -- Commented out for the fix of bug# 5088409 (JVARGHES)
710: --
711: -- Update Oe_Order_Headers_all
712: -- Set last_updated_by = last_updated_by
713: -- Where header_id = p_order_header_id;
714: --
715: -- Commented out for the fix of bug# 5088409 (JVARGHES)