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.PO_DOCUMENT_CHECKS_GRP dependencies on PO_LINE_LOCATIONS

Line 1419: FROM po_line_locations_all

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:

Line 1459: FROM po_line_locations_all pll

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'

Line 1493: FROM rcv_transactions_interface RTI, po_line_locations_all PLL

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:

Line 1570: p_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,

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

Line 1583: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;

1579: l_api_version CONSTANT NUMBER := 1.0;
1580: l_progress VARCHAR2(3) := '000';
1581:
1582: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1583: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1584: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1585: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1586: l_pending_rcv_transactions NUMBER;
1587: -- Bug 3565522

Line 1584: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;

1580: l_progress VARCHAR2(3) := '000';
1581:
1582: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1583: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1584: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1585: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1586: l_pending_rcv_transactions NUMBER;
1587: -- Bug 3565522
1588: l_archive_mode_rel PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

Line 1585: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;

1581:
1582: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1583: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1584: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1585: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1586: l_pending_rcv_transactions NUMBER;
1587: -- Bug 3565522
1588: l_archive_mode_rel PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
1589: l_current_org_id NUMBER;

Line 1623: FROM po_line_locations_all PLL,

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: