APPS.OE_QUERY dependencies on SO_LINE_DETAILS

Line 199: FROM SO_LINE_DETAILS SLD

195: 'DEMANDED' ),
196: 'SUPPLY RESERVED' ),
197: 'RESERVED' )
198: INTO schedule_status_code
199: FROM SO_LINE_DETAILS SLD
200: WHERE SLD.LINE_ID = ORDER_LINE_ID;
201:
202: if ( schedule_status_code is not null )
203: then

Line 244: FROM SO_LINE_DETAILS SLD

240: 'DEMANDED' ),
241: 'SUPPLY RESERVED' ),
242: 'RESERVED' )
243: INTO schedule_status_code
244: FROM SO_LINE_DETAILS SLD
245: WHERE SLD.LINE_ID = ORDER_LINE_ID;
246:
247: return( SCHEDULE_STATUS_CODE );
248:

Line 320: -- from So_Line_DETAILS table to get released quantity for a line.

316:
317:
318:
319: ------------------------------------------------------------------------
320: -- from So_Line_DETAILS table to get released quantity for a line.
321: ------------------------------------------------------------------------
322: FUNCTION Released_Quantity(P_Line_Id IN NUMBER) RETURN NUMBER IS
323: Config_Item_Flag VARCHAR2(1) := NULL;
324: rel_qty NUMBER := 0;

Line 328: FROM so_line_details

324: rel_qty NUMBER := 0;
325: total_rel_qty NUMBER := 0;
326: CURSOR C_Get_Released_Quantity (X_Line_Id IN NUMBER) IS
327: SELECT sum(nvl(quantity, 0)), configuration_item_flag
328: FROM so_line_details
329: WHERE line_id = X_Line_Id
330: AND nvl(included_item_flag, 'N') = 'N'
331: AND nvl(released_flag, 'Y') = 'Y'
332: GROUP BY configuration_item_flag;

Line 383: -- from So_Line_DETAILS table to get all reserved details quantity

379:
380:
381:
382: ------------------------------------------------------------------------
383: -- from So_Line_DETAILS table to get all reserved details quantity
384: ------------------------------------------------------------------------
385: function RESERVED_QUANTITY(
386: ORDER_LINE_ID IN NUMBER DEFAULT NULL
387: )

Line 397: from SO_LINE_DETAILS

393: select sum( decode( SCHEDULE_STATUS_CODE,
394: 'RESERVED', QUANTITY,
395: 0))
396: into RESERVED_QTY
397: from SO_LINE_DETAILS
398: where line_id = ORDER_LINE_ID
399: and NVL(INCLUDED_ITEM_FLAG, 'N')='N';
400:
401: return( RESERVED_QTY);

Line 411: -- from So_Line_DETAILS table to get all reserved details quantity

407: END ;
408:
409:
410: ------------------------------------------------------------------------
411: -- from So_Line_DETAILS table to get all reserved details quantity
412: -- for the included item.
413: ------------------------------------------------------------------------
414: function II_RESERVED_QUANTITY(
415: P_LINE_ID IN NUMBER,

Line 429: so_line_details det

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
433: and det.included_item_flag = 'Y'

Line 450: -- from So_Line_DETAILS table to get all reserved details quantity

446:
447:
448:
449: ------------------------------------------------------------------------
450: -- from So_Line_DETAILS table to get all reserved details quantity
451: -- for the included item.
452: ------------------------------------------------------------------------
453:
454: function II_RELEASED_QUANTITY(

Line 469: so_line_details det

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
473: and det.released_flag = 'Y'

Line 521: SO_LINE_DETAILS SLD

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
525: and SLD.Included_Item_Flag = 'Y'

Line 556: from so_line_details

552: BEGIN
553:
554: select 'Y'
555: into Supply_Reserved_Details
556: from so_line_details
557: where
558: line_id = P_Line_Id
559: and schedule_status_code = 'SUPPLY RESERVED'
560: and rownum = 1;

Line 930: FROM so_line_details

926: (l_item_type = 'KIT'))) THEN
927:
928: SELECT count (line_detail_id)
929: INTO l_included_item_count
930: FROM so_line_details
931: WHERE line_id = l_link_to_line_id
932: AND included_item_flag = 'Y';
933:
934: /* Components are frozen so ratios exist */

Line 1063: FROM so_line_details

1059: (l_item_type = 'KIT'))) THEN
1060:
1061: SELECT count (line_detail_id)
1062: INTO l_included_item_count
1063: FROM so_line_details
1064: WHERE line_id = l_link_to_line_id
1065: AND included_item_flag = 'Y';
1066:
1067: /* Components are frozen so ratios exist */

Line 1409: FROM so_line_details

1405: SELECT 'Y'
1406: INTO l_flag
1407: FROM sys.dual
1408: WHERE EXISTS (SELECT 1
1409: FROM so_line_details
1410: WHERE line_id = X_line_id
1411: AND configuration_item_flag = 'Y');
1412:
1413: IF (l_flag = 'Y') THEN

Line 1432: FROM so_line_Details

1428: BEGIN
1429:
1430: SELECT SUM(NVL(quantity,0))
1431: INTO l_qty
1432: FROM so_line_Details
1433: WHERE line_id = X_line_id
1434: AND NVL(included_item_flag, 'N') = 'N'
1435: AND NVL(released_flag, 'Y') = 'Y'
1436: AND NVL(configuration_item_flag, 'N') =