DBA Data[Home] [Help]

APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 518: OE_ORDER_LINES_ALL

514: SELECT
515: CANCELLED_QUANTITY
516: INTO CAN_QTY_1
517: FROM
518: OE_ORDER_LINES_ALL
519: WHERE LINE_ID = LINEID;
520: RETURN (CAN_QTY_1);
521: ELSE
522: SELECT

Line 535: OE_ORDER_LINES_ALL

531: SELECT
532: ( CANCELLED_QUANTITY - CAN_QTY_MAX )
533: INTO CAN_QTY_FINAL1
534: FROM
535: OE_ORDER_LINES_ALL
536: WHERE LINE_ID = LINEID;
537: RETURN (CAN_QTY_FINAL1);
538: ELSE
539: SELECT

Line 581: OE_ORDER_LINES_ALL

577: CANCELLED_QUANTITY,
578: UNIT_SELLING_PRICE
579: INTO CAN_QTY_1,UNIT_SELLING_PRICE_VAR
580: FROM
581: OE_ORDER_LINES_ALL
582: WHERE LINE_ID = LINEID;
583: RETURN (CAN_QTY_1 * UNIT_SELLING_PRICE_VAR);
584: ELSE
585: SELECT

Line 599: OE_ORDER_LINES_ALL

595: ( CANCELLED_QUANTITY - CAN_QTY_MAX ),
596: UNIT_SELLING_PRICE
597: INTO CAN_QTY_FINAL1,UNIT_SELLING_PRICE_VAR
598: FROM
599: OE_ORDER_LINES_ALL
600: WHERE LINE_ID = LINEID;
601: RETURN (CAN_QTY_FINAL1 * UNIT_SELLING_PRICE_VAR);
602: ELSE
603: SELECT