APPS.PO_VAL_SHIPMENTS dependencies on PO_LINE_LOCATIONS_ALL

Line 1072: PO_LINE_LOCATIONS_ALL PLL

1068: END
1069: )
1070: --End PBWC Message Change Impact: Adding a token
1071: FROM
1072: PO_LINE_LOCATIONS_ALL PLL
1073: WHERE
1074: PLL.line_location_id = p_line_loc_id_tbl(i)
1075: AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT) --
1076: AND p_quantity_tbl(i) IS NOT NULL

Line 1297: PO_LINE_LOCATIONS_ALL PLL

1293: ELSE TO_CHAR(amount_billed)
1294: END
1295: )
1296: FROM
1297: PO_LINE_LOCATIONS_ALL PLL
1298: WHERE
1299: PLL.line_location_id = p_line_loc_id_tbl(i)
1300: AND PLL.shipment_type IN (c_STANDARD, c_PREPAYMENT) --
1301: AND p_amount_tbl(i) IS NOT NULL

Line 1534: FROM PO_LINE_LOCATIONS_ALL

1530: FROM DUAL
1531: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
1532: AND not exists
1533: (SELECT 'Y'
1534: FROM PO_LINE_LOCATIONS_ALL
1535: WHERE line_location_id = p_line_loc_id_tbl(i)
1536: AND quantity > quantity_received);
1537:
1538: IF (SQL%ROWCOUNT > 0) THEN