APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 472: OE_ORDER_LINES_ALL OL

468: SELECT
469: OL.UNIT_SELLING_PRICE
470: INTO SPRICE
471: FROM
472: OE_ORDER_LINES_ALL OL
473: WHERE OL.LINE_ID = CF_SELLING_PRICEFORMULA.SOURCE_LINE_ID;
474: END IF;
475: RETURN (SPRICE);
476: EXCEPTION

Line 573: OE_ORDER_LINES_ALL

569: SUM(NVL(ORDERED_QUANTITY
570: ,0))
571: INTO LINE_SET_ORD_QTY
572: FROM
573: OE_ORDER_LINES_ALL
574: WHERE LINE_SET_ID = SOURCE_LINE_SET_ID
575: GROUP BY
576: LINE_SET_ID;
577: EXCEPTION

Line 584: OE_ORDER_LINES_ALL

580: SUM(NVL(ORDERED_QUANTITY
581: ,0))
582: INTO LINE_SET_ORD_QTY
583: FROM
584: OE_ORDER_LINES_ALL
585: WHERE LINE_ID = SOURCE_LINE_SET_ID;
586: END;
587: END IF;
588: RETURN LINE_SET_ORD_QTY;

Line 606: OE_ORDER_LINES_ALL OL

602: SELECT
603: OL.PROMISE_DATE
604: INTO PDATE
605: FROM
606: OE_ORDER_LINES_ALL OL
607: WHERE OL.LINE_ID = SOURCE_LINE_ID;
608: END IF;
609: RETURN (PDATE);
610: EXCEPTION

Line 642: OE_ORDER_LINES_ALL LINES,

638: SELECT
639: count(distinct( LINES.ORDER_QUANTITY_UOM ))
640: INTO UOM_COUNT
641: FROM
642: OE_ORDER_LINES_ALL LINES,
643: OE_ORDER_HEADERS_ALL HEAD
644: WHERE LINES.HEADER_ID = HEAD.HEADER_ID
645: AND HEAD.ORDER_NUMBER = CF_DISTINCT_UOMFORMULA.ORDER_NUMBER;
646: IF UOM_COUNT > 1 THEN