APPS.PO_VAL_LINES dependencies on PO_LINES_ALL

Line 452: ) POLL_TOTAL, PO_LINES_ALL POL

448: FROM PO_LINE_LOCATIONS_ALL PLL
449: WHERE PLL.po_line_id = p_line_id_tbl(i)
450: AND NVL(PLL.payment_type, c_DELIVERY) <> c_MILESTONE
451: )
452: ) POLL_TOTAL, PO_LINES_ALL POL
453: WHERE
454: POL.po_line_id = p_line_id_tbl(i)
455: AND p_quantity_tbl(i) IS NOT NULL
456: -- Quantity is being reduced below the current transaction quantity:

Line 985: , PO_LINES_ALL POL

981: AND GTT.key = l_gt_key
982: AND GTT.index_num1(+) = PLL.po_line_id
983: )
984: ) POLL_TOTAL
985: , PO_LINES_ALL POL
986: WHERE
987: POL.po_line_id = p_line_id_tbl(i)
988: AND p_amount_tbl(i) IS NOT NULL
989: -- Amount is being reduced below the current transaction amount:

Line 1084: , PO_LINES_ALL LINE

1080: l_line_id_tbl
1081: , l_amount_tbl
1082: FROM
1083: PO_SESSION_GT SES
1084: , PO_LINES_ALL LINE
1085: , PO_HEADERS_ALL HEADER
1086: WHERE
1087: SES.key = l_data_key
1088: AND LINE.po_line_id = SES.num1

Line 2209: , PO_LINES_ALL SAVED_LINE

2205: , l_price_break_lookup_code_tbl
2206: , l_amount_changed_flag_tbl -- --
2207: FROM
2208: PO_SESSION_GT SES
2209: , PO_LINES_ALL SAVED_LINE
2210: WHERE
2211: SES.key = l_data_key
2212: AND SAVED_LINE.po_line_id = SES.num1
2213: AND SAVED_LINE.order_type_lookup_code IN (c_QUANTITY, c_RATE)

Line 2462: ) POLL_TOTAL, PO_LINES_ALL POL

2458: AND PLL.payment_type = c_MILESTONE
2459: AND PLL.value_basis = c_QUANTITY
2460: AND PLL.shipment_type = c_STANDARD
2461: )
2462: ) POLL_TOTAL, PO_LINES_ALL POL
2463: WHERE
2464: POL.po_line_id = p_line_id_tbl(i)
2465: AND p_quantity_tbl(i) IS NOT NULL
2466: AND p_quantity_tbl(i) < POL.quantity

Line 2550: ) POLL_TOTAL, PO_LINES_ALL POL

2546: WHERE PLL.po_line_id = p_line_id_tbl(i)
2547: AND PLL.payment_type = c_MILESTONE
2548: AND PLL.value_basis = c_QUANTITY
2549: AND PLL.shipment_type = c_STANDARD
2550: ) POLL_TOTAL, PO_LINES_ALL POL
2551: WHERE
2552: POL.po_line_id = p_line_id_tbl(i)
2553: AND p_price_tbl(i) IS NOT NULL
2554: AND p_price_tbl(i) < POL.unit_price