APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 450: OE_ORDER_LINES_ALL OL

446: SELECT
447: OL.UNIT_SELLING_PRICE
448: INTO SPRICE
449: FROM
450: OE_ORDER_LINES_ALL OL
451: WHERE OL.LINE_ID = CF_SELLING_PRICEFORMULA.SOURCE_LINE_ID;
452: END IF;
453: RETURN (SPRICE);
454: EXCEPTION

Line 551: OE_ORDER_LINES_ALL

547: SUM(NVL(ORDERED_QUANTITY
548: ,0))
549: INTO LINE_SET_ORD_QTY
550: FROM
551: OE_ORDER_LINES_ALL
552: WHERE LINE_SET_ID = SOURCE_LINE_SET_ID
553: GROUP BY
554: LINE_SET_ID;
555: EXCEPTION

Line 562: OE_ORDER_LINES_ALL

558: SUM(NVL(ORDERED_QUANTITY
559: ,0))
560: INTO LINE_SET_ORD_QTY
561: FROM
562: OE_ORDER_LINES_ALL
563: WHERE LINE_ID = SOURCE_LINE_SET_ID;
564: END;
565: END IF;
566: RETURN LINE_SET_ORD_QTY;

Line 584: OE_ORDER_LINES_ALL OL

580: SELECT
581: OL.PROMISE_DATE
582: INTO PDATE
583: FROM
584: OE_ORDER_LINES_ALL OL
585: WHERE OL.LINE_ID = SOURCE_LINE_ID;
586: END IF;
587: RETURN (PDATE);
588: EXCEPTION

Line 620: OE_ORDER_LINES_ALL LINES,

616: SELECT
617: count(distinct( LINES.ORDER_QUANTITY_UOM ))
618: INTO UOM_COUNT
619: FROM
620: OE_ORDER_LINES_ALL LINES,
621: OE_ORDER_HEADERS_ALL HEAD
622: WHERE LINES.HEADER_ID = HEAD.HEADER_ID
623: AND HEAD.ORDER_NUMBER = CF_DISTINCT_UOMFORMULA.ORDER_NUMBER;
624: IF UOM_COUNT > 1 THEN