APPS.OE_QUERY dependencies on SO_PICKING_LINE_DETAILS

Line 367: FROM SO_PICKING_LINE_DETAILS

363: BEGIN
364:
365: SELECT SUM(NVL(REQUESTED_QUANTITY,0))
366: INTO rel_qty
367: FROM SO_PICKING_LINE_DETAILS
368: WHERE PICKING_LINE_ID = P_LINE_ID
369: AND NVL(RELEASED_FLAG,'N')='Y';
370: RETURN (rel_qty);
371:

Line 1475: FROM so_picking_line_details

1471: BEGIN
1472:
1473: SELECT NVL( SUM( NVL(requested_quantity,0)), 0)
1474: INTO l_num
1475: FROM so_picking_line_details
1476: WHERE schedule_status_code = 'RESERVED'
1477: AND picking_line_id = X_picking_line_id;
1478:
1479: RETURN(l_num);

Line 1487: -- quantity in the SO_PICKING_LINE_DETAILS table for unreleased details.

1483:
1484: --
1485: -- Open_Backordered_Quantity: This function returns the unreleased quantity
1486: -- from the backordered picking lines for a given line. It sums up the
1487: -- quantity in the SO_PICKING_LINE_DETAILS table for unreleased details.
1488: -- This function ignores picking lines for included items.
1489: -- For ATO Model lines, this quantity will be the backorered amount of the
1490: -- config item
1491: -- For Option Lines for ATO Models, it will return 0, as the options for ATO

Line 1509: so_picking_line_details pld

1505: SELECT Nvl(SUM(pld.requested_quantity),0)
1506: INTO l_backordered_quantity
1507: FROM
1508: so_picking_lines pl,
1509: so_picking_line_details pld
1510: WHERE
1511: Nvl(pld.released_flag, 'Y') = 'N'
1512: AND pld.picking_line_id = pl.picking_line_id
1513: AND pl.picking_header_id = 0

Line 1702: FROM SO_PICKING_LINE_DETAILS SPLD

1698: 'DEMANDED' ),
1699: 'SUPPLY RESERVED' ),
1700: 'RESERVED' )
1701: INTO schedule_status_code
1702: FROM SO_PICKING_LINE_DETAILS SPLD
1703: WHERE SPLD.PICKING_LINE_ID = P_LINE_ID;
1704:
1705: if ( schedule_status_code is not null )
1706: then

Line 1742: FROM SO_PICKING_LINE_DETAILS SPLD

1738: 'DEMANDED' ),
1739: 'SUPPLY RESERVED' ),
1740: 'RESERVED' )
1741: INTO schedule_status_code
1742: FROM SO_PICKING_LINE_DETAILS SPLD
1743: WHERE SPLD.PICKING_LINE_ID = P_LINE_ID;
1744:
1745: return( SCHEDULE_STATUS_CODE );
1746: