DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_LINE_STYLES_V

Line 5568: ,OKC_LINE_STYLES_V STL

5564: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5565: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5566: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5567: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5568: ,OKC_LINE_STYLES_V STL
5569: ,OKC_K_LINES_B LIN
5570: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5571: WHERE LIN.ID = Cx_Cle_Id --Commented by Jvorugan NVL(Cx_Cle_Id, LIN.ID)
5572: AND LIN.START_DATE IS NOT NULL

Line 5595: ,OKC_LINE_STYLES_V STL

5591: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5592: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5593: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5594: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5595: ,OKC_LINE_STYLES_V STL
5596: ,OKC_K_LINES_B LIN
5597: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5598: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5599: LIN.START_DATE IS NOT NULL

Line 5841: ,OKC_LINE_STYLES_V STL

5837: ,STL.NAME
5838: ,HDR.AUTHORING_ORG_ID ORG_ID
5839: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
5840: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5841: ,OKC_LINE_STYLES_V STL
5842: ,OKC_K_LINES_B LIN
5843: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
5844: WHERE LIN.ID = Cx_Cle_Id -- COmmented by Jvorugan for bug:4998337 NVL(Cx_Cle_Id, LIN.ID)
5845: AND LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)

Line 5861: ,OKC_LINE_STYLES_V STL

5857: ,STL.NAME
5858: ,HDR.AUTHORING_ORG_ID ORG_ID
5859: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
5860: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5861: ,OKC_LINE_STYLES_V STL
5862: ,OKC_K_LINES_B LIN
5863: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
5864: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5865: LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)

Line 18971: FROM OKC_LINE_STYLES_V

18967: FUNCTION Get_Line_Styles(P_lse_id IN NUMBER) Return Varchar2 is
18968:
18969: CURSOR get_line_style (lse_id IN NUMBER) IS
18970: SELECT Id,NAME
18971: FROM OKC_LINE_STYLES_V
18972: WHERE ID = lse_id;
18973:
18974: L_Lse_Id NUMBER;
18975: L_style_name VARCHAR2(100);