APPS.OKS_IBINT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 380: OE_ORDER_HEADERS_ALL OH,

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

Line 459: From OE_Order_Headers_ALL OH,

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

Line 707: -- Update Oe_Order_Headers_all

703: */
704:
705: -- Commented out for the fix of bug# 5088409 (JVARGHES)
706: --
707: -- Update Oe_Order_Headers_all
708: -- Set last_updated_by = last_updated_by
709: -- Where header_id = p_order_header_id;
710: --
711: -- Commented out for the fix of bug# 5088409 (JVARGHES)