DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OE_ORDER_LINES_ALL

Line 15632: OE_ORDER_LINES_ALL OEL

15628: CURSOR get_toplvl_uom(p_line_id IN NUMBER) IS
15629: SELECT OEL.PRICING_QUANTITY_UOM
15630: FROM OKC_K_LINES_B OKCLINE,
15631: OKC_K_REL_OBJS OKCREL,
15632: OE_ORDER_LINES_ALL OEL
15633: WHERE OKCLINE.LSE_ID IN (7,9,25)
15634: AND OKCLINE.id = p_line_id
15635: AND OKCLINE.ID = OKCREL.CLE_ID
15636: AND OEL.LINE_ID = OKCREL.OBJECT1_ID1;

Line 20184: OE_ORDER_LINES_ALL OEL

20180: CURSOR get_toplvl_uom(p_line_id IN NUMBER) IS
20181: SELECT OEL.PRICING_QUANTITY_UOM
20182: FROM OKC_K_LINES_B OKCLINE,
20183: OKC_K_REL_OBJS OKCREL,
20184: OE_ORDER_LINES_ALL OEL
20185: WHERE OKCLINE.LSE_ID IN (7,9,25)
20186: AND OKCLINE.id = p_line_id
20187: AND OKCLINE.ID = OKCREL.CLE_ID
20188: AND OEL.LINE_ID = OKCREL.OBJECT1_ID1;