eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_QUERY dependencies on SO_LINES

Line 42: FROM SO_LINES

38: NVL( CANCELLED_QUANTITY, 0 )) *
39: NVL(SELLING_PRICE, 0 ))
40: , 0)
41: INTO order_line_total
42: FROM SO_LINES
43: WHERE SHIPMENT_SCHEDULE_LINE_ID = ORDER_LINE_ID;
44: elsif ( ITEM_TYPE_CODE = 'MODEL' )
45: then
46: SELECT NVL(SUM((NVL( ORDERED_QUANTITY, 0 ) -

Line 51: FROM SO_LINES

47: NVL( CANCELLED_QUANTITY, 0 )) *
48: NVL(SELLING_PRICE, 0 ))
49: , 0)
50: INTO order_line_total
51: FROM SO_LINES
52: WHERE (ROWID = ORDER_ROWID
53: OR PARENT_LINE_ID = ORDER_LINE_ID
54: OR SERVICE_PARENT_LINE_ID = ORDER_LINE_ID );
55:

Line 72: FROM SO_LINES

68: NVL( CANCELLED_QUANTITY, 0 )) *
69: NVL(SELLING_PRICE, 0 ))
70: , 0)
71: INTO order_line_total
72: FROM SO_LINES
73: WHERE (ROWID = ORDER_ROWID
74: OR SERVICE_PARENT_LINE_ID = ORDER_LINE_ID );
75: else
76: order_line_total := ( nvl(ORDERED_QTY,0) - nvl(CANCELLED_QTY,0))

Line 118: FROM SO_LINES

114: NVL( CANCELLED_QUANTITY, 0 ) ) *
115: NVL( SELLING_PRICE, 0 )
116: , 0 ) ), 0 )
117: INTO Service_Total
118: FROM SO_LINES
119: WHERE (ROWID = P_ROWID
120: OR PARENT_LINE_ID = P_LINE_ID
121: OR SERVICE_PARENT_LINE_ID = P_LINE_ID );
122: else

Line 129: FROM SO_LINES

125: NVL( CANCELLED_QUANTITY, 0 ) ) *
126: NVL( SELLING_PRICE, 0 )
127: , 0 ) ), 0 )
128: INTO Service_Total
129: FROM SO_LINES
130: WHERE (ROWID = P_ROWID
131: OR SERVICE_PARENT_LINE_ID = P_LINE_ID );
132:
133: end if;

Line 271: FROM SO_LINES

267: ATO_Ind := 'N';
268: else
269: SELECT DECODE( COUNT(*), 0, 'N', 'Y' )
270: INTO ATO_Ind
271: FROM SO_LINES
272: WHERE PARENT_LINE_ID = P_Line_Id
273: AND SERVICE_PARENT_LINE_ID IS NULL
274: AND ATO_FLAG = 'Y'
275: AND ROWNUM = 1;

Line 302: FROM SO_LINES

298: ATO_Ind := 'N';
299: else
300: SELECT DECODE( COUNT(*), 0, 'N', 'Y' )
301: INTO ATO_Ind
302: FROM SO_LINES
303: WHERE PARENT_LINE_ID = P_Line_Id
304: AND SERVICE_PARENT_LINE_ID IS NULL
305: AND ATO_FLAG = 'Y'
306: AND ROWNUM = 1;

Line 428: from so_lines l,

424: Rel 11 - 896589. Replaced ltrim(... by p_component_code
425: */
426: select sum(nvl(det.quantity, 0))
427: into reserved_qty
428: from so_lines l,
429: so_line_details det
430: where
431: l.line_id = p_line_id
432: and det.line_id = l.line_id

Line 468: from so_lines l,

464: Rel 11 - 896589. Replaced ltrim(... by p_component_code
465: */
466: select sum(nvl(det.quantity, 0))
467: into released_qty
468: from so_lines l,
469: so_line_details det
470: where
471: l.line_id = p_line_id
472: and det.line_id = l.line_id

Line 520: SO_LINES SL,

516: 'SUPPLY RESERVED' ),
517: 'RESERVED' )
518: INTO schedule_status_code
519: FROM
520: SO_LINES SL,
521: SO_LINE_DETAILS SLD
522: WHERE
523: SL.line_id = P_Line_Id
524: and SLD.Line_id = SL.Line_Id

Line 621: FROM SO_LINES

617: SHIP_NUMBER := ORDER_LINE_NUMBER;
618: ELSE
619: SELECT LINE_NUMBER
620: INTO SHIP_NUMBER
621: FROM SO_LINES
622: WHERE LINE_ID = ORDER_PARENT_LINE_ID;
623: END IF;
624: END IF;
625:

Line 659: FROM SO_LINES

655: LINES_NUMBER := ORDER_LINE_NUMBER ;
656: ELSE
657: SELECT LINE_NUMBER
658: INTO LINES_NUMBER
659: FROM SO_LINES
660: WHERE LINE_ID = ORDER_PARENT_LINE_ID;
661: END IF;
662: ELSE
663: SELECT LINE_NUMBER

Line 665: FROM SO_LINES

