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:

Line 618: OE_ORDER_LINES_HISTORY

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