APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on OE_ORDER_LINES_HISTORY

Line 510: OE_ORDER_LINES_HISTORY

506: SELECT
507: COUNT(1)
508: INTO HIST_LINES
509: FROM
510: OE_ORDER_LINES_HISTORY
511: WHERE LINE_ID = LINEID
512: AND HIST_TYPE_CODE = 'CANCELLATION';
513: IF HIST_LINES = 1 THEN
514: SELECT

Line 527: OE_ORDER_LINES_HISTORY

523: MAX(ORDERED_QUANTITY),
524: MAX(CANCELLED_QUANTITY)
525: INTO ORD_QTY_MAX,CAN_QTY_MAX
526: FROM
527: OE_ORDER_LINES_HISTORY
528: WHERE LINE_ID = LINEID
529: AND HIST_TYPE_CODE = 'CANCELLATION';
530: IF CANCELLED_QTY = CAN_QTY_MAX THEN
531: SELECT

Line 543: OE_ORDER_LINES_HISTORY

539: SELECT
540: MIN(CANCELLED_QUANTITY)
541: INTO CAN_QTY_FINAL2
542: FROM
543: OE_ORDER_LINES_HISTORY
544: WHERE LINE_ID = LINEID
545: AND CANCELLED_QUANTITY > CANCELLED_QTY
546: AND HIST_TYPE_CODE = 'CANCELLATION';
547: RETURN (CAN_QTY_FINAL2 - CANCELLED_QTY);

Line 572: OE_ORDER_LINES_HISTORY

568: SELECT
569: COUNT(1)
570: INTO HIST_LINES
571: FROM
572: OE_ORDER_LINES_HISTORY
573: WHERE LINE_ID = LINEID
574: AND HIST_TYPE_CODE = 'CANCELLATION';
575: IF HIST_LINES = 1 THEN
576: SELECT

Line 590: OE_ORDER_LINES_HISTORY

586: MAX(ORDERED_QUANTITY),
587: MAX(CANCELLED_QUANTITY)
588: INTO ORD_QTY_MAX,CAN_QTY_MAX
589: FROM
590: OE_ORDER_LINES_HISTORY
591: WHERE LINE_ID = LINEID
592: AND HIST_TYPE_CODE = 'CANCELLATION';
593: IF CANCELLED_QTY = CAN_QTY_MAX THEN
594: SELECT

Line 607: OE_ORDER_LINES_HISTORY

603: SELECT
604: MIN(CANCELLED_QUANTITY)
605: INTO CAN_QTY_FINAL2
606: FROM
607: OE_ORDER_LINES_HISTORY
608: WHERE LINE_ID = LINEID
609: AND CANCELLED_QUANTITY > CANCELLED_QTY
610: AND HIST_TYPE_CODE = 'CANCELLATION';
611: SELECT

Line 616: OE_ORDER_LINES_HISTORY

612: DISTINCT
613: UNIT_SELLING_PRICE
614: INTO UNIT_SELLING_PRICE_VAR
615: FROM
616: OE_ORDER_LINES_HISTORY
617: WHERE LINE_ID = LINEID
618: AND CANCELLED_QUANTITY = CAN_QTY_FINAL2
619: AND HIST_TYPE_CODE = 'CANCELLATION';
620: RETURN ((CAN_QTY_FINAL2 - CANCELLED_QTY) * UNIT_SELLING_PRICE_VAR);