APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_LINE_STYLES_V

Line 5956: ,OKC_LINE_STYLES_V STL

5952: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5953: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5954: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5955: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5956: ,OKC_LINE_STYLES_V STL
5957: ,OKC_K_LINES_B LIN
5958: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5959: WHERE LIN.ID = Cx_Cle_Id --Commented by Jvorugan NVL(Cx_Cle_Id, LIN.ID)
5960: AND LIN.START_DATE IS NOT NULL

Line 5983: ,OKC_LINE_STYLES_V STL

5979: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5980: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5981: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5982: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5983: ,OKC_LINE_STYLES_V STL
5984: ,OKC_K_LINES_B LIN
5985: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5986: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5987: LIN.START_DATE IS NOT NULL

Line 6229: ,OKC_LINE_STYLES_V STL

6225: ,STL.NAME
6226: ,HDR.AUTHORING_ORG_ID ORG_ID
6227: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
6228: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6229: ,OKC_LINE_STYLES_V STL
6230: ,OKC_K_LINES_B LIN
6231: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
6232: WHERE LIN.ID = Cx_Cle_Id -- COmmented by Jvorugan for bug:4998337 NVL(Cx_Cle_Id, LIN.ID)
6233: AND LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)

Line 6249: ,OKC_LINE_STYLES_V STL

6245: ,STL.NAME
6246: ,HDR.AUTHORING_ORG_ID ORG_ID
6247: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
6248: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6249: ,OKC_LINE_STYLES_V STL
6250: ,OKC_K_LINES_B LIN
6251: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
6252: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
6253: LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)

Line 21323: FROM OKC_LINE_STYLES_V

21319: FUNCTION Get_Line_Styles(P_lse_id IN NUMBER) Return Varchar2 is
21320:
21321: CURSOR get_line_style (lse_id IN NUMBER) IS
21322: SELECT Id,NAME
21323: FROM OKC_LINE_STYLES_V
21324: WHERE ID = lse_id;
21325:
21326: L_Lse_Id NUMBER;
21327: L_style_name VARCHAR2(100);