661: END IF;
662: ELSE
663: SELECT LINE_NUMBER
664: INTO LINES_NUMBER
665: FROM SO_LINES
666: WHERE LINE_ID = ORDER_SHIP_SCHEDULE_LINE_ID;
667: END IF;
668:
669: RETURN( LINES_NUMBER);

Line 737: FROM so_lines l

733: CURSOR C_Ord_Total(X_Header_Id NUMBER) IS
734: SELECT NVL(SUM( (NVL( l.ordered_quantity, 0) -
735: NVL( l.cancelled_quantity, 0)) *
736: NVL( l.selling_price, 0)), 0) ORDER_TOTAL
737: FROM so_lines l
738: WHERE l.header_id = X_Header_Id
739: AND l.line_type_code IN ('REGULAR', 'DETAIL','RETURN');
740:
741: Ord_Total NUMBER;

Line 765: FROM SO_LINES

761: NVL( CANCELLED_QUANTITY, 0 )) *
762: NVL(SELLING_PRICE, 0 ))
763: , 0)
764: INTO line_total
765: FROM SO_LINES
766: WHERE SHIPMENT_SCHEDULE_LINE_ID = P_Line_Id;
767:
768: return(line_total);
769:

Line 792: FROM SO_LINES

788: SELECT NVL(SUM((NVL(ORDERED_QUANTITY, 0 ) -
789: NVL( CANCELLED_QUANTITY, 0 )) *
790: NVL(SELLING_PRICE, 0 )),0)
791: INTO L_Configuration_Total
792: FROM SO_LINES
793: WHERE (LINE_ID = Config_Parent_Line_Id
794: OR PARENT_LINE_ID = Config_Parent_Line_Id
795: OR SERVICE_PARENT_LINE_ID =
796: Config_Parent_Line_Id );

Line 874: l_cancel_qty so_lines.cancelled_quantity%TYPE;

870:
871: L_Qty_Ordered NUMBER;
872: l_qty_received number;
873: l_interface_id number;
874: l_cancel_qty so_lines.cancelled_quantity%TYPE;
875: l_link_to_line_id so_lines.link_to_line_id%TYPE;
876: l_item_type so_lines.item_type_code%TYPE;
877: l_ato_flag so_lines.ato_flag%TYPE;
878: l_included_item_count number;

Line 875: l_link_to_line_id so_lines.link_to_line_id%TYPE;

871: L_Qty_Ordered NUMBER;
872: l_qty_received number;
873: l_interface_id number;
874: l_cancel_qty so_lines.cancelled_quantity%TYPE;
875: l_link_to_line_id so_lines.link_to_line_id%TYPE;
876: l_item_type so_lines.item_type_code%TYPE;
877: l_ato_flag so_lines.ato_flag%TYPE;
878: l_included_item_count number;
879: L_S29 NUMBER;

Line 876: l_item_type so_lines.item_type_code%TYPE;

872: l_qty_received number;
873: l_interface_id number;
874: l_cancel_qty so_lines.cancelled_quantity%TYPE;
875: l_link_to_line_id so_lines.link_to_line_id%TYPE;
876: l_item_type so_lines.item_type_code%TYPE;
877: l_ato_flag so_lines.ato_flag%TYPE;
878: l_included_item_count number;
879: L_S29 NUMBER;
880: L_Shipped_Quantity NUMBER;

Line 877: l_ato_flag so_lines.ato_flag%TYPE;

873: l_interface_id number;
874: l_cancel_qty so_lines.cancelled_quantity%TYPE;
875: l_link_to_line_id so_lines.link_to_line_id%TYPE;
876: l_item_type so_lines.item_type_code%TYPE;
877: l_ato_flag so_lines.ato_flag%TYPE;
878: l_included_item_count number;
879: L_S29 NUMBER;
880: L_Shipped_Quantity NUMBER;
881:

Line 898: from so_lines

894: l_item_type,
895: L_Ato_Flag,
896: L_S29,
897: L_Shipped_quantity
898: from so_lines
899: where line_id = p_line_id;
900:
901:
902: IF (l_qty_ordered > l_cancel_qty) THEN

Line 909: so_lines lin

905: (lin.Ordered_Quantity - nvl(lin.cancelled_quantity,0)) /
906: mtlint.interfaced_quantity),0))
907: into l_qty_received
908: from so_rma_mtl_int_v mtlint,
909: so_lines lin
910: where mtlint.rma_line_id = p_line_id
911: and lin.line_id = p_line_id
912: group by lin.line_id,
913: lin.ordered_quantity,

Line 1007: l_cancel_qty so_lines.cancelled_quantity%TYPE;

1003:
1004: L_Qty_Ordered NUMBER;
1005: l_qty_received number;
1006: l_interface_id number;
1007: l_cancel_qty so_lines.cancelled_quantity%TYPE;
1008: l_link_to_line_id so_lines.link_to_line_id%TYPE;
1009: l_item_type so_lines.item_type_code%TYPE;
1010: l_ato_flag so_lines.ato_flag%TYPE;
1011: l_included_item_count number;

Line 1008: l_link_to_line_id so_lines.link_to_line_id%TYPE;

1004: L_Qty_Ordered NUMBER;
1005: l_qty_received number;
1006: l_interface_id number;
1007: l_cancel_qty so_lines.cancelled_quantity%TYPE;
1008: l_link_to_line_id so_lines.link_to_line_id%TYPE;
1009: l_item_type so_lines.item_type_code%TYPE;
1010: l_ato_flag so_lines.ato_flag%TYPE;
1011: l_included_item_count number;
1012: L_S29 NUMBER;

Line 1009: l_item_type so_lines.item_type_code%TYPE;

1005: l_qty_received number;
1006: l_interface_id number;
1007: l_cancel_qty so_lines.cancelled_quantity%TYPE;
1008: l_link_to_line_id so_lines.link_to_line_id%TYPE;
1009: l_item_type so_lines.item_type_code%TYPE;
1010: l_ato_flag so_lines.ato_flag%TYPE;
1011: l_included_item_count number;
1012: L_S29 NUMBER;
1013: L_Shipped_Quantity NUMBER;

Line 1010: l_ato_flag so_lines.ato_flag%TYPE;

1006: l_interface_id number;
1007: l_cancel_qty so_lines.cancelled_quantity%TYPE;
1008: l_link_to_line_id so_lines.link_to_line_id%TYPE;
1009: l_item_type so_lines.item_type_code%TYPE;
1010: l_ato_flag so_lines.ato_flag%TYPE;
1011: l_included_item_count number;
1012: L_S29 NUMBER;
1013: L_Shipped_Quantity NUMBER;
1014:

Line 1031: from so_lines

1027: l_item_type,
1028: L_Ato_Flag,
1029: L_S29,
1030: L_Shipped_quantity
1031: from so_lines
1032: where line_id = p_line_id;
1033:
1034:
1035: IF (l_qty_ordered > l_cancel_qty) THEN

Line 1042: so_lines lin

1038: (lin.Ordered_Quantity - nvl(lin.cancelled_quantity,0)) /
1039: mtlint.interfaced_quantity),0))
1040: into l_qty_received
1041: from so_rma_mtl_int_v mtlint,
1042: so_lines lin
1043: where mtlint.rma_line_id = p_line_id
1044: and lin.line_id = p_line_id
1045: group by lin.line_id,
1046: lin.ordered_quantity,

Line 1494: -- Input Argument: X_Line_Id is the line_id from the SO_LINES tables

1490: -- config item
1491: -- For Option Lines for ATO Models, it will return 0, as the options for ATO
1492: -- models never get backordered.
1493: --
1494: -- Input Argument: X_Line_Id is the line_id from the SO_LINES tables
1495: -- corresponding to the Order Line that you are interested in.
1496: --
1497: -- Return Value: Returns the total backordered amount for this order line,
1498: -- barring any included items.

Line 1835: FROM SO_LINES

1831: LINE_NUMBER
1832: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
1833: V_PARENT_LINE_ID,
1834: V_LINE_NUMBER
1835: FROM SO_LINES
1836: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
1837: END IF;
1838: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NULL) THEN
1839: IF (V_PARENT_LINE_ID IS NOT NULL) THEN

Line 1955: FROM SO_LINES

1951: LINE_NUMBER
1952: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
1953: V_PARENT_LINE_ID,
1954: V_LINE_NUMBER
1955: FROM SO_LINES
1956: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
1957: END IF;
1958: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NULL) THEN
1959: IF (V_PARENT_LINE_ID IS NULL) THEN

Line 1964: FROM SO_LINES

1960: BASE_LINE_NUMBER := V_LINE_NUMBER;
1961: ELSE
1962: SELECT LINE_NUMBER
1963: INTO BASE_LINE_NUMBER
1964: FROM SO_LINES
1965: WHERE LINE_ID = V_PARENT_LINE_ID;
1966: END IF;
1967: ELSE
1968: SELECT LINE_NUMBER

Line 1970: FROM SO_LINES

1966: END IF;
1967: ELSE
1968: SELECT LINE_NUMBER
1969: INTO BASE_LINE_NUMBER
1970: FROM SO_LINES
1971: WHERE LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID;
1972: END IF;
1973:
1974: RETURN(BASE_LINE_NUMBER);

Line 2007: FROM SO_LINES

2003: LINE_NUMBER
2004: INTO V_SHIPMENT_SCHEDULE_LINE_ID,
2005: V_PARENT_LINE_ID,
2006: V_LINE_NUMBER
2007: FROM SO_LINES
2008: WHERE LINE_ID = P_SERVICE_PARENT_LINE_ID;
2009: END IF;
2010: IF (V_SHIPMENT_SCHEDULE_LINE_ID IS NOT NULL) THEN
2011: IF (V_PARENT_LINE_ID IS NULL) THEN

Line 2016: FROM SO_LINES

2012: SCHEDULE_LINE_NUMBER := V_LINE_NUMBER;
2013: ELSE
2014: SELECT LINE_NUMBER
2015: INTO SCHEDULE_LINE_NUMBER
2016: FROM SO_LINES
2017: WHERE LINE_ID = V_PARENT_LINE_ID;
2018: END IF;
2019: END IF;
2020: