DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OE_ORDER_LINES_ALL

Line 15586: OE_ORDER_LINES_ALL OEL

15582: CURSOR get_toplvl_uom(p_line_id IN NUMBER) IS
15583: SELECT OEL.PRICING_QUANTITY_UOM
15584: FROM OKC_K_LINES_B OKCLINE,
15585: OKC_K_REL_OBJS OKCREL,
15586: OE_ORDER_LINES_ALL OEL
15587: WHERE OKCLINE.LSE_ID IN (7,9,25)
15588: AND OKCLINE.id = p_line_id
15589: AND OKCLINE.ID = OKCREL.CLE_ID
15590: AND OEL.LINE_ID = OKCREL.OBJECT1_ID1;

Line 20037: OE_ORDER_LINES_ALL OEL

20033: CURSOR get_toplvl_uom(p_line_id IN NUMBER) IS
20034: SELECT OEL.PRICING_QUANTITY_UOM
20035: FROM OKC_K_LINES_B OKCLINE,
20036: OKC_K_REL_OBJS OKCREL,
20037: OE_ORDER_LINES_ALL OEL
20038: WHERE OKCLINE.LSE_ID IN (7,9,25)
20039: AND OKCLINE.id = p_line_id
20040: AND OKCLINE.ID = OKCREL.CLE_ID
20041: AND OEL.LINE_ID = OKCREL.OBJECT1_ID1;