APPS.PO_VAL_LINES dependencies on PO_LINES_ALL

Line 338: ) POLL_TOTAL, PO_LINES_ALL POL

334: FROM PO_LINE_LOCATIONS_ALL PLL
335: WHERE PLL.po_line_id = p_line_id_tbl(i)
336: AND NVL(PLL.payment_type, c_DELIVERY) <> c_MILESTONE
337: )
338: ) POLL_TOTAL, PO_LINES_ALL POL
339: WHERE
340: POL.po_line_id = p_line_id_tbl(i)
341: AND p_quantity_tbl(i) IS NOT NULL
342: -- Quantity is being reduced below the current transaction quantity:

Line 725: , PO_LINES_ALL POL

721: AND GTT.key = l_gt_key
722: AND GTT.index_num1(+) = PLL.po_line_id
723: )
724: ) POLL_TOTAL
725: , PO_LINES_ALL POL
726: WHERE
727: POL.po_line_id = p_line_id_tbl(i)
728: AND p_amount_tbl(i) IS NOT NULL
729: -- Amount is being reduced below the current transaction amount:

Line 824: , PO_LINES_ALL LINE

820: l_line_id_tbl
821: , l_amount_tbl
822: FROM
823: PO_SESSION_GT SES
824: , PO_LINES_ALL LINE
825: , PO_HEADERS_ALL HEADER
826: WHERE
827: SES.key = l_data_key
828: AND LINE.po_line_id = SES.num1

Line 1335: , PO_LINES_ALL SAVED_LINE

1331: l_line_id_tbl
1332: , l_price_break_lookup_code_tbl
1333: FROM
1334: PO_SESSION_GT SES
1335: , PO_LINES_ALL SAVED_LINE
1336: WHERE
1337: SES.key = l_data_key
1338: AND SAVED_LINE.po_line_id = SES.num1
1339: AND SAVED_LINE.order_type_lookup_code IN (c_QUANTITY, c_RATE)

Line 1587: ) POLL_TOTAL, PO_LINES_ALL POL

1583: AND PLL.payment_type = c_MILESTONE
1584: AND PLL.value_basis = c_QUANTITY
1585: AND PLL.shipment_type = c_STANDARD
1586: )
1587: ) POLL_TOTAL, PO_LINES_ALL POL
1588: WHERE
1589: POL.po_line_id = p_line_id_tbl(i)
1590: AND p_quantity_tbl(i) IS NOT NULL
1591: AND p_quantity_tbl(i) < POL.quantity

Line 1675: ) POLL_TOTAL, PO_LINES_ALL POL

1671: WHERE PLL.po_line_id = p_line_id_tbl(i)
1672: AND PLL.payment_type = c_MILESTONE
1673: AND PLL.value_basis = c_QUANTITY
1674: AND PLL.shipment_type = c_STANDARD
1675: ) POLL_TOTAL, PO_LINES_ALL POL
1676: WHERE
1677: POL.po_line_id = p_line_id_tbl(i)
1678: AND p_price_tbl(i) IS NOT NULL
1679: AND p_price_tbl(i) < POL.unit_price