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 1429: FROM po_line_locations_all

1425: -- SQL What: Returns the number of shipments of this line that are
1426: -- either received and accrued, or invoiced.
1427: SELECT count(*)
1428: INTO l_accrue_invoice_count
1429: FROM po_line_locations_all
1430: WHERE (po_line_id = p_po_line_id)
1431: AND ((NVL(quantity_received,0) > 0 AND accrue_on_receipt_flag = 'Y')
1432: OR (NVL(quantity_billed,0) > 0));
1433:

Line 1469: FROM po_line_locations_all pll

1465: IF (l_is_financing_po) THEN
1466: -- SQL What: See if the delivery shipment has been executed against
1467: SELECT COUNT(*)
1468: INTO l_accrue_invoice_count
1469: FROM po_line_locations_all pll
1470: WHERE po_line_id = p_po_line_id
1471: AND pll.payment_type = 'DELIVERY'
1472: AND ( ( NVL(quantity_received,0) > 0
1473: AND accrue_on_receipt_flag = 'Y'

Line 1503: FROM rcv_transactions_interface RTI, po_line_locations_all PLL

1499: INTO l_pending_rcv_transactions
1500: FROM dual
1501: WHERE EXISTS
1502: ( SELECT 1
1503: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1504: WHERE PLL.po_line_id = p_po_line_id
1505: AND RTI.po_line_location_id = PLL.line_location_id -- JOIN
1506: AND RTI.transaction_status_code = 'PENDING' );
1507:

Line 1580: p_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,

1576: -------------------------------------------------------------------------------
1577: PROCEDURE check_rel_price_updateable (
1578: p_api_version IN NUMBER,
1579: x_return_status OUT NOCOPY VARCHAR2,
1580: p_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,
1581: p_from_price_break IN VARCHAR2,
1582: p_add_reasons_to_msg_list IN VARCHAR2,
1583: x_price_updateable OUT NOCOPY VARCHAR2,
1584: x_retroactive_price_change OUT NOCOPY VARCHAR2

Line 1593: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;

1589: l_api_version CONSTANT NUMBER := 1.0;
1590: l_progress VARCHAR2(3) := '000';
1591:
1592: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1593: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1594: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1595: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1596: l_pending_rcv_transactions NUMBER;
1597: -- Bug 3565522

Line 1594: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;

1590: l_progress VARCHAR2(3) := '000';
1591:
1592: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1593: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1594: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1595: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1596: l_pending_rcv_transactions NUMBER;
1597: -- Bug 3565522
1598: l_archive_mode_rel PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

Line 1595: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;

1591:
1592: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1593: l_qty_received PO_LINE_LOCATIONS.quantity_received%TYPE;
1594: l_accrue_flag PO_LINE_LOCATIONS.accrue_on_receipt_flag%TYPE;
1595: l_qty_billed PO_LINE_LOCATIONS.quantity_billed%TYPE;
1596: l_pending_rcv_transactions NUMBER;
1597: -- Bug 3565522
1598: l_archive_mode_rel PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
1599: l_current_org_id NUMBER;

Line 1633: FROM po_line_locations_all PLL,

1629: INTO l_qty_received,
1630: l_accrue_flag,
1631: l_qty_billed,
1632: l_allow_price_override
1633: FROM po_line_locations_all PLL,
1634: po_lines_all POL
1635: WHERE PLL.line_location_id = p_line_location_id
1636: AND PLL.po_line_id = POL.po_line_id; -- JOIN
1637: