APPS.PO_VAL_LINES dependencies on PO_LINE_LOCATIONS_ALL

Line 334: FROM PO_LINE_LOCATIONS_ALL PLL

330: WHEN PLL.shipment_type <> c_STANDARD THEN 0
331: ELSE GREATEST(NVL(PLL.quantity_billed, 0),
332: NVL(PLL.quantity_financed, 0))
333: END)), 0) sum_qty_bill_actuals
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

Line 718: FROM PO_LINE_LOCATIONS_ALL PLL

714: END
715: ELSE GREATEST(NVL(PLL.amount_billed, 0),
716: NVL(PLL.amount_financed, 0))
717: END)), 0) sum_amt_bill_actuals
718: FROM PO_LINE_LOCATIONS_ALL PLL
719: , PO_SESSION_GT GTT
720: WHERE PLL.po_line_id = p_line_id_tbl(i)
721: AND GTT.key = l_gt_key
722: AND GTT.index_num1(+) = PLL.po_line_id

Line 1581: FROM PO_LINE_LOCATIONS_ALL PLL

1577: FROM
1578: ( SELECT
1579: NVL(MAX(quantity_received), 0) max_qty_recv,
1580: NVL(MAX(quantity_billed), 0) max_qty_bill
1581: FROM PO_LINE_LOCATIONS_ALL PLL
1582: WHERE PLL.po_line_id = p_line_id_tbl(i)
1583: AND PLL.payment_type = c_MILESTONE
1584: AND PLL.value_basis = c_QUANTITY
1585: AND PLL.shipment_type = c_STANDARD

Line 1670: FROM PO_LINE_LOCATIONS_ALL PLL

1666: WHEN PLL.quantity_billed > 0
1667: THEN NVL(PLL.price_override, 0)
1668: ELSE 0
1669: END),0) sum_price_executed
1670: FROM PO_LINE_LOCATIONS_ALL PLL
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

Line 2440: PO_LINE_LOCATIONS_ALL POLL

2436: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
2437: FROM
2438: ( SELECT NVL(SUM(POLL.retainage_withheld_amount),0) amount_retained
2439: FROM
2440: PO_LINE_LOCATIONS_ALL POLL
2441: WHERE
2442: POLL.po_line_id = p_line_id_tbl(i)
2443: ) LOCATIONS_TOTAL
2444: WHERE