[Home] [Help]
1415: -- SQL What: Returns the number of shipments of this line that are
1416: -- either received and accrued, or invoiced.
1417: SELECT count(*)
1418: INTO l_accrue_invoice_count
1419: FROM po_line_locations_all
1420: WHERE (po_line_id = p_po_line_id)
1421: AND ((NVL(quantity_received,0) > 0 AND accrue_on_receipt_flag = 'Y')
1422: OR (NVL(quantity_billed,0) > 0));
1423:
1455: IF (l_is_financing_po) THEN
1456: -- SQL What: See if the delivery shipment has been executed against
1457: SELECT COUNT(*)
1458: INTO l_accrue_invoice_count
1459: FROM po_line_locations_all pll
1460: WHERE po_line_id = p_po_line_id
1461: AND pll.payment_type = 'DELIVERY'
1462: AND ( ( NVL(quantity_received,0) > 0
1463: AND accrue_on_receipt_flag = 'Y'
1489: INTO l_pending_rcv_transactions
1490: FROM dual
1491: WHERE EXISTS
1492: ( SELECT 1
1493: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1494: WHERE PLL.po_line_id = p_po_line_id
1495: AND RTI.po_line_location_id = PLL.line_location_id -- JOIN
1496: AND RTI.transaction_status_code = 'PENDING' );
1497:
1566: -------------------------------------------------------------------------------
1567: PROCEDURE check_rel_price_updateable (
1568: p_api_version IN NUMBER,
1569: x_return_status OUT NOCOPY VARCHAR2,
1570: p_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,
1571: p_from_price_break IN VARCHAR2,
1572: p_add_reasons_to_msg_list IN VARCHAR2,
1573: x_price_updateable OUT NOCOPY VARCHAR2,
1574: x_retroactive_price_change OUT NOCOPY VARCHAR2
1619: INTO l_qty_received,
1620: l_accrue_flag,
1621: l_qty_billed,
1622: l_allow_price_override
1623: FROM po_line_locations_all PLL,
1624: po_lines_all POL
1625: WHERE PLL.line_location_id = p_line_location_id
1626: AND PLL.po_line_id = POL.po_line_id; -- JOIN
1627: