DBA Data[Home] [Help]

APPS.OKS_INTEGRATION_UTIL_PUB dependencies on OKX_ORDER_LINES_V

Line 65: *** from okx_order_lines_v

61:
62:
63: /**************************************************************************
64: *** procedure to populate the order details table with all the services
65: *** from okx_order_lines_v
66: ***************************************************************************/
67:
68: PROCEDURE Create_K_Order_Details
69: (

Line 83: From okx_order_lines_v ol

79: -- Cursor to select the service items from order lines
80:
81: Cursor Order_Dtl_cur Is
82: Select Id1, Id2, Service_End_Date
83: From okx_order_lines_v ol
84: Where ol.Header_id = P_header_id
85: And ol.Service_reference_Type_Code IN ('CUSTOMER_PRODUCT','ORDER');
86:
87: -- Cursor to check if all other orders has to be linked